Results for “xla_inv_ael_gl_pac_v”

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

Overview

XLA_INV_AEL_GL_PAC_V is an APPS-owned database view within the Subledger Accounting (XLA) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes accounting entry lines originating from Oracle Inventory (INV) that have been generated by Subledger Accounting and are destined for transfer to the General Ledger. The view presents a flattened, GL-ready projection of subledger accounting lines, combining journal header and line attributes with source transaction references and currency conversion details. Its underlying naming — "PAC" (Period Accounting Close / transfer-oriented) and "AEL" (Accounting Entry Lines) — signals that it serves as an interface layer for reconciliation, reporting, and transfer monitoring rather than as an editable operational entity.

Unlike the live XLA_AE_HEADERS and XLA_AE_LINES tables, this view is a read-only construct intended for query and reporting purposes. It surfaces data in a structure compatible with GL transfer programs and standard reconciliation reports, and it is frequently used by developers and DBAs who need to inspect how inventory accounting entries will appear once posted to GL. Notably, the view does not expose a column named TRX_REASON_NAME; users searching for that attribute will not find it here, as it is not part of this view's projection.

Underlying Base Objects

According to the documented metadata for 12.2.2, XLA_INV_AEL_GL_PAC_V is defined over a single referenced base object: the view CST_PAC_AEL_GL_INV_V (VIEW), owned by APPS. This layered design reflects Oracle's practice of chaining views to progressively add product-specific logic. The "CST_PAC_" prefix indicates a Cost Management (CST) origin, and the "_INV_GL_" segment confirms the Inventory-to-General-Ledger flow. XLA_INV_AEL_GL_PAC_V therefore acts as the XLA-side presentation of subledger accounting lines that pass through the Cost Management costing pipeline. Because the view's definition depends on CST_PAC_AEL_GL_INV_V, any structural changes in the underlying costing views propagate upward; the view is reported as VALID, indicating successful compilation against its dependency chain.

Key Columns

The view exposes a broad set of columns organized into logical groups. Journal identification and amounts are represented by JE_HEADER_ID, JE_LINE_NUM, ACCOUNTED_DR, ACCOUNTED_CR, ENTERED_DR, ENTERED_CR, and ACCOUNTING_DATE. Accounting flexibility is provided through ACCT_LINE_TYPE, ACCT_LINE_TYPE_NAME, CODE_COMBINATION_ID, COMMENTS, and SET_OF_BOOKS_ID.

• Currency and conversion: CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, and CURRENCY_USER_CONVERSION_TYPE.
• Source linkage: SOURCE_ID, SOURCE_TABLE, TRX_HDR_ID, TRX_HDR_TABLE, TRX_CLASS, TRX_CLASS_NAME, and TRX_DATE.
• Transaction identity: TRX_NUMBER_DISPLAYED, TRX_NUMBER_N, TRX_TYPE_N, and TRX_TYPE_NAME.
• Transfer status: GL_TRANSFER_STATUS and GL_TRANSFER_STATUS_NAME.
• AEL internal references: AEL_TABLE, AE_LINE_REFERENCE, and AE_LINE_REFERENCE_INTERNAL.

Several positions — including AEH_ID, AEL_ID, ORG_ID, THIRD_PARTY_NAME, TAX_CODE, and DOC_SEQUENCE_NAME — are populated with TO_NUMBER(NULL) or NULL, indicating that those attributes are intentionally suppressed or sourced elsewhere in the XLA layered model.

Common Use Cases and Queries

Typical usage centers on inventory accounting reconciliation and GL transfer analysis.

• Listing untransferred inventory entries: filter on GL_TRANSFER_STATUS.
• Reconciling source transactions to accounting lines via SOURCE_ID and TRX_NUMBER_DISPLAYED.
• Checking currency conversion behavior for a given period using ACCOUNTING_DATE and CURRENCY_CONVERSION_TYPE.

A representative query:

SELECT JE_HEADER_ID, JE_LINE_NUM, TRX_NUMBER_DISPLAYED, ACCOUNTED_DR, ACCOUNTED_CR, CURRENCY_CODE, GL_TRANSFER_STATUS FROM APPS.XLA_INV_AEL_GL_PAC_V WHERE SET_OF_BOOKS_ID = :ledger_id AND ACCOUNTING_DATE BETWEEN :start_date AND :end_date ORDER BY JE_HEADER_ID, JE_LINE_NUM;