Results for “gl_transfer_error_code”

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

Overview

OKL_AE_HEADERS_ALL is the accounting entry header table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the header-level records that group the journal-style accounting entries generated by the lease accounting engine. Each row represents a single accounting entry event for a contract or transaction, serving as the parent record for the individual debit and credit lines held in OKL_AE_LINES_ALL. The table therefore sits at the centre of the OKL subledger accounting flow, capturing the event, the ledger, the accounting period, and the transfer status to General Ledger.

From a Data Vault modelling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table is anchored to OKL_ACC_EVENTS_ALL through ACCOUNTING_EVENT_ID, indicating a dependent, descriptive role relative to the accounting event rather than an independent hub. Modelers should treat it as a descriptive satellite of the accounting event, with the AE_HEADER_ID acting as its local surrogate key.

Key Information Stored

Of the 27 documented columns, the following are the most significant:

• AE_HEADER_ID — the surrogate primary key (OKL_AE_HEADERS_ALL_PK) and the sole documented business-key candidate via unique index OKL_AE_HEADERS_ALL_U1. It is referenced by OKL_AE_LINES_ALL.AE_HEADER_ID.
• ACCOUNTING_EVENT_ID — foreign key to OKL_ACC_EVENTS_ALL; identifies the originating accounting event.
• AE_CATEGORY — classifies the type of accounting entry header.
• SET_OF_BOOKS_ID — the ledger to which the entry belongs.
• PERIOD_NAME and ACCOUNTING_DATE — the accounting period and effective date of the entry.
• POST_TO_GL_FLAG and GL_TRANSFER_FLAG — control whether and how the entry is transferred to General Ledger.
• GL_TRANSFER_RUN_ID and GL_TRANSFER_ERROR_CODE — identify the GL transfer run and any transfer failure.
• ACCOUNTING_ERROR_CODE — captures accounting generation errors.
• GL_REVERSAL_FLAG — indicates reversal entries.
• CROSS_CURRENCY_FLAG — flags cross-currency accounting.
• SEQUENCE_ID and SEQUENCE_VALUE — ordering attributes for entry generation.
• ORG_ID — the operating unit, supporting multi-org security.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF framework.
• PROGRAM_ID, REQUEST_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit and concurrent request columns.

Common Use Cases and Queries

Typical reporting scenarios include reconciling OKL accounting entries to GL, investigating transfer failures, and auditing period activity. A common join links headers to their lines and events:

• Reconciliation by period: select headers where PERIOD_NAME equals the target period and POST_TO_GL_FLAG is set, joining to OKL_AE_LINES_ALL on AE_HEADER_ID to sum debits and credits.
• Error investigation: query rows where ACCOUNTING_ERROR_CODE or GL_TRANSFER_ERROR_CODE is not null, joined to OKL_ACC_EVENTS_ALL via ACCOUNTING_EVENT_ID to trace the source event.
• GL transfer tracking: filter by GL_TRANSFER_RUN_ID to review all entries produced by a specific transfer run.
• Multi-org compliance: restrict by ORG_ID to satisfy operating unit data security.

Because the header-to-line relationship is one-to-many, aggregate queries should group by AE_HEADER_ID or SET_OF_BOOKS_ID and PERIOD_NAME to avoid line-level duplication.

Related Objects

• OKL_ACC_EVENTS_ALL — parent object referenced via ACCOUNTING_EVENT_ID.
• OKL_AE_LINES_ALL — child table holding entry lines, referenced through AE_HEADER_ID.
• OKL_AE_HEADERS_ALL_PK and OKL_AE_HEADERS_ALL_U1 — primary key and unique index enforcing AE_HEADER_ID integrity.
• GL_JE_HEADERS / GL_JE_LINES — General Ledger targets receiving transferred entries.
• GL_SETS_OF_BOOKS — ledger definition referenced through SET_OF_BOOKS_ID.
• FND_CONCURRENT_REQUESTS — concurrent program context referenced through REQUEST_ID.