Oracle Fusion ERP – Query to Fetch-Ledger, Balance Cube Details

by admin

SELECT 
 gl.ledger_id, 
 gl.name ledger_name, 
  gbc.cube_id,
  gbc.APPLICATION_NAME,
  gbc.cube_name,
  gbc.CUBE_TYPE,
  gbc.ESSBASE_SERVER_PORT
  
 FROM GL_LEDGERS GL, GL_BALANCES_CUBES  GBC

WHERE 1=1

AND gl.CHART_OF_ACCOUNTS_ID  = gbc.CHART_OF_ACCOUNTS_ID
AND gl.PERIOD_SET_NAME = gbc.PERIOD_SET_NAME

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleSaaSQueries