General Ledger In Oracle Apps

General Ledger

• General Ledger is a central repository of all your financial transactions.
• All sub-ledger data (AR, AP, INV, WIP, etc.) eventually flows into General Ledger.
• At the end of each month, quarter, year one has to close your current period and open the next period on your transaction calendar.
• Financial reporting occurs out of your General Ledger.
• All financial statements are generated out of General Ledger.
• “Journal Import” is a “one stop” interface for any data that comes into GL from external sources (e.g: Sub Ledgers, external accounting systems, legacy data, etc.)
• You can recognize revenue in several currencies in a single installation of General Ledger.
• All the data from other modules will flow to GL. This data will be stored in XLA tables (subledger Accounting).
• Journal Import is the concurrent program which will send the data from XLA tables to GL base tables.

GL Tables in Oracle Apps

gl_je_headers

gl_je_lines

gl_je_batches

gl_set_of_books

gl_import_references

gl_code_combinations_kfv

gl_periods

gl_daily_rates

gl_ledgers

Subledger Tables

xla_ae_headers

xla_ae_lines

xla_distribution_links

xla_transaction_entities

Joins for GL Tables

GL_JE_HEADERS	JE_HEADER_ID
	JE_BATCH_ID
	EVENT_ID
GL_JE_LINES	JE_HEADER_ID
	JE_LINE_ID
GL_JE_BATCHES	JE_BATCH_ID
GL_IMPORT_REFERENCES	JE_HEADER_ID
	JE_LINE_ID
	JE_LINE_NUM
	GL_SL_LINK_TABLE
	GL_SL_LINK_ID
XLA_AE_HEADERS	GL_SL_LINK_TABLE
	GL_SL_LINK_ID
XLA_AE_LINES	GL_SL_LINK_TABLE
	GL_SL_LINK_ID
XLA_EVENTS	EVENT_ID
	ENTITY_ID
XLA_TRANSACTION_ENTITIES	ENTITY_ID