Results for “type_of_event”

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

Overview

OKL_XLA_EVE_HDR_TRX_MAP_GT is an APPS-owned table within the Oracle Lease and Finance Management (OKL) product family. Its name follows the Subledger Accounting (XLA) naming convention, indicating that it participates in the mapping of lease-related events to accounting event headers and transaction records processed by the E-Business Tax and Subledger Accounting engines. The "_GT" suffix indicates a global temporary table, meaning rows are session-scoped and the table is typically used as an interim staging structure during accounting event generation before data is written to permanent XLA tables.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is modeled as a standalone entity. From a dimensional or Data Vault modeling perspective, this suggests it does not function as a classic hub or link but rather as a transient, operational staging table whose lifecycle is bounded by the accounting event creation process. Analysts should therefore treat it as an implementation artifact rather than a durable analytical source.

Key Information Stored

The documented 12.2.2 physical schema contains five columns, each serving a specific role in the event-to-transaction mapping:

• TCN_ID — The transaction contract identifier. This is the only documented foreign key, referencing OKL_UPG_TRX_CONTRACTS_T, linking each staged row back to its originating contract transaction.
• TYPE_OF_EVENT — Classifies the accounting event type being mapped, enabling downstream XLA processing to select the correct accounting rules.
• ENTITY_ID — Identifies the source entity (for example, the lease or contract) associated with the event header.
• EVENT_ID — The lease-side event identifier; together with ENTITY_ID and TYPE_OF_EVENT this forms the natural business key of the staged event.
• AE_HDR_ID — The Subledger Accounting event header identifier, the surrogate pointer into the permanent XLA_EVENTS / accounting header structures.

No separate surrogate primary key is documented, and no unique index is confirmed in the ETRM metadata. In practice the combination of ENTITY_ID, EVENT_ID, and TYPE_OF_EVENT serves as the business-key candidate, while AE_HDR_ID provides the linkage to the downstream accounting event header.

Common Use Cases and Queries

Because OKL_XLA_EVE_HDR_TRX_MAP_GT is a global temporary table, it is populated during Create Accounting or accounting event generation runs and consumed within the same session. Typical uses include:

• Diagnosing why a lease contract transaction failed to create an accounting event, by inspecting staged rows that never received an AE_HDR_ID.
• Reconciling lease transactions to their generated Subledger Accounting event headers for audit or period-close purposes.
• Extracting the mapping during custom accounting integrations or conversions.

A representative diagnostic query pattern:

• SELECT m.tcn_id, m.type_of_event, m.entity_id, m.event_id, m.ae_hdr_id FROM okl_xla_eve_hdr_trx_map_gt m WHERE m.ae_hdr_id IS NULL;
• SELECT c.*, m.type_of_event, m.ae_hdr_id FROM okl_upg_trx_contracts_t c JOIN okl_xla_eve_hdr_trx_map_gt m ON c.tcn_id = m.tcn_id;

Note that rows are visible only within the inserting session, so queries must be executed from the same concurrent process context.

Related Objects

The following objects are most significant in relation to this table:

• OKL_UPG_TRX_CONTRACTS_T — The only documented foreign key target, joined on TCN_ID; it holds the lease upgrade/transaction contract detail behind each mapped row.
• XLA_EVENTS — The permanent Subledger Accounting event header, referenced indirectly through AE_HDR_ID.
• XLA_TRANSACTION_ENTITIES — Holds the entity (ENTITY_ID) against which accounting events are created.
• OKL_TRX_CONTRACTS and related OKL contract transaction tables — source data for the TCN_ID and event identifiers.
• XLA_ACCOUNTING_EVENTS / XLA_AE_HEADERS — Downstream targets of the accounting event creation process that consumes this staging table.
• Subledger Accounting program (XLAACCPR / Create Accounting) — The concurrent process that populates and consumes OKL_XLA_EVE_HDR_TRX_MAP_GT.