XLA Tables (153)
XLA - Subledger Accounting — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
XLA_AADS_GT |
15 | The XLA_AADS_GT table stores modified AMB Components. |
XLA_AADS_H |
18 | The XLA_AADS_H table stores the history of the application accounting definitions. The history is updated when the application accounting d |
XLA_AAD_GROUPS |
16 | The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis. All application accounting definitions with the |
XLA_AAD_HDR_ACCT_ATTRS |
17 | The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level. |
XLA_AAD_HEADER_AC_ASSGNS |
15 | Store the analytical criteria for the application accounting definitions. |
XLA_AAD_LINE_DEFN_ASSGNS |
15 | This table stores the journal lines definitions for the application accounting definitions. |
XLA_AAD_LOADER_DEFNS_T |
161 | The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database. |
XLA_AAD_LOADER_LOGS |
27 | The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader. |
XLA_AAD_SOURCES |
26 | XLA_AAD_SOURCES table stores a list of sources used by an Application Accounting Definition. The table captures sources used by each event |
XLA_ACCOUNTING_ERRORS |
20 | The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program. |
XLA_ACCTG_METHODS_B |
11 | The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of acc |
XLA_ACCTG_METHODS_TL |
12 | The XLA_ACCTG_METHODS_TL table stores translated information about Subledger Accounting Methods. |
XLA_ACCTG_METHOD_RULES |
15 | The XLA_ACCTG_METHODS_RULES table stores the assignments for all Application Accounting Definitions (AAD) within each Subledger Accounting M |
XLA_ACCT_ATTRIBUTES_B |
14 | The XLA_ACCT_ATTRIBUTES_B table captures accounting attributes available to the end users. Accounting attributes are pre-defined by the Orac |
XLA_ACCT_ATTRIBUTES_TL |
10 | The XLA_ACCT_ATTRIBUTES_TL table captures translated values for the accounting attributes. Accounting attributes are pre-defined by Subledge |
XLA_ACCT_CLASS_ASSGNS |
11 | This table stores the accounting class assignments for the Post-Accounting Programs. |
XLA_ACCT_LINE_TYPES_B |
26 | The XLA_ACCT_LINE_TYPES_B table stores line accounting types for an event class. |
XLA_ACCT_LINE_TYPES_TL |
16 | The XLA_ACCT_LINE_TYPES_TL table stores translated information about accounting line type definitions. |
XLA_AC_BALANCES |
29 | |
XLA_AC_BALANCES_INT |
52 | Supporting Reference Balances Interface table for importing initial balances |
XLA_AC_BAL_INTERIM_GT |
18 | Intermediate table used for Balance Computation |
XLA_AE_HEADERS |
72 | The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry |
XLA_AE_HEADERS_GT |
135 | |
XLA_AE_HEADER_ACS |
10 | This table stores the relationship between the subledger journal entry lines and the supporting reference detail values. |
XLA_AE_LINES |
73 | The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry heade |
XLA_AE_LINES_GT |
318 | |
XLA_AE_LINE_ACS |
11 | This table stores the relationship between the subledger journal entry lines and the analytical detail values. |
XLA_AE_SEGMENT_VALUES |
5 | The XLA_AE_SEGMENT_VALUES table stores information about the balancing or management segment values associated with the journal entry. |
XLA_AMB_COMPONENTS_H |
17 | The XLA_AMB_COMPONENTS_H table stores the history of the non-application specific journal entry setups, i.e. analytical criteria and mapping |
XLA_AMB_SETUP_ERRORS |
43 | The XLA_AMB_SETUP_ERRORS table stores errors reported by the Create and Assign Source program and the Application Accounting Definition vali |
XLA_AMB_UPDATED_COMPS |
44 | The XLA_AMB_UPDATED_COMPS table stores the application accounting definitions and journal entry setups that has been updated. |
XLA_ANALYTICAL_ASSGNS |
17 | The XLA_ANALYTICAL_ASSGNS table stores the assignment between the Analytical Criteria and the Application Accounting Definition headers or t |
XLA_ANALYTICAL_BALANCES |
25 | The XLA_ANALYTICAL_BALANCES table stores the balances for each analytical criterion. |
XLA_ANALYTICAL_DTLS_B |
13 | The XLA_ANALYTICAL_DTLS_B table stores the translated header information (name and description) for the Analytical Criteria. |
XLA_ANALYTICAL_DTLS_TL |
14 | The XLA_ANALYTICAL_DTLS_TL table stores the detail information for the Analytical Criterion. |
XLA_ANALYTICAL_DTL_VALS |
24 | The XLA_ANALYTICAL_DTL_VALS table stores the existing values for the analytical criteria details based on the actual data on the sources for |
XLA_ANALYTICAL_HDRS_B |
18 | This table stores the header information for the Analytical Criteria. Since some analytical criteria are delivered as seeded data by the pro |
XLA_ANALYTICAL_HDRS_TL |
13 | The XLA_ANALYTICAL_HDRS_TL table stores the translated header information (name and description) for the Analytical criteria. |
XLA_ANALYTICAL_SOURCES |
16 | The XLA_ANALYTICAL_SOURCES table stores the assignment between the Analytical Criteria detail and the sources. |
XLA_APPLI_AMB_CONTEXTS |
12 | The XLA_APPLI_AMB_CONTEXTS table stores the information for the application and the AMB contexts. |
XLA_ASSIGNMENT_DEFNS_B |
12 | This table stores the ledger assignments for the Post-Accountng Programs. |
XLA_ASSIGNMENT_DEFNS_TL |
13 | This table stores the translated columns for accounting class ledger assignments. |
XLA_BALANCE_STATUSES |
23 | The XLA_BALANCE_STATUSES table stores the status of the balance for a code combination Id and allows the simultaneous execution of the balan |
XLA_BAL_AC_CTRBS_GT |
20 | |
XLA_BAL_CONCURRENCY_CONTROL |
6 | Table used for locking purpose in balances |
XLA_CONDITIONS |
31 | The XLA_CONDITIONS table stores the conditions for an accounting line or header types, segment rules and descriptions. |
XLA_CONDITIONS_T |
21 | Interface table to load the conditions associated to the ADR rule details into SLA. |
XLA_CONTROL_BALANCES |
28 | The XLA_CONTROL_BALANCES table stores the balances for each third party control account. |
XLA_CTRL_BALANCES_INT |
52 | The temporary table stores the balances for each third party control account. |
XLA_CTRL_BAL_INTERIM_GT |
13 | This table stores the interim-summarized data from the transactions (XLA_AE_LINES). |
XLA_DESCRIPTIONS_B |
12 | The XLA_DESCRIPTIONS_B table stores all descriptions created for an application. These descriptions are then attached to accounting header a |
XLA_DESCRIPTIONS_TL |
14 | The XLA_DESCRIPTIONS_TL table stores translated information about the descriptions. |
XLA_DESCRIPT_DETAILS_B |
16 | The XLA_DESCRIPT_DETAILS_B table stores the details of a description. It holds a string of literal and sources in the sequence in which they |
XLA_DESCRIPT_DETAILS_TL |
11 | The XLA_DESCRIPT_DETAILS_TL table stores the translation details of a description. |
XLA_DESC_PRIORITIES |
12 | The XLA_DESc_PRIORTIES table stores priority information about descriptions |
XLA_DIAG_EVENTS |
18 | Events processed by the diagnostic framework. |
XLA_DIAG_LEDGERS |
22 | Ledgers processed by the diagnostic framework. |
XLA_DIAG_SOURCES |
21 | Source values retrieved by the diagnostic framework from the Transaction Objects. |
XLA_DISTRIBUTION_LINKS |
85 | The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines. |
XLA_ENTITY_ID_MAPPINGS |
16 | The XLA_ENTITY_ID_MAPPINGS table stores the mapping of the primary key columns of the entity table of the event table. It contains one row f |
XLA_ENTITY_TYPES_B |
10 | The XLA_ENTITY_TYPES_B table stores all event entities that are used to group event classes. |
XLA_ENTITY_TYPES_TL |
12 | The XLA_ENTITY_TYPES_TL table record translated information related to entity. |
XLA_EVENTS |
36 | The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE. |
XLA_EVENTS_INT_GT |
43 | It is an interface table used to create accounting events in bulk.It is a temporary table. The information in this table is deleted upon COM |
XLA_EVENT_CLASSES_B |
10 | The XLA_EVENT_CLASSES_B table stores all event classes for an entity. |
XLA_EVENT_CLASSES_TL |
13 | The XLA_EVENT_CLASSES table record translated information related to event classes. |
XLA_EVENT_CLASS_ATTRS |
17 | The XLA_EVENT_CLASSES_ATTR table stores generic or specific attributes related to event classes. |
XLA_EVENT_CLASS_GRPS_B |
9 | The table XLA_EVENT_CLASS_GRPS_B record groups of event classes for processing purpose. |
XLA_EVENT_CLASS_GRPS_TL |
12 | The table XLA_EVENT_CLASS_GRPS_TL record translated information about event class groups. |
XLA_EVENT_CLASS_PREDECS |
10 | This table stores the predecessors of the event classes. |
XLA_EVENT_MAPPINGS_B |
12 | The XLA_EVENT_MAPPINGS_B table stores information to build reports based on information available on the base document.It contains a row for |
XLA_EVENT_MAPPINGS_TL |
10 | The XLA_EVENT_MAPPINGS_TL table record translated information related to event mappings. |
XLA_EVENT_SOURCES |
14 | The XLA_EVENT_SOURCES table stores all sources assigned to an event class or an event entity. |
XLA_EVENT_TYPES_B |
13 | The XLA_EVENT_TYPES_B table stores all event types that belong to an event class. |
XLA_EVENT_TYPES_TL |
14 | The XLA_EVENT_TYPES_TL table stores translated information about event types. |
XLA_EVT_CLASS_ACCT_ATTRS |
14 | The XLA_EVT_CLASS_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the event class level. |
XLA_EVT_CLASS_ORDERS_GT |
2 | |
XLA_EVT_CLASS_SOURCES_GT |
14 | |
XLA_EXTRACT_OBJECTS |
12 | It stores the extract object name and type used by the Accounting Program to derive sources for an event class. |
XLA_GL_LEDGERS |
9 | This table contains ledger information used by subledger accounting. |
XLA_GL_TRANSFER_BATCHES_ALL |
26 | Transferred Batches History Table. Maintains the log of the transfers submitted. |
XLA_GL_TRANSFER_PROGRAMS |
8 | GL Transfer program definition. Stores runtime parameters for a transfer program. |
XLA_GL_TRANSFER_PROGRAM_LINES |
10 | GL Transfer program definition details. |
XLA_HISTORIC_CONTROL |
39 | |
XLA_HISTORIC_MAPPING_GT |
2 | |
XLA_JE_CATEGORIES |
11 | This table stores Journal Categories for a combination of an event class and an application. |
XLA_JE_LINE_TYPES |
8 | This table holds information for journal entry line types. |
XLA_JLT_ACCT_ATTRS |
16 | The XLA_JLT_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the Journal Line Type level. |
XLA_LAUNCH_OPTIONS |
18 | The XLA_LAUNCH_OPTIONS table stores the defaults for accounting program launch options for an application and a ledger. For applications tha |
XLA_LEDGER_OPTIONS |
14 | This table stores the ledger level default setup information for an application. |
XLA_LINE_ASSGNS_T |
20 | Interface table to load the assignments between ADR rules and journal line types. |
XLA_LINE_DEFINITIONS_B |
18 | This table stores the journal lines definitions for an application. |
XLA_LINE_DEFINITIONS_TL |
17 | This table stores translated information about journal lines definitions. |
XLA_LINE_DEFN_AC_ASSGNS |
17 | This table stores the analytical criteria assigned to the journal lines definitions. |
XLA_LINE_DEFN_ADR_ASSGNS |
22 | This table stores the account derivation rules assigned to the journal lines definitions. |
XLA_LINE_DEFN_JLT_ASSGNS |
24 | This table stores the journal line types assigned to the journal lines definitions. |
XLA_MAPPING_SETS_B |
18 | The XLA_MAPPING_SETS_B table stores Mapping Sets created by End Users. These mapping sets are then used in the definition of account derivat |
XLA_MAPPING_SETS_TL |
12 | The XLA_MAPPING_SETS_TL table stores all translated information about mapping sets. |
XLA_MAPPING_SET_VALUES |
16 | The XA_MAPPING_SET_VALUES table store the mapping of account or segment values to a source value for a mapping set. |
XLA_MERGE_SEG_MAPS |
16 | This table stores the segment mapping for third party merge |
XLA_MPA_HEADER_AC_ASSGNS |
17 | This table stores the analytical criteria assigned to a multiperiod header. |
XLA_MPA_JLT_AC_ASSGNS |
20 | This table stores the analytical criteria for a multiperiod journal line type. |
XLA_MPA_JLT_ADR_ASSGNS |
22 | This table stores the account derivation rules for a multiperiod journal line type. |
XLA_MPA_JLT_ASSGNS |
20 | This table stores the multiperiod journal line type assignments. |
XLA_PARTIAL_MERGE_TXNS |
22 | This table stores the transactions to be processed for a partial third party merge |
XLA_POST_ACCT_PROGS_B |
9 | This table stores the Post-Accounting Programs. |
XLA_POST_ACCT_PROGS_TL |
12 | This table stores the translated columns for the Post-Accounting Programs. |
XLA_PRODUCT_RULES_B |
23 | The XLA_PRODUCT_RULES_B table stores the accounting rules for an application. Standard product accounting rules are independent of a chart |
XLA_PRODUCT_RULES_TL |
14 | The XLA_PRODUCT_RULES_TL table stores translated information about Application Accounting Definitions. |
XLA_PROD_ACCT_HEADERS |
18 | The XLA_PROD_ACCT_HEADERS table optionally stores the accounting headers types for a Application Accounting Definition and event class or ty |
XLA_PROD_ACCT_LINES |
17 | The XLA_PROD_ACCT_LINES table stores all accounting line types for Application Accounting Definition and event type or class combinations. |
XLA_PROD_SEG_RULES |
17 | The XLA_PROD_SEG_RULES table stores all account derivation rules attached to an accounting line type and a product rule. |
XLA_RC_UPGRADE_RATES |
14 | This table holds the conversion rates used during Secondary or ALC ledger upgrade |
XLA_REFERENCE_OBJECTS |
16 | This table sotores reference objects. |
XLA_REVERSE_EVENTS_INTERFACE |
10 | The XLA_REVERSE_EVENTS_INTERFACE table stores records for accounting events that are to be reversed in bulk. The Bulk Reversal Event API re |
XLA_RULES_T |
12 | Interface table to load ADR rules into SLA. |
XLA_RULE_DETAILS_T |
22 | Interface table to load ADR rule details into SLA. |
XLA_SEG_RULES_B |
18 | The XLA_SEG_RULES_B table stores all account derivation. These account derivation rules are then attached to an accounting line type |
XLA_SEG_RULES_TL |
14 | The XLA_SEG_RULES_TL table stores translated information about segment rules. |
XLA_SEG_RULE_DETAILS |
27 | The XLA_SEG_RULE_DETAILS table store details for an account derivation rule. It defines the priority in which the rule should be applied if |
XLA_SOURCES_B |
24 | The XLA_SOURCES_B table stores all sub-ledgers sources and sources customized by user. These sources are used to create accounting rules and |
XLA_SOURCES_TL |
13 | The XLA_SOURCES_TL table stores translated information about sources. |
XLA_SOURCE_PARAMS |
16 | The XLA_SOURCE_PARAMS table stores all parameters used in the plsql function for a user-defined source. |
XLA_STAGE_ACCTG_METHODS |
19 | The XLA_STAGE_ACCTG_METHODS table stores the subledger accounting methods imported from the data file to the staging area of an AMB context. |
XLA_STAGING_COMPONENTS_H |
21 | The XLA_STAGING_COMPONENTS_H table stores the history of the application accounting definitions and the non-application specific journal ent |
XLA_SUBLEDGERS |
17 | The XLA_SUBLEDGERS stores information that depend on the application. It includes a row for each application, standard or not, supported by |
XLA_TAB_ACCT_DEFS_B |
18 | The XLA_TAB_ACCT_DEFS_B table stores all Transaction Account Definitions. |
XLA_TAB_ACCT_DEFS_TL |
13 | The XLA_TAB_ACCT_DEFS_TL table stores translated name and description for Transaction Account Definitions. |
XLA_TAB_ACCT_DEF_DETAILS |
13 | The XLA_TAB_ACCT_DEF_DETAILS table stores the intersection of Transaction Account Definitions, Transaction Account Types and Account Derivat |
XLA_TAB_ACCT_TYPES_B |
12 | The XLA_TAB_ACCT_TYPES_B table stores all Transaction Account Types. |
XLA_TAB_ACCT_TYPES_TL |
12 | The XLA_TAB_ACCT_TYPES_TL table stores translated name and description for Transaction Account Types. |
XLA_TAB_ACCT_TYPE_SRCS |
11 | The XLA_TAB_ACCT_TYPE_SRCS table stores all Transaction Account Type Sources. |
XLA_TB_BALANCES_GT |
7 | Global temporary table to store the trial balance upgraded balance information. |
XLA_TB_DEFINITIONS_B |
17 | This table stores Open Account Balances Listing definitions. |
XLA_TB_DEFINITIONS_TL |
10 | This table stores translated information of the Open Account Balances Listing report definitions. |
XLA_TB_DEFN_DETAILS |
15 | This table stores the Open Account Balances Listing report definition details |
XLA_TB_DEFN_JE_SOURCES |
9 | This table stores journal sources associated with the Open Account Balances Listing report definitions. |
XLA_TB_DEF_SEG_RANGES |
64 | This tables stores segment ranges generated based on Open Account Balances Listing report definition details. |
XLA_TB_LOGS |
8 | This table tracks concurrent requests of the Open Account Balances Listing Data Manager. |
XLA_TB_USER_TRANS_VIEWS |
16 | This table stores user transaction view information. |
XLA_TB_WORK_UNITS |
9 | This table serves as a work unit table to process open account balances data in parallel. Accounting entries are split into multiple units |
XLA_TPM_WORKING_HDRS_T |
4 | The journal header identifiers to be processed by third party merge event. |
XLA_TRANSACTION_ACCTS_GT |
11 | |
XLA_TRANSACTION_ENTITIES |
30 | The table XLA_ENTITIES contains information about sub-ledger document or transactions. |
XLA_TRANSFER_LEDGERS |
12 | The XLA_TRANSFER_LEDGERS table stores secondary ledgers processed by the transfer to GL batch. |
XLA_TRANSFER_LOGS |
15 | The XLA_TRANSFER_LOGS table stores the transfer to GL log information. This information is used to recover the failed transfer to GL reques |
XLA_TRIAL_BALANCES |
40 | |
XLA_TRIAL_BALANCES_GT |
58 | |
XLA_UPGRADE_DATES |
3 | For SLA upgrade: contains start and enddate for a ledger. |
XLA_UPGRADE_REQUESTS |
23 | For SLA upgrade: stores the parameters for each post upgrade request. |
XLA_UPG_BATCHES |
16 | Upgrade batch information |
XLA_UPG_ERRORS |
20 | Errors related to upgraded entries |
XLA_VALIDATION_LINES_GT |
72 |