Search Results ap_ael_sl_pay_v

Overview

AP_AEL_SL_PAY_V is a Payables subledger accounting view within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It exposes the accounting event lines generated by Subledger Accounting (SLA) for payment-related events, formatting them into a reporting-friendly structure. The view combines the accounting header and line details from the SLA tables with descriptive names sourced from the Accounting Event, Payment, and Statement Line entities, so downstream users can reconcile payment and clearing activity without joining the underlying transaction tables manually.

The view derives its transactional context from the SLA accounting headers and lines, and it distinguishes among several event types — including payment clearing and payment unclearing — by building a textual AE_LINE_REFERENCE string that concatenates the descriptive event labels with the corresponding event, line, statement, check, and invoice numbers. The view emits a constant APPLICATION_ID of 200, identifying it as an Oracle Payables subledger view, and is typically used in reconciliation reports, audit extracts, and period-end close queries related to payments.

Underlying Base Objects

Although the ETRM 12.2.2 metadata documents no base objects for this view, the view text references the SLA accounting tables through aliases. The primary aliases are AEH (the accounting event header), AEL (the accounting event line), and AE (the parent accounting event), joined to descriptive lookup sources aliased L3 through L13, plus payment and statement tables aliased SH (statement header), SL (statement line), I (invoice), C (check), FD (document sequence name), and GLCT (GL conversion types). The view's SELECT joins these into a unified projection of debits, credits, currency conversion attributes, and event references. Because the objects are referenced under aliases rather than documented as base objects, the view depends on the internal SLA data model and is best treated as read-only.

Key Columns

• ACCOUNTED_DR / ACCOUNTED_CR — Accounted debit and credit amounts from the SLA event line.
• ENTERED_DR / ENTERED_CR — Entered debit and credit amounts, in the transaction currency.
• ACCOUNTING_DATE — Accounting date of the event header.
• ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME — Code and displayed name for the accounting line type.
• AEH_ID / AEL_ID — Accounting header and line identifiers, with AEL_TABLE set to 'APAEL'.
• AE_LINE_REFERENCE — A concatenated descriptive reference distinguishing payment clearing, unclearing, and other payment events.
• CODE_COMBINATION_ID — The GL account combination used on the line.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_USER_CONVERSION_TYPE — Currency and conversion details.
• DOC_SEQUENCE_ID / DOC_SEQUENCE_NAME / DOC_SEQUENCE_VALUE — Subledger document sequence identifiers and values.
• GL_TRANSFER_STATUS / GL_TRANSFER_STATUS_NAME / TRANSFER_STATUS_DETAIL_NAME — Transfer-to-GL status codes and names.
• ORG_ID / SET_OF_BOOKS_ID — Operating unit and ledger identifiers.
• SOURCE_ID / SOURCE_TABLE — Originating transaction identifiers, such as AP_INVOICE_PAYMENTS.

Common Use Cases and Queries

Typical uses include payment/clearing reconciliation, audit sampling of payment accounting entries, and verifying GL transfer status before period close. A basic extract:

• SELECT accounting_date, acct_line_type_name, accounted_dr, accounted_cr, ae_line_reference, gl_transfer_status_name FROM ap_ael_sl_pay_v WHERE accounting_date BETWEEN :p_start AND :p_end ORDER BY accounting_date;
• SELECT source_id, source_table, doc_sequence_name, doc_sequence_value, accounted_dr, accounted_cr FROM ap_ael_sl_pay_v WHERE gl_transfer_status IN ('N','P');
• SELECT set_of_books_id, org_id, currency_code, SUM(accounted_dr) total_dr, SUM(accounted_cr) total_cr FROM ap_ael_sl_pay_v GROUP BY set_of_books_id, org_id, currency_code;

These queries support close activities and reconciliation of payment subledger accounting against GL balances.