Results for “xla_inv_ael_sl_pac_v”

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

Overview

XLA_INV_AEL_SL_PAC_V is an APPS-owned view within the Oracle E-Business Suite Subledger Accounting (XLA) module. It exposes accounting event lines for inventory-related transactions in a format aligned with the Accounted Event Lines (AEL) structure used by XLA reporting and integration layers. In EBS 12.1.1 and 12.2.2, this view functions as a presentation and compatibility layer: it presents journal-line-level accounting data (debit/credit balances, currency conversion attributes, account code combinations, and transaction identifiers) drawn from the underlying inventory accounting view. Because it contains the suffix "PAC" (Period Average Cost) and "SL" (Subledger), it is oriented toward cost-accounting and period-average-cost processing associated with the Inventory subledger, and it can be joined or queried alongside other AEL views for reconciliation, audit, and GL transfer reporting. The view returns no ORG_ID or AEH_ID/AEL_ID values directly (they are defined as NULL or TO_NUMBER(NULL)), indicating it is an abstracted layer rather than a full event-header source.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is defined over the following base objects:

• CST_PAC_AEL_SL_INV_V (VIEW) — the primary source, providing the accounted event line data for period-average-cost inventory transactions.
• HR_GENERAL (PACKAGE) — the HR security/utilities package, referenced in the view definition (typically for organizational or responsibility-based security filtering).
• HR_SECURITY (PACKAGE) — used together with HR_GENERAL to enforce data access restrictions, ensuring that only authorized organizations and transaction data are visible to the querying responsibility.

The presence of the HR security packages confirms that the view applies row-level security, which is consistent with the way XLA exposes subledger accounting data to different operating units and responsibilities in a multi-org environment.

Key Columns

The view projects a standard set of accounting and transaction columns. Important ones include:

• ACCOUNTED_DR / ACCOUNTED_CR — accounted debit and credit amounts in the ledger currency.
• ENTERED_DR / ENTERED_CR — entered debit and credit amounts in the transaction currency.
• ACCOUNTING_DATE, TRX_DATE — the GL accounting date and the originating transaction date.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — currency and conversion attributes used to derive accounted amounts.
• CODE_COMBINATION_ID — the accounting flexfield combination applied to the line.
• TRX_CLASS / TRX_CLASS_NAME, TRX_TYPE_N / TRX_TYPE_NAME — transaction classification and type identifiers and their descriptive names.
• TRX_HDR_ID, TRX_HDR_TABLE, SOURCE_ID, SOURCE_TABLE, AE_LINE_REFERENCE — keys linking the accounting line back to its source transaction and event.
• GL_TRANSFER_STATUS / GL_TRANSFER_STATUS_NAME — the status of transfer to the General Ledger.
• SET_OF_BOOKS_ID, APPLICATION_ID, ACCT_LINE_TYPE — ledger, application, and accounting line type context.

Notably, columns such as ORG_ID, AEH_ID, AEL_ID, THIRD_PARTY_* and TAX_* are defined as NULL or TO_NUMBER(NULL) in this view, so they return no values and should not be relied upon here.

Common Use Cases and Queries

The view is typically used for reconciliation and audit reporting of inventory cost accounting entries. A representative query retrieves accounted balances per transaction:

• Reconciling inventory subledger journal lines to the General Ledger by transaction class and type.
• Auditing currency conversion details on period-average-cost inventory transactions.
• Extracting GL transfer status for lines pending posting.

Sample SQL:

SELECT trx_class_name, trx_type_name, trx_number_displayed,
accounting_date, accounted_dr, accounted_cred, currency_code,
gl_transfer_status_name
FROM apps.xla_inv_ael_sl_pac_v
WHERE set_of_books_id = :ledger_id
AND accounting_date BETWEEN :from_date AND :to_date;

Note: the searched term "trx_reason_name" is not exposed by this view's documented column list; transaction reason information would need to be obtained from the source transaction tables or related views.