Search Results ail_attribute1

Overview

AP_PREPAYAPP_EXTRACT_DETAILS_V is a reporting and integration view owned by the APPS schema within the Oracle E-Business Suite Application Object Library (FND) product grouping. It exposes the accounting and distribution detail lines generated when a prepayment invoice is applied against a standard invoice in Oracle Payables. In the Oracle EBS 12.1.1 and 12.2.2 data models, prepayment application is an accounting event that must be transferred to Subledger Accounting (SLA) and ultimately to the General Ledger. This view is designed to serve as an extraction source for that flow, presenting the prepayment application distributions alongside the accounting event identifiers, deferred accounting attributes, currency context, and descriptive flexfield attributes needed to construct and validate journal entries.

The view's role is primarily that of an accounting extract: it flattens the relationship between the payment history tables, the prepayment application distribution records, the invoice line records, and the accounting information lines (AIL). The presence of the DISTRIBUTION_LINK_TYPE literal 'AP_PREPAY' indicates that this view participates in a broader, link-type-driven extraction framework in which different distribution categories are distinguished by a constant value. Reporting and integration consumers can therefore filter on this column to isolate prepayment application activity from other distribution types within a shared extraction structure.

Underlying Base Objects

The documented base objects underlying AP_PREPAYAPP_EXTRACT_DETAILS_V are drawn principally from the Payables and Subledger Accounting schemas. The core prepayment distribution data resides in AP_PREPAY_APP_DISTS and AP_PREPAY_HISTORY_ALL, while invoice and payment context come from AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_HISTORY_ALL, AP_PAYMENT_HIST_DISTS, and AP_CHECKS_ALL. Currency and clearing context are supplied through CE_GL_ACCOUNTS_CCID and the clearing distribution references. Subledger Accounting and general ledger integration dependencies include PSA_BC_XLA_PUB (a package), XLA_EVENTS_GT, and GL_ENCUMBRANCE_TYPES, with FINANCIALS_SYSTEM_PARAMS_ALL and PO_DISTRIBUTIONS_ALL providing system parameter and purchase order distribution context where applicable.

All base tables are referenced through APPS synonyms, meaning the view is defined against the APPS-owned synonyms that point to the underlying application tables. This is consistent with standard Oracle EBS view architecture, where APPS synonyms abstract the physical table ownership and allow the view to be queried directly from the APPS schema without fully qualified table names.

Key Columns

The view exposes a number of critical columns. EVENT_ID maps to APPH.ACCOUNTING_EVENT_ID and identifies the accounting event associated with the prepayment application. LINE_NUMBER is derived from APAD.PREPAY_APP_DIST_ID and serves as the distribution line identifier. DISTRIBUTION_LINK_TYPE is the constant 'AP_PREPAY', used to classify the extraction row. DEFERRED_OPTION, DEFERRED_START_DATE, DEFERRED_END_DATE, DEFERRED_NUMBER_OF_PERIODS, and DEFERRED_PERIOD_TYPE carry the deferred accounting attributes from the invoice line, supporting period-based expense recognition of prepayments.

APAD_DISTRIBUTION_IDENTIFIER and APAD_DIST_LOOKUP_CODE describe the prepayment application distribution itself, while DIST_ACCOUNT_REVERSAL_OPTION is derived via DECODE on APAD.REVERSED_PREPAY_APP_DIST_ID, returning 'Y' or 'N' to indicate whether the distribution account has been reversed. Monetary values are represented by APAD_AMOUNT and AIL_AMOUNT, with AIL_ROUNDING_AMT capturing rounding differences. Currency context is provided by PREPAY_PAY_CURRENCY_CODE and PREPAY_CLEAR_CURRENCY_CODE. The AIL_* columns mirror the accounting information line structure, including segment values (account, balancing, cost center), overlay distribution code concatenation, default distribution CCID, accounting date, period name, and the full ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 descriptive flexfield set, plus GLOBAL_ATTRIBUTE_CATEGORY.

Common Use Cases and Queries

Typical uses include reconciling prepayment application accounting entries, feeding downstream SLA and GL reporting, and auditing deferred accounting schedules tied to prepayments. A representative query retrieves application distributions for a given accounting event:

• SELECT event_id, line_number, apad_amount, prepay_pay_currency_code, dist_account_reversal_option FROM ap_prepayapp_extract_details_v WHERE event_id = :event_id;
• SELECT event_id, apad_distribution_identifier, apad_amount, ail_accounting_date, ail_period_name FROM ap_prepayapp_extract_details_v WHERE deferred_option = 'Y' ORDER BY event_id, line_number;
• SELECT distribution_link_type, COUNT(*), SUM(apad_amount) FROM ap_prepayapp_extract_details_v GROUP BY distribution_link_type;

Because the view joins multiple Payables and Subledger Accounting objects, queries should generally be constrained by accounting event, period, or prepay invoice to avoid large scans against the underlying distribution and history tables.