Results for “pn_ael_pay_gl_v”

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

Overview

PN_AEL_PAY_GL_V is a valid, APPS-owned database view within the Oracle E-Business Suite Property Manager (PN) product. Its name reflects its purpose: it is an Accounting Events Line (AEL) view that exposes payment-related accounting entries destined for the General Ledger. Within Oracle EBS 12.1.1 and 12.2.2, subledger accounting flows create accounting event headers and lines, and the Subledger Accounting program transfers those entries to GL via the GL_INTERFACE and GL_IMPORT_REFERENCES mechanism. This view consolidates the PN accounting event records with their GL import references, payment items, leases, vendors, and lookup descriptions into a single denormalized reporting structure.

The view is read-only and is consumed primarily by reporting tools, concurrent programs, and integration routines that require a flattened representation of Property Manager payment accounting lines. Because it joins the GL_IMPORT_REFERENCES table, it serves as a bridge between PN subledger accounting events and their transferred GL journal lines, making it useful for reconciliation and audit reporting.

Underlying Base Objects

The view is defined over a set of documented base objects spanning multiple modules. The core accounting data originates from PN_AE_HEADERS (accounting event headers) and PN_AE_LINES (accounting event lines). These are linked to GL_IMPORT_REFERENCES (R) and GL_JE_CATEGORIES (JC) to associate the accounting lines with their GL journal categories and import references. GL_DAILY_CONVERSION_TYPES provides currency conversion type descriptions.

Property Manager business context is supplied through PN_PAYMENT_ITEMS_ALL (payment items), PN_PAYMENT_TERMS_ALL (payment terms), and PN_LEASES_ALL (leases). Third-party (payee) information is drawn from PO_VENDORS and PO_VENDOR_SITES_ALL. Descriptive lookup values are obtained from FND_LOOKUPS for transaction type, payment item type, accounting line type, sales representative, and displayed transaction number. The FND_GLOBAL package is referenced for session context such as organization and user identifiers.

Key Columns

• JE_HEADER_ID / JE_LINE_NUM – Links the accounting line to its GL journal header and line.
• AEH_ID / AEL_ID – Identifiers for the PN accounting event header and line.
• SET_OF_BOOKS_ID / ORG_ID / ACCOUNTING_DATE / PERIOD_NAME – Ledger, operating unit, and accounting period context.
• ACCOUNTED_DR / ACCOUNTED_CR / ENTERED_DR / ENTERED_CR – Debit and credit amounts in ledger and entered currencies.
• CODE_COMBINATION_ID – The accounting flexfield combination for the line.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE – Currency and conversion details, with user conversion type names from GL_DAILY_CONVERSION_TYPES.
• ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME – Accounting line type code and its meaning.
• TRX_TYPE_NAME, TRX_LINE_TYPE_NAME, TRX_CLASS_NAME – Lookup-driven transaction classification descriptions.
• THIRD_PARTY_ID, THIRD_PARTY_NAME, THIRD_PARTY_SUB_NAME – Vendor identifier, vendor name, and vendor site.
• JE_CATEGORY / USER_JE_CATEGORY_NAME – Journal category code and its user-facing name.
• SOURCE_ID, SOURCE_TABLE – Origin of the accounting event.
• START_DATE, END_DATE, TRX_SOURCE_ID – Lease/payment term dates and payment term identifier.

Common Use Cases and Queries

Typical use cases include reconciling PN payment accounting lines against GL, verifying currency conversion, and reporting payee and lease context for accounted transactions.

• Reconcile PN accounting lines to GL import references for a given period.
• Report total accounted debits and credits per lease or vendor.
• Audit accounting line types and journal categories for posted entries.

SELECT je_header_id,
       je_line_num,
       accounting_date,
       trx_number_displayed,
       third_party_name,
       accounted_dr,
       accounted_cred,
       acct_line_type_name
FROM   apps.pn_ael_pay_gl_v
WHERE  set_of_books_id = :p_ledger
AND    accounting_date BETWEEN :p_start AND :p_end
ORDER  BY accounting_date, je_header_id, je_line_num;

Because the view performs numerous outer joins across lookups and vendors, queries should be filtered by ledger, period, or organization to maintain acceptable performance in either 12.1.1 or 12.2.2 environments.