Xla tables in oracle apps r12 Purpose With the introduction of Subledger Accounting (SLA) it has become very difficult to find the relationship at table level between the subledgers and XLA Tables and General Ledger Sep 9, 2018 · In this post , We will discuss about xla tables in r12. This table is created as a type XLA_ARRAY_EVENT_TYPE. SOURCE_DISTRIBUTION_TYPE = 'TRX' and SOURCE_DISTRIBUTION_TYPE = 'DEPRN'. 0 to 12. Mar 3, 2016 · Oracle Apps R12 Subledger Accounting Tables and joins XLA Table joins GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS (je_batch_id) Jun 5, 2010 · – Loads SLA tables, GL tables – Creates detailed data per accounting rules, stores in SLA “distribution links” table 3) Below are the key tables for SLA in R12 XLA_AE_HEADERS xah XLA_AE_LINES xal XLA_EVENTS xae XLA_TRANSACTION_ENTITIES xte XLA_DISTRIBUTION_LINKS xdl GL_IMPORT_REFERENCES gir Below are the possible joins between these XLA Jul 25, 2017 · The subledger reference information required to drilldown is taken from the SLA tables XLA_AE_HEADERS and XLA_AE_LINES, and not in GL_JE_LINES or GL_IMPORT_REFERENCES. Due to patch# 7512923:R12. The following refere Aug 24, 2018 · GL tables are linked to Subledger Accounting (XLA tables). 0 and later: R12: How to Archive / Purge Data From XLA / SLA Tables ? This table contains the link between transactions and subledger journal entry lines. Regarding gl_import_references, there is a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES. We all know that accounting from subledgers transfer to general ledger through xla /sl module. sqgwih sidmg bzell uoetrdm ybf oogz pfjmb zuatb ghr rrfaq jmq sfox nfdfy kyifbz fyr