Biradar ShriKant Oracle Apps Blog

  GOAL :  How does the data flow from Inventory (Material transactions coming from Inventory,WIP, and Receiving) to General Ledger(GL)?  What are the tables that are involved? SOLUTION :  Subledger Accounting (SLA) Data Flow Chart   Important columns affected: After a transaction is performed in forms : mtl_material_transactions.costed_flag = 'N' After the Cost Manager Picks up the data and processes it : mtl_material_transactions.costed_flag is Null xla_events.event_status_code = 'U' xla_events.process_status_code = 'U' After the Create Accounting - Cost Management is run : xla_events.event_status_code = 'P' xla_events.process_status_code = 'P' xla_ae_headers.gl_transfer_status_code = 'N' xla_ae_headers.gl_transfer_date is Null After the Transfer To GL is run : xla_ae_headers.gl_transfer_status_code = 'Y' xla_ae_headers.gl_transfer_date is Not Null Queries involved: select * from mtl_material_transactions where transaction_id = ...

Oracle Subledger Accounting Tables: TABLE NAME DESCRIPTION XLA_AAD_GROUPS The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis.  All application accounting definitions with the same GROUP_NUM must be merged together. XLA_AAD_HDR_ACCT_ATTRS The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level. XLA_AAD_HEADER_AC_ASSGNS Store the analytical criteria for the application accounting definitions. XLA_AAD_LINE_DEFN_ASSGNS This table stores the journal lines definitions for the application accounting definitions. XLA_AAD_LOADER_DEFNS_T The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database. XLA_AAD_LOADER_LOGS The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader. XLA_AAD_SOURCES XLA_AAD_SOURCES table stores a list of sources used by an Application Accounti...