Results for “okl_xla_acc_data_gt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_XLA_ACC_DATA_GT is a global temporary staging table owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL (Leasing and Finance Management) product family. Its name indicates its purpose: it holds accounting data collected from Oracle Leasing transactions before that data is transferred to Subledger Accounting (XLA) and, ultimately, to the General Ledger. The table functions as an intermediate collection point where leasing contract events are assembled, validated, and enriched with accounting attributes prior to the creation of subledger journal entries.

Within the ETRM 12.2.2 documented schema, the table exposes 33 columns. The metadata classifies it as standalone under the heuristic Data Vault model, meaning no formally enforced hub, link, or satellite relationship is asserted. Practically, the table behaves like a staging or temporary collection structure rather than a durable transaction store. Because it is a global temporary table,rows are typically scoped to a specific session or transaction during the accounting extraction and transfer process. Its content is transient by design and is normally populated and consumed within a single subledger accounting run.

Key Information Stored

The table stores the accounting detail required to generate subledger journal entries for leasing activity. The most significant columns include:

• TCN_ID — Identifier of the upgrade transaction contract; serves as a foreign key to OKL_UPG_TRX_CONTRACTS_T.
• TRX_NUMBER — The business transaction number associated with the leasing event.
• LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES, identifying the legal entity that owns the transaction.
• ORG_ID — Operating unit identifier for multi-organization reporting.
• SET_OF_BOOKS_ID — The ledger set of books against which entries are generated.
• TAD_ID — Foreign key to OKL_XLA_EVE_TAD_MAP_T, linking to the transaction accounting definition.
• AE_HEADER_ID — Identifier of the accounting event header produced by Subledger Accounting.
• CODE_COMBINATION_ID — The accounting flexfield combination used for the journal line.
• LINE_NUM — Line sequence within the accounting event.
• ACCOUNTING_EVENT_CLASS_CODE / EVENT_TYPE_CODE / TYPE_OF_EVENT — Classify the nature of the accounting event.
• ENTERED_DR / ENTERED_CR and ACCOUNTED_DR / ACCOUNTED_CR — Entered and accounted debit and credit amounts.
• CURRENCY_CODE / CURRENCY_CONVERSION_RATE / CURRENCY_CONVERSION_TYPE / CURRENCY_CONVERSION_DATE — Currency and conversion attributes for foreign-currency transactions.
• PERIOD_NAME / EVENT_DATE / DATE_TRANSACTION_OCCURRED — Accounting period and relevant dates.
• GL_TRANSFER_FLAG / GL_SL_LINK_ID — Indicators for transfer to the General Ledger and the resulting linkage identifier.

No surrogate primary key or unique business-key index is documented for this table, consistent with its role as a transient staging structure.

Common Use Cases and Queries

Typical use cases center on diagnosing accounting generation and transfer issues for leasing contracts. Common queries include:

• Listing all accounting lines staged for a specific contract: SELECT * FROM okl_xla_acc_data_gt WHERE tcn_id = :tcn_id;
• Auditing amounts staged for a period: SELECT period_name, SUM(accounted_dr), SUM(accounted_cr) FROM okl_xla_acc_data_gt GROUP BY period_name;
• Identifying entries not yet transferred to GL: SELECT * FROM okl_xla_acc_data_gt WHERE gl_transfer_flag = 'N';
• Reviewing currency conversion attributes for a transaction.

Because it is a global temporary table, any diagnostic queries must be executed within the same session or process that populated the data; otherwise, no rows will be visible.

Related Objects

• OKL_UPG_TRX_CONTRACTS_T — joined on TCN_ID to retrieve the source leasing contract.
• FV_LEGAL_ENTITIES — joined on LEGAL_ENTITY_ID for legal entity information.
• OKL_XLA_EVE_TAD_MAP_T — joined on TAD_ID for transaction accounting definitions.
• XLA_AE_HEADERS / XLA_AE_LINES — downstream accounting event headers and lines keyed by AE_HEADER_ID.
• GL_JE_HEADERS / GL_JE_LINES — General Ledger journal entries created after transfer.
• GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID.
• GL_LEDGERS / FND_SET_OF_BOOKS — joined on SET_OF_BOOKS_ID.
• OKL_XLA_ACC_DATA_PKG / Subledger Accounting programs — populate and consume this staging table.