Results for “xla_ap_pay_ael_gl_v”

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

Overview

The view XLA_AP_PAY_AEL_GL_V is a Subledger Accounting (XLA) reporting object exposed by Oracle E-Business Suite. It presents accounting event line (AEL) information for Payables payment transactions, joined to the corresponding General Ledger journal header and line attributes, in a flattened structure suitable for inquiry, reconciliation, and extract reporting. The naming convention identifies the source application (AP), the transaction family (PAY, i.e., payments), the underlying event entities (AEH/AEL), and the GL linkage. The view is one of the family of XLA_%_AEL_GL_V views that expose subledger accounting distributions alongside their GL journal relationships.

The object is relevant to the search term payment_cleared_date. Payment clearing information is sourced from the Payables payment tables; the XLA accounting views expose the accounting distribution and GL journal linkage for those payments, allowing reporting that correlates clearing activity with its accounting impact. Note that the ETRM metadata records this view as "Not implemented in this database" for the documented environment, indicating its availability depends on patch level and configuration.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for this view, and the extracted view text is a composite SELECT that joins multiple XLA and GL tables. Based on the column set (AEH_ID, AEL_ID, AE_LINE_REFERENCE, SOURCE_TABLE, SOURCE_ID, TRX_HDR_ID, TRX_HDR_TABLE), the view is defined over the XLA accounting event header and line tables, principally XLA_AE_HEADERS and XLA_AE_LINES, joined to XLA_EVENTS and to the GL interface/entry objects GL_JE_HEADERS and GL_JE_LINES through the JE_HEADER_ID and JE_LINE_NUM columns. Several columns are explicitly projected as constants or NULLs (for example, TRANSFER_SYSTEM_NAME, ACCOUNTING_COMPLETE, TAXABLE_ENTERED_DR, TRX_NUMBER_C), which indicates the view is a compatibility variant within the XLA accounting views family, normalizing the column list to a shared signature.

Key Columns

• JE_HEADER_ID, JE_LINE_NUM — link to the General Ledger journal header and line (GL_JE_HEADERS/JE_LINES).
• AEH_ID, AEL_ID — the XLA accounting event header and accounting event line identifiers.
• ACCOUNTED_DR, ACCOUNTED_CR, ENTERED_DR, ENTERED_CR — accounted and entered debit/credit amounts for the distribution.
• ACCOUNTING_DATE, TRX_DATE, CURRENCY_CONVERSION_DATE — accounting, transaction, and conversion dates.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE — currency and conversion attributes.
• CODE_COMBINATION_ID — the accounting flexfield combination for the distribution.
• GL_TRANSFER_STATUS, GL_TRANSFER_STATUS_NAME, TRANSFER_STATUS_DETAIL_NAME — the transfer status of the subledger journal to GL.
• THIRD_PARTY_ID/NAME/NUMBER, THIRD_PARTY_TYPE — supplier/party attributes carried from Payables.
• TRX_HDR_ID, TRX_HDR_TABLE, SOURCE_ID, SOURCE_TABLE — pointers to the source transaction (e.g., the AP payment) for drill-down.
• SET_OF_BOOKS_ID, ORG_ID, APPLICATION_ID — ledger, operating unit, and application context.

Common Use Cases and Queries

Typical uses include reconciling payment accounting distributions to GL, auditing transfer status, and extracting payment accounting detail that also carries cleared-date context from the underlying payment source. A representative query filtering on a ledger and accounting period:

• Reconcile subledger to GL by summing ACCOUNTED_DR/ACCOUNTED_CR by CODE_COMBINATION_ID and comparing to GL balances.
• Identify payments whose accounting has not transferred (GL_TRANSFER_STATUS not equal to the processed value).
• Report payment distributions by supplier (THIRD_PARTY_NAME) and accounting date.

Sample SQL:

SELECT v.JE_HEADER_ID,
       v.JE_LINE_NUM,
       v.TRX_DATE,
       v.THIRD_PARTY_NAME,
       v.CURRENCY_CODE,
       v.ACCOUNTED_DR,
       v.ACCOUNTED_CR,
       v.GL_TRANSFER_STATUS_NAME
FROM   XLA_AP_PAY_AEL_GL_V v
WHERE  v.SET_OF_BOOKS_ID = :ledger_id
AND    v.ACCOUNTING_DATE BETWEEN :start_date AND :end_date
ORDER  BY v.TRX_DATE, v.JE_HEADER_ID, v.JE_LINE_NUM;

Because the view is documented as not implemented in some environments, verify its existence in ALL_VIEWS before relying on it, and confirm the target release (12.1.1 versus 12.2.2) since the XLA accounting views family varies by patch level.