Search Results proj_org_structure_version_id




Overview
Explore in AI Chat

Overview

APPS.PA_IMPLEMENTATIONS_ALL_MRC_V is a multi-reporting-currency (MRC) view in Oracle Projects. It exposes the implementation-level (system option and business group) configuration rows that govern how an Oracle Projects installation behaves across labor, usage, revenue, billing, invoicing, cross-charging, and multi-currency processing. The view derives from the base implementation table and presents one logical implementation record per business group (ORG_ID). Its role is chiefly reporting and integration: external systems, extracts, and diagnostic queries read it to obtain authoritative, version-specific implementation settings without directly touching the underlying transactional base table.

Because it is an MRC view, it is designed for environments that maintain multiple reporting currencies. In 12.1.1 and 12.2.2 the MRC family of views provides currency-attributed read access to the base implementation data, and PA_IMPLEMENTATIONS_ALL_MRC_V follows this convention. The overtime_calc_enabled_flag the user searched for is one of the configuration columns surfaced here, indicating whether overtime calculation is enabled for the implementation.

Underlying Base Objects

The documented referenced base object is PA_IMPLEMENTATIONS_ALL, accessed through a synonym. The view is a projection over that table: the SELECT list mirrors the implementation columns, supplemented by an audit-derived business group expression. Notably the view computes BUSINESS_GROUP_ID using NVL(TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),45,10)), -99), reading the current operating unit context from the client info string and defaulting to -99 when absent. This is the standard Oracle multi-org mechanism, so the view effectively filters and attributes implementation rows to the active business group. Columns such as ORG_ID, ORG_STRUCTURE_VERSION_ID, EXP_ORG_STRUCTURE_ID, and PROJ_ORG_STRUCTURE_ID preserve the organizational structure context of each implementation.

Key Columns

Common Use Cases and Queries

The view is typically queried to audit implementation configuration, confirm flags such as overtime calculation, or feed downstream reporting and integration extracts. A representative query:

SELECT org_id, business_group_id, overtime_calc_enabled_flag, interface_labor_to_gl_flag, multi_currency_billing_flag FROM apps.pa_implementations_all_mrc_v WHERE org_id = :p_org_id;

Administrators may also retrieve cross-charging and tax settings, or validate organization structure identifiers, using the same view. Because it is MRC-aware and multi-org-attributed, ensure the correct operating unit (client info) context is set before querying so that BUSINESS_GROUP_ID resolves as expected rather than defaulting to -99.