Search Results use_enc_upg_attrib_flag




Overview
Explore in AI Chat

Overview

The PA_XLA_BC_PKT_REQ_DETAIL_V view is an APPS-owned database object within the Oracle E-Business Suite Projects (PA) module. It exposes requisition-related encumbrance and Subledger Accounting (SLA) detail at the burden cost packet level, drawing together budget, encumbrance, and accounting attributes for purchase requisition distributions. The view is a supporting construct for the Projects funds control and encumbrance upgrade logic, providing the derived accounting amounts and account classes required when encumbrance accounting entries must be generated or upgraded to the SLA model.

The distinctive column USE_ENC_UPG_ATTRIB_FLAG, which prompted the user's search, is computed by an embedded call to PA_FUNDS_CONTROL_UTILS.GET_SLA_NOTUPGRADED_FLAG. This flag indicates whether the underlying requisition distribution has not yet been upgraded to the SLA encumbrance model. Its inputs include the application identifier (201 for Purchasing), the transaction type 'REQUISITION', the document header and distribution identifiers, the source table PO_REQ_DISTRIBUTIONS_ALL, and the budget version and budget line identifiers. The view therefore serves as an integration surface between Projects encumbrance processing and the requisition distributions maintained in Purchasing.

Underlying Base Objects

Per the documented ETRM metadata, the view references the following base objects: GL_LEDGERS (synonym), PA_BC_PACKETS (synonym), PA_FUNDS_CONTROL_UTILS (package), PA_RESOURCE_LIST_MEMBERS (synonym), and XLA_EVENTS_GT (synonym).

  • PA_BC_PACKETS supplies the core burden cost packet data, aliased as PBC in the view text, including the business event, document distribution, expenditure type, project and task, vendor, packet, and set of books identifiers.
  • GL_LEDGERS provides ledger context and currency information (CURRENCY_CODE) associated with the transaction.
  • PA_RESOURCE_LIST_MEMBERS contributes event type, expenditure category, revenue category, person, and job attributes.
  • XLA_EVENTS_GT is referenced to obtain the source event type code (XEV_SOURCE.EVENT_TYPE_CODE), which drives the directional decoding of debit and credit amounts through the funds control utility.
  • PA_FUNDS_CONTROL_UTILS is the PL/SQL package whose functions (DERIVE_PO_REQ_AMT_SIDE and GET_SLA_NOTUPGRADED_FLAG) perform the bulk of the derivation logic exposed by the view.

Key Columns

Common Use Cases and Queries

Typical reporting and diagnostic scenarios involve isolating requisition distributions that still require SLA encumbrance upgrade, or reconciling accounted versus entered amounts for requisition burden packets. A representative query filters on the upgrade flag:

  • Identify un-upgraded requisition distributions:
    • SELECT BC_EVENT_ID, DOCUMENT_HEADER_ID, DOCUMENT_DISTRIBUTION_ID, PROJECT_ID, TASK_ID, USE_ENC_UPG_ATTRIB_FLAG FROM APPS.PA_XLA_BC_PKT_REQ_DETAIL_V WHERE USE_ENC_UPG_ATTRIB_FLAG = 'Y';
  • Reconcile encumbrance amounts by account class:
    • SELECT PROJECT_ID, ENC_UPG_DR_ACCT_CLASS, ENC_UPG_CR_ACCT_CLASS, ACCOUNTED_DR, ACCOUNTED_CR FROM APPS.PA_XLA_BC_PKT_REQ_DETAIL_V WHERE BUDGET_VERSION_ID IS NOT NULL;

Because the view derives values through packaged PL/SQL functions, query performance is sensitive to the volume of requisition distributions evaluated, and filters on project, ledger, or flag columns should be applied wherever possible.