Search Results recvr_cc_allow_iu_flag

Overview

APPS.PA_CROSS_CHARGEABLE_OU_BASE_V is an Oracle EBS internal view owned by the APPS schema in the Projects (PA) module. It is a foundational, base-level view that identifies which operating units can participate in cross-charge transactions — that is, which provider and receiver operating unit combinations are permitted to exchange project costs and expenditures across legal entities, sets of books and business groups. The view is marked with the standard Oracle warning that it is designated for Oracle Internal Use Only, meaning it is not supported for direct customer access except through standard Oracle Applications programs. In release 12.1.1 and 12.2.2 it serves as the internal data source consumed by the public-facing view PA_CROSS_CHARGEABLE_OU_V, which surfaces the derived cross-charge eligibility to application logic and reporting.

Underlying Base Objects

The view is defined over four documented objects. HR_ORGANIZATION_INFORMATION provides the organization classification and organization structure version attributes used to resolve provider and receiver operating units. PA_IMPLEMENTATIONS and PA_IMPLEMENTATIONS_ALL supply the implementation-level operating unit, business group and set of books context for each provider and receiver. The PA_CROSS_BUSINESS_GRP package encapsulates the business rules that determine whether cross-charging between two organizations, business groups or legal entities is allowed. The view therefore acts as a join and de-normalization layer: it combines organizational hierarchy data with implementation parameters and applies the PA_CROSS_BUSINESS_GRP logic to produce a row-level matrix of allowable cross-charge operating unit pairs. PA_CROSS_CHARGEABLE_OU_V is the only documented dependent object, inheriting and filtering the base rows for broader consumption.

Key Columns

• PRVDR_ORG_ID / RECVR_ORG_ID — provider and receiver operating unit identifiers that form the core pairing of the view.
• BUSINESS_GROUP_ID / RECVR_BUSINESS_GROUP_ID — business group context for each side of the transaction.
• SET_OF_BOOKS_ID — the ledger (set of books) associated with the provider implementation.
• PA_PERIOD_TYPE — the period type used by the implementation, relevant to cross-charge timing.
• PRVDR_LEGAL_ENTITY_ID / RECVR_LEGAL_ENTITY_ID — legal entity identifiers; both are VARCHAR2(150), reflecting the surrogate legal entity identification used in R12.
• PROJ_START_ORG_ID, EXP_START_ORG_ID, START_ORGANIZATION_ID — starting organization identifiers for the project and expenditure organization structures, alongside the associated structure and version IDs (PROJ_ORG_STRUCTURE_ID, EXP_ORG_STRUCTURE_ID, ORG_STRUCTURE_VERSION_ID, ORGANIZATION_STRUCTURE_ID). The column PROJ_START_ORG_ID is the attribute the user searched for and represents the top (start) organization of the project organization structure hierarchy.
• PRVDR_CC_ALLOW_IU_FLAG / RECVR_CC_ALLOW_IU_FLAG — flags indicating whether cross-charging is allowed for the provider and receiver for inter-organization or intra-unit processing roles.

Common Use Cases and Queries

This view is typically queried to diagnose cross-charge configuration issues — for example, when a cross-charge transaction fails because the provider/receiver operating unit combination is not permitted. A representative query echoing the column list is:

SELECT PRVDR_ORG_ID, RECVR_ORG_ID, BUSINESS_GROUP_ID, SET_OF_BOOKS_ID,
       PROJ_START_ORG_ID, EXP_START_ORG_ID, START_ORGANIZATION_ID,
       PRVDR_CC_ALLOW_IU_FLAG, RECVR_CC_ALLOW_IU_FLAG
FROM   APPS.PA_CROSS_CHARGEABLE_OU_BASE_V
WHERE  PRVDR_ORG_ID = :p_provider_org
AND    RECVR_ORG_ID = :p_receiver_org;

Because the object carries the Oracle Internal Use Only restriction, production queries should reference PA_CROSS_CHARGEABLE_OU_V or call standard Oracle APIs rather than depend on the base view directly.