GL tables in oracle fusion

GL tables in oracle fusion

In this post , we will be discuss about GL tables in oracle fusion. We are sharing , all important gl tables in oracle fusion. These GL tables , helps to store the different types of gl informations in oracle fusion. If we do compare the GL tables with Oracle apps , then there is no big difference between the GL tables in oracle fusion. GL tables in oracle fusion , helps to develop the custom BIP reports in oracle fusion. Using these GL tables , we can extract the gl data from oracle fusion application. Here below is the complete detail about GL tables in oracle fusion.

9 Important GL tables in oracle fusion

1.GL_LEDGERS

2.GL_JE_HEADERS

3.GL_JE_LINES

4.GL_CODE_COMBINATIONS

5.GL_JE_BATCHES

6.GL_IMPORT_REFERENCES

7.GL_PERIODS

8.GL_CURRENCIES

9.GL_DAILY_RATES

GL tables in oracle fusion

gl_ledgers

select * from apps.gl_ledgers where ledger_id=:LEDGER_ID

This Table Stores the GL Ledger detail in Oracle Fusion

gl_je_headers

select * from apps.gl_je_headers

This Table stores GL Journals Header Information. Important Columns of this Table is NAME,JE_SOURCE,PERIOD_NAME,CURRENCY_CODE,STATUS

gl_je_lines

select * from apps.gl_je_lines

This Table stores GL Journals Lines Information. Important Columns of this table ACCOUNTED_DR,ACCOUNTED_CR,ENTERED_DR,ENTERED_CR,CODE_COMBINATION_ID

GL_code_combinations

‘This table stores GL code combinations informations.Important columns of this table is ‘CODE_COMBINATION_ID’ AND CHART_OF_ACCOUNT_ID’

SELECT * FROM apps.GL_code_combinations

GL_JE_BATCHES 

This table stores GL Journal Batches Informations.

Important Columns of the Table is ‘BATCH_NAME’, total Batch CR and Dr amount.

select * from apps.gl_je_batches

GL_IMPORT_REFERENCES

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

Select * from apps.GL_IMPORT_REFERENCES

GL_PERIODS 

‘This table Stores GL periods name and the Start and End of the Period.

select * from apps.gl_periods

GL_CURRENCIES

This table stores all the GL currencies Information or we can say 'Master of the Currencies uses in the General Ledger'.

GL_DAILY_RATES 

Select * from apps.gl_daily_rates

This table stores the GL currencies Daily rates in the system.

Important SQL Queries Using GL tables in oracle Fusion

select
 b.FORM_LEFT_PROMPT "Chart Of Account Segment Name",
 b.description,
 a.segment_name "CCA_VALUSET",
 c.ID_FLEX_STRUCTURE_NAME "Chart Of Account Structure Name" ,
 b.application_column_name "Internal Segment"
 from
 apps.FND_ID_FLEX_SEGMENTS a,
 apps.FND_ID_FLEX_SEGMENTS_TL b,
 apps.FND_ID_FLEX_STRUCTURES_VL c
 where
 b.language = 'US'
and c.ID_FLEX_NUM = b.ID_FLEX_NUM
 and c.enabled_flag = 'Y'
and b.application_id = a.application_id
 and b.id_flex_num = a.id_flex_num
 and b.application_column_name = a.application_column_name
 and a.application_id = 101

GL tables in oracle fusion