Results for “pn_ae_headers”

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

Overview

APPS.PN_AEL_PAY_GL_V is an Oracle E-Business Suite accounting view belonging to the Oracle Payables/Payments (PN) module, specifically oriented toward Payables payment accounting events. It exposes payment-related accounting lines joined to their corresponding General Ledger import references, providing a subledger-to-GL reconciliation and reporting surface for payment transactions. The view is part of the Applications Accounting Events (AEL/ae) family of reporting objects used by Oracle Subledger Accounting (SLA, formerly AX) to map subledger accounting lines to their resulting GL journal lines.

In Oracle EBS 12.1.1 and 12.2.2, this view is commonly queried in reconciliation reports, GL drill-down diagnostics, period close validation, and custom OAF-based or BI Publisher report development. Because it surfaces attributes such as JE_HEADER_ID, JE_LINE_NUM, and the AE_LINE_ID, it provides the linkage needed to trace an accounting entry from PN_AE_LINES all the way into GL_IMPORT_REFERENCES and the resulting GL balances.

Underlying Base Objects

The view is defined over a set of PN, PO, FND, and GL synonyms and views. Per the documented ETRM metadata for 12.2.2, the referenced base objects are:

• PN_AE_HEADERS and PN_AE_LINES — the primary accounting event header and line tables providing the core accounting data (AE_HEADER_ID, AE_LINE_ID, ACCOUNTED_DR/CR, ENTERED_DR/CR, code combination, currency attributes, and line type).
• PN_PAYMENT_ITEMS_ALL — supplies payment item attributes such as TRX_LINE_TYPE and THIRD_PARTY_ID via the VENDOR_ID.
• PN_PAYMENT_TERMS_ALL — provides start/end dates and payment_term_id (aliased as TRX_SOURCE_ID).
• PN_LEASES_ALL — supplies the transaction class name (TRX_CLASS_NAME).
• PO_VENDORS and PO_VENDOR_SITES_ALL — supply third-party (supplier) name and site information.
• GL_IMPORT_REFERENCES — links the accounting line to the resulting GL journal header and line (JE_HEADER_ID, JE_LINE_NUM).
• GL_JE_CATEGORIES, GL_DAILY_CONVERSION_TYPES, and FND_LOOKUPS — provide descriptive lookup/meaning values.
• FND_GLOBAL — the package referenced by the view (typically for ORG_ID or context derivation).

Key Columns

Key columns exposed by the view include:

• JE_HEADER_ID / JE_LINE_NUM — the GL journal header and line the accounting line posted into.
• AEH_ID / AEL_ID — the subledger accounting event header and line identifiers.
• APPLICATION_ID — hardcoded as 240, identifying Oracle Payables/Payments.
• SET_OF_BOOKS_ID, ORG_ID, PERIOD_NAME, ACCOUNTING_DATE — ledger and accounting period context.
• ACCOUNTED_DR / ACCOUNTED_CR and ENTERED_DR / ENTERED_CR — the accounted and entered debit/credit amounts.
• CODE_COMBINATION_ID — the accounting flexfield combination.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_USER_CONVERSION_TYPE — currency conversion attributes.
• ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME — the accounting line type code and its lookup meaning.
• TRX_LINE_TYPE / TRX_LINE_TYPE_NAME — payment item type code and lookup meaning.
• THIRD_PARTY_ID, THIRD_PARTY_NAME, THIRD_PARTY_SUB_NAME — supplier and site identifiers.
• JE_CATEGORY / USER_JE_CATEGORY_NAME — accounting category code and its user-facing name.
• SOURCE_ID, SOURCE_TABLE, REQUEST_ID, ACCOUNTING_LINE_NUMBER — audit and traceability attributes.

Common Use Cases and Queries

Typical uses include reconciliations of payment accounting lines against GL import references, drilling from a GL journal line back to the underlying payment accounting event, and validating period-close transfer completeness. The following sample query retrieves payment accounting lines for a given GL period:

• SELECT je_header_id, je_line_num, ae_line_number, accounted_dr, accounted_cr, third_party_name, trx_line_type_name
    FROM apps.pn_ael_pay_gl_v
    WHERE period_name = :p_period
    AND set_of_books_id = :p_sob;
• SELECT ael_id, je_header_id, je_line_num, currency_code, currency_conversion_rate
    FROM apps.pn_ael_pay_gl_v
    WHERE trx_line_type = 'PAYMENT';
• SELECT acct_line_type_name, SUM(accounted_dr - accounted_cr) net_amount
    FROM apps.pn_ael_pay_gl_v
    WHERE accounting_date BETWEEN :p_start AND :p_end
    GROUP BY acct_line_type_name;

Because the view joins several subledger and GL objects, queries should filter on period, ledger, or accounting line type for performance. The view is read-only and should not be used for DML; all updates to payment accounting data must be performed through the standard Payables and Subledger Accounting processes.