Search Results ail_cost_center_segment




Overview
Explore in AI Chat

Overview

APPS.AP_EXTRACT_INVOICE_DTLS_BC_V is a reporting and extraction view in the Oracle E-Business Suite Payables (AP) module. The suffix "BC" denotes its participation in the Business Events / Subledger Accounting extraction pipeline, specifically the flow that captures invoice-level and invoice distribution-level detail for downstream consumption. The view consolidates payable invoice headers, invoice lines, and invoice distributions into a single flat projection, enriching them with subledger accounting attributes, tax and withholding information, encumbrance context, and purchasing receipt linkage.

In the Oracle EBS 12.1.1 and 12.2.2 releases, this view serves as a denormalized source used by extraction programs and interfaces that must move invoice detail into external ledgers, data warehouses, or custom reporting repositories. It is registered under FND Design Data as SQLAP.AP_EXTRACT_INVOICE_DTLS_BC_V and remains VALID in the ETRM 12.2.2 data model. Because it joins header, line, and distribution tiers, it removes the need for consumers to reconstruct the Payables hierarchy manually, and it exposes accounting and descriptive flexfield attributes that are otherwise scattered across several transactional tables.

Underlying Base Objects

The view is defined over a documented set of base tables, synonyms, and package/view dependencies. The transactional core is AP_INVOICES_ALL (invoice headers), AP_INVOICE_LINES_ALL (invoice lines), and AP_INVOICE_DISTRIBUTIONS_ALL (invoice distributions). Ancillary Payables objects include AP_AWT_GROUPS for withholding tax group definitions, AP_SELF_ASSESSED_TAX_DIST_ALL for self-assessed tax distributions, AP_SYSTEM_PARAMETERS_ALL and FINANCIALS_SYSTEM_PARAMS_ALL for profile-driven extraction behavior, and AP_UTILITIES_PKG for common Payables functions invoked in the projection logic.

Procurement and receiving context is supplied through PO_HEADERS_ALL, PO_DISTRIBUTIONS_ALL, and RCV_TRANSACTIONS, permitting the view to carry purchase order and receipt references alongside invoice detail. Subledger accounting and event generation dependencies include IGC_CC_SLA_BFLOW_PRIOR_V and PSA_BC_XLA_PUB, which tie the view to the accounting event model. GL_ENCUMBRANCE_TYPES provides encumbrance type validation relevant to commitment accounting. Collectively these objects establish the view as a multi-join projection rather than a single-table extract.

Key Columns

Columns are prefixed to indicate their origin. The AID_ prefix denotes AP_INVOICE_DISTRIBUTIONS_ALL attributes, including AID_AMOUNT, AID_STAT_AMOUNT, AID_ACCOUNTING_DATE, AID_DIST_CCID, AID_PERIOD_NAME, AID_DESCRIPTION, AID_EXPENDITURE_TYPE, and the AID_ATTRIBUTE1 through AID_ATTRIBUTE15 descriptive flexfield set. AID_ASSETS_TRACKING_FLAG, AID_AWARD_ID, AID_TAX_RECOVERABLE_FLAG, and AID_TYPE_1099 support asset, grant, tax, and 1099 reporting. The AIL_ prefix denotes AP_INVOICE_LINES_ALL attributes such as AIL_LINE_TYPE_LOOKUP_CODE, AIL_DESCRIPTION, AIL_LINE_SOURCE, AIL_ITEM_DESCRIPTION, and the segment columns AIL_ACCOUNT_SEGMENT, AIL_BALANCING_SEGMENT, and AIL_COST_CENTER_SEGMENT. Event and deferral control columns include EVENT_ID, LINE_NUMBER, DEFERRED_OPTION, DEFERRED_START_DATE, DEFERRED_END_DATE, DEFERRED_PERIOD_TYPE, and DEFERRED_NUMBER_OF_PERIODS. The user's search term "ail_amount" aligns with the invoice line and distribution amount family, making AID_AMOUNT and AID_STAT_AMOUNT the primary retrievable amount values in this view.

Common Use Cases and Queries

Typical uses include invoice detail extraction for warehouse loading, reconciliation of accounting events, and audit reporting on tax, withholding, and distribution amounts.

  • Extracting invoice distribution amounts and accounting dates for a period.
  • Reconciling subledger event data against distribution-level accounting.
  • Reporting deferred and withholding amounts by supplier or invoice.
  • Feeding downstream ledgers with PO and receipt context.

Sample query for periods and amounts:

SELECT EVENT_ID, LINE_NUMBER, AID_PERIOD_NAME, AID_ACCOUNTING_DATE, AID_AMOUNT, AID_STAT_AMOUNT FROM APPS.AP_EXTRACT_INVOICE_DTLS_BC_V WHERE AID_PERIOD_NAME = :period AND AID_AMOUNT <> 0;

Sample query joining invoice context by event:

SELECT e.EVENT_ID, e.AIL_LINE_TYPE_LOOKUP_CODE, e.AIL_DESCRIPTION, e.AID_DISTRIBUTION_LINE_NUMBER, e.AID_AMOUNT FROM APPS.AP_EXTRACT_INVOICE_DTLS_BC_V e WHERE e.EVENT_ID = :event_id ORDER BY e.LINE_NUMBER;