Saturday, March 18, 2017

SLA Data Flow and Table Links

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 : 


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


Fore more information see : SLA Data Flow and Table Links (Doc ID 802966.1)

No comments:

Post a Comment

Powered By Blogger