I have been working on a Sub-Ledger Accounting and I could get a fair idea of how data is being transferred from XLA_DISTRIBUTION_LINKS to XLA_AE_LINES and XLA_AE_HEADERS. As per my understanding, During "Create Accounting" process, data from XLA_DISTRIBUTION_LINKS will be summed up based on JOUNRAL_LINE_TYPES rules and conditions to load into XLA_AE_LINES and XLA_AE_HEADERS. Then during "Transfer to GL" process, data from XLA_AE_LINES and XLA_AE_HEADERS is transferred to GL Tables. What I didn't understand is how and When data gets loaded into XLA_DISTRIBUTION_LINKS. What are the rules and conditions and during which step data will be loaded to XLA_DISTRIBUTION_LINKS table? Can somebody please explain me how data is transferred from Sub-Ledger Distribution Tables to SLA Distribution Table?
Hi, you might take a look at the following notes :
- R12: FAQ on Transfer to GL in R12 [ID 876190.1]
- How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger? [ID 813968.1]
- FAQ on Subledger or XLA to GL Transfer Process In R12 [ID 1325133.1]
- R12 Mapping Between Subledger Tables, SLA and GL Tables [ID 871622.1]
- Unable To Link XLA Tables With AR Tables To Get Information From GL (General Ledger / Subledger / Receivables) [ID 879072.1]
Above Notes are good.
But I just wanted to add a staight point.
xla_distribution_links and xla_ae_lines will get populated at the same time.
Both goes on JLTs and their conditions. One is detailed and the other is summarized / merged.
xla_ae_lines will have extra balancing lines and xla_distirbution_links will have extra gain / loss lines, which end up with zero amount.
Also check the links for the setup of distribution identifiers.
Frankly, I didn't understand what are you looking for.
There is no API for that. In the normal process of Create Accounting, that will happen.
Even though if you play around with the data in these tables and the event is not stamped as processed, next time when you run create accounting, it will override the same.
All I am trying to find out is find the back end package which will be populating the data into XLA_DISTRIBUTION_LINKS and XLA_AE_LINES.
Also Can you please look into the other thread I have created regarding Amount Reconciliation? Will you be able to help me with that?