XLA — Subledger Accounting
153 documented tables · 165 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
XLA_ENTITY_TYPES_B |
The XLA_ENTITY_TYPES_B table stores all event entities that are used to group event classes. | hub-leaning |
XLA_MAPPING_SETS_TL |
The XLA_MAPPING_SETS_TL table stores all translated information about mapping sets. | standalone |
XLA_AAD_HEADER_AC_ASSGNS |
Store the analytical criteria for the application accounting definitions. | standalone |
XLA_ACCT_ATTRIBUTES_TL |
The XLA_ACCT_ATTRIBUTES_TL table captures translated values for the accounting attributes. Accounting attribut | standalone |
XLA_EXTRACT_OBJECTS |
It stores the extract object name and type used by the Accounting Program to derive sources for an event class | standalone |
XLA_CONTROL_BALANCES |
The XLA_CONTROL_BALANCES table stores the balances for each third party control account. | link |
XLA_MAPPING_SETS_B |
The XLA_MAPPING_SETS_B table stores Mapping Sets created by End Users. These mapping sets are then used in the | satellite-leaning |
XLA_ACCTG_METHODS_B |
The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by de | standalone |
XLA_SUBLEDGERS |
The XLA_SUBLEDGERS stores information that depend on the application. It includes a row for each application, | standalone |
XLA_TAB_ACCT_DEFS_B |
The XLA_TAB_ACCT_DEFS_B table stores all Transaction Account Definitions. | standalone |
XLA_EVENT_CLASS_GRPS_B |
The table XLA_EVENT_CLASS_GRPS_B record groups of event classes for processing purpose. | standalone |
XLA_SEG_RULES_B |
The XLA_SEG_RULES_B table stores all account derivation. These account derivation rules are then attached to a | standalone |
XLA_LEDGER_OPTIONS |
This table stores the ledger level default setup information for an application. | standalone |
XLA_EVENTS |
The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_A | standalone |
XLA_ANALYTICAL_DTLS_TL |
The XLA_ANALYTICAL_DTLS_TL table stores the detail information for the Analytical Criterion. | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
XLA_EVENTS_PUB_PKG |
PUB | 23 | 69 packages |
XLA_MO_REPORTING_API |
API | 8 | 24 packages |
XLA_ACCOUNTING_PUB_PKG |
PUB | 6 | 9 packages |
XLA_DATAFIXES_PUB |
PUB | 9 | 7 packages |
XLA_THIRD_PARTY_MERGE_PUB |
PUB | 2 | 5 packages |
XLA_UPGRADE_PUB |
PUB | 5 | 4 packages |
XLA_ACCT_SETUP_PUB_PKG |
PUB | 2 | 1 packages |
XLA_TAB_PUB_PKG |
PUB | 1 | 1 packages |
XLA_TB_BALANCE_PUB |
PUB | 2 | 1 packages |
XLA_REVERSE_EVENTS_PUB_PKG |
PUB | 2 | 0 packages |