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_ACCT_ATTRIBUTES_TL |
The XLA_ACCT_ATTRIBUTES_TL table captures translated values for the accounting attributes. Accounting attribut | standalone |
XLA_SEG_RULES_TL |
The XLA_SEG_RULES_TL table stores translated information about segment rules. | standalone |
XLA_DESCRIPT_DETAILS_TL |
The XLA_DESCRIPT_DETAILS_TL table stores the translation details of a description. | standalone |
XLA_LINE_DEFINITIONS_TL |
This table stores translated information about journal lines definitions. | standalone |
XLA_ANALYTICAL_HDRS_B |
This table stores the header information for the Analytical Criteria. Since some analytical criteria are deliv | 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_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_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_SUBLEDGERS |
The XLA_SUBLEDGERS stores information that depend on the application. It includes a row for each application, | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
XLA_MO_REPORTING_API |
API | 8 | 24 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_TB_BALANCE_PUB |
PUB | 2 | 1 packages |
XLA_UPG_VERIFICATION_PUB |
PUB | 8 | 0 packages |