Important General Ledger GL table details in Oracle Apps R12

 Important General Ledger GL table details in Oracle Apps R12

GL_LEDGER: This table stores GL ledger details

GL_JE_HEADERS: This Table stores GL Journals Header Information. this table has important Columns such as  NAME, JE_SOURCE, PERIOD_NAME, CURRENCY_CODE, STATUS

GL_JE_LINES: This Table stores GL Journals Lines Information, this table has important columns such as ACCOUNTED_DR, ACCOUNTED_CR, ENTERED_DR, ENTERED_CR, CODE_COMBINATION_ID

GL_JE_BATCHES: This table stores GL Journal Batches Information’s. this table has important columns such as BATCH_NAME, total Batch CR and DR amount

GL_CODE_COMBINATIONS: This table stores General Ledger (GL) code combinations information’s. some important columns of this table are CODE_COMBINATION_ID AND CHART_OF_ACCOUNT_ID.

GL_IMPORT_REFERENCES: Table uses to join the GL journals with the Subledger Transactions’. important Columns are GL_SL_LINK_ID link with the GL_SL_LINK_ID column of apps.xla_ae_lines table

GL_PERIODS: This table Stores General Ledger (GL) periods name, Start and End of the Period.

GL_DAILY_CURRENCIES: This table stores the General Ledger (GL) currencies with daily rates in the system.

GL_CURRENCIES: This table stores all the General Ledger (GL) currencies Information, this is the Master of the Currencies uses in the General Ledger.

Query to Get GL balances in Oracle Apps R12

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

SELECT         substr(B.name,1,35) batch , substr(H.name,1,15) journal ,         substr(JE_LINE_NUM,1,4)    J_LN , SUBSTR (h.JE_SOURCE,1,9)   SOURCE , SUBSTR (l.PERIOD_NAME,1,6) PERIOD , l.accounteD_DR             DBT     , l.accounted_cr             CRDT     , SUBSTR(L.DESCRIPTION,1,50) DSC FROM gl_je_lines L, gl_je_headers H,         gl_je_batches B,         GL_CODE_COMBINATIONS GLC WHERE         l.je_header_id=h.je_header_id  and         b.je_batch_id = h.je_batch_id  and      h.ACTUAL_FLAG = 'A'        and upper(l.period_name) in ('JAN-21');