Search Results ap_entity_code

Overview

APPS.PA_XLA_BC_PKT_AP_DETAIL_V is an internal Oracle E-Business Suite view owned by the APPS schema and registered in the Applications database as PA.PA_XLA_BC_PKT_AP_DETAIL_V. It supplies the Payables-side detail lines that feed the Subledger Accounting (XLA) accounting program for Oracle Projects, specifically the extraction of Payables invoice distribution data used when constructing accounting packet (BC packet) records. The view is classified as Oracle Internal Use Only; Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. Its presence in a 12.1.1 or 12.2.2 environment therefore indicates a supporting database object for the Projects SLA integration rather than a customer-facing reporting view.

The name components are instructive: "PA" denotes Oracle Projects, "XLA" denotes Subledger Accounting, "BC_PKT" denotes the accounting packet construct, and "AP_DETAIL" denotes the Payables distribution-level detail being surfaced. The view is a join and projection layer that presents invoice distribution lines together with the Project accounting identifiers and accounting-flexfield attributes that the SLA engine requires.

Underlying Base Objects

The view is defined over the following documented objects:

• AP_INVOICE_DISTRIBUTIONS_ALL — the Payables invoice distribution table, providing the invoice line amounts, accounting dates, and Payables distribution identifiers.
• AP_PREPAY_APP_DISTS — the Payables prepayment application distributions, allowing prepayment applications to be linked to their originating distributions.
• GL_LEDGERS — the ledger definition, supplying ledger currency and ledger identifiers used to determine functional amounts.
• PA_BC_PACKETS — the Projects accounting packet table, which links the extracted detail to the packet being processed.
• PA_RESOURCE_LIST_MEMBERS — the Projects resource list membership table, used to resolve resource and expenditure type information.
• XLA_EVENTS_GT — the Subledger Accounting events global temporary table, used to correlate the source events driving the accounting.
• PA_FUNDS_CONTROL_UTILS — a PL/SQL package referenced by the view, indicating calls to Projects funds control utilities (for example, for budgeting or funds check logic).

Key Columns

The column list includes the identifiers and attributes required by the SLA engine. EVENT_ID and SOURCE_EVENT_ID tie each row to the accounting event and its originating transaction event; LINE_NUMBER provides sequencing within the event. AID_INVOICE_DIST_ID is the Payables invoice distribution identifier, and AID_EXPENDITURE_TYPE carries the Projects expenditure type. AID_PROJECT_ID, AID_TASK_ID, and AID_EXPENDITURE_ORG_ID identify the project, task, and expenditure organization, while AID_EXPENDITURE_ITEM_DATE gives the expenditure item date.

Amount columns include AID_BASE_AMT_NO_ROUND and AID_AMOUNT. Currency handling is supported by AI_INVOICE_CURRENCY_CODE, LEDGER_CURRENCY, INV_EXCHANGE_RATE_TYPE, INV_EXCHANGE_DATE, and INV_EXCHANGE_RATE. Accounting attributes are exposed through BUDGET_CCID, ENC_UPG_DR_ACCOUNT, ENC_UPG_CR_ACCOUNT, ENC_UPG_DR_ACCT_CLASS, ENC_UPG_CR_ACCT_CLASS, and related encumbrance columns. Payables linkage is provided by AP_APPLICATION_ID, AP_DISTRIBUTION_TYPE, AP_ENTITY_CODE, AP_FIRST_DIST_ID, and AP_SECOND_DIST_ID, with parallel PO_ columns for purchasing references. DISTRIBUTION_LINK_TYPE, REV_EVENT_TYPE, EXPENDITURE_CATEGORY, and REVENUE_CATEGORY classify the line for accounting rule derivation.

Common Use Cases and Queries

Because the view is internal, the supported use case is the Oracle Projects SLA accounting process, which reads Payables distribution detail to generate accounting entries. A representative diagnostic query, used to trace expenditure type information for a packet, is:

• SELECT event_id, line_number, aid_invoice_dist_id, aid_expenditure_type, aid_project_id, aid_task_id, aid_amount FROM apps.pa_xla_bc_pkt_ap_detail_v WHERE aid_expenditure_type = :p_expenditure_type;

Subsidiary diagnostics include retrieving the currency and exchange attributes for a given distribution, or reconciling the Payables distribution identifiers (AP_FIRST_DIST_ID, AP_SECOND_DIST_ID) against AP_INVOICE_DISTRIBUTIONS_ALL to confirm the source line. Any query should be treated as a diagnostic aid only; production processing must continue to rely on the standard Oracle Applications programs that consume this view.