Results for “gl_transfer_error_code”

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

Overview

AP_AE_HEADERS_ALL is the accounting entry header table within the Oracle Payables (AP) module. It resides in the AP schema and serves as the parent header record for subledger accounting entries generated by Payables. Each row represents a single accounting event header that groups one or more accounting entry lines, forming the bridge between an accounted business transaction and the corresponding general ledger journal entries. The table is central to the Create Accounting process and the final transfer of Payables accounting to Oracle General Ledger.

From a data modeling perspective, the ETRM heuristic classifies AP_AE_HEADERS_ALL as satellite-leaning. This reflects its role: it holds descriptive and status attributes tied to a primary business entity (the accounting event), rather than acting as a pure hub or link. It is best understood as an attribute-bearing companion to AP_ACCOUNTING_EVENTS_ALL, capturing the accounting-specific state, categorization, and transfer details for each event.

Key Information Stored

The table contains 24 documented columns. The surrogate primary key is AE_HEADER_ID, enforced through the AP_AE_HEADERS_PK constraint. Two unique indexes define business-key candidates: AP_AE_HEADERS_U1 on AE_HEADER_ID and AP_AE_HEADERS_U2 on the combination of ACCOUNTING_EVENT_ID and SET_OF_BOOKS_ID, which guarantees one accounting header per accounting event per ledger.

• AE_HEADER_ID — Surrogate primary key uniquely identifying each accounting entry header.
• ACCOUNTING_EVENT_ID — Foreign key to AP_ACCOUNTING_EVENTS_ALL, linking the header to its originating accounting event.
• SET_OF_BOOKS_ID — Identifies the ledger (set of books) to which the accounting entry belongs.
• AE_CATEGORY — Accounting entry category that classifies the nature of the entry.
• PERIOD_NAME — The accounting period for the entry.
• ACCOUNTING_DATE — The date on which the entry is recognized for accounting.
• GL_TRANSFER_FLAG — Indicates whether the header has been transferred to General Ledger.
• GL_TRANSFER_RUN_ID — Identifies the transfer run that moved the entry to GL.
• GL_TRANSFER_ERROR_CODE — Captures any error encountered during GL transfer.
• ACCOUNTING_ERROR_CODE — Records errors occurring during the accounting creation process.
• CROSS_CURRENCY_FLAG — Flags entries involving cross-currency accounting.
• GL_REVERSAL_FLAG — Indicates whether the entry is a GL reversal.
• TRIAL_BALANCE_FLAG — Marks trial balance entries.
• ORG_ID — Operating unit identifier, supporting multi-org reporting.
• REQUEST_ID / PROGRAM_ID — Identify the concurrent request and program that created the row, supporting audit and traceability.

Common Use Cases and Queries

AP_AE_HEADERS_ALL is frequently queried to audit the status of accounting creation and GL transfer, to reconcile Payables subledger entries against GL balances, and to diagnose accounting or transfer failures. A typical query retrieves untransferred headers and their error codes:

• Identifying entries that failed to transfer to GL using GL_TRANSFER_FLAG, GL_TRANSFER_ERROR_CODE, and REQUEST_ID.
• Reconciling accounting entries by SET_OF_BOOKS_ID and PERIOD_NAME for period-close reporting.
• Reporting accounting activity by AE_CATEGORY and ACCOUNTING_DATE for management analysis.
• Joining to AP_AE_LINES_ALL on AE_HEADER_ID to retrieve full debit and credit line detail for an entry.
• Joining to AP_ACCOUNTING_EVENTS_ALL on ACCOUNTING_EVENT_ID to trace an entry back to its source transaction.

Related Objects

The table participates in a well-defined set of relationships documented in the ETRM metadata:

• AP_ACCOUNTING_EVENTS_ALL — Referenced via ACCOUNTING_EVENT_ID; the parent source event for each header.
• AP_AE_LINES_ALL — References this table via AE_HEADER_ID; holds the individual debit and credit lines belonging to the header.
• AP_ENCUMBRANCE_LINES_ALL — Also references this table via AE_HEADER_ID; stores associated encumbrance accounting lines.
• AP_AE_HEADERS_PK / AP_AE_HEADERS_U1 / AP_AE_HEADERS_U2 — The primary and unique index constraints that enforce identity and business-key uniqueness.
• SET_OF_BOOKS_ID — Associates each header with its ledger, supporting GL reconciliation joins.

Together these objects form the accounting entry structure that connects Payables transactions to their final general ledger representation, making AP_AE_HEADERS_ALL a critical reference point for both operational accounting and subledger reconciliation.