Results for “pc_enabled_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PQH_POSN_CTL_HIERARCHY_V view resides in the APPS schema and belongs to the Public Sector HR (PQH) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the organizational hierarchy relevant to Position Control, a Public Sector HR feature that enforces headcount and budgeting rules against positions within an organization. The view presents a flattened, hierarchical listing of organizations for which position control is enabled, ordered and numbered by level within the hierarchy.

Its principal role is to support reporting, validation, and integration logic that must traverse the position-control organizational tree. Because position control is rooted at a designated "top node" and constrained to a specific organization structure version, this view eliminates the need for consuming code to re-implement the recursive tree walk. The presence of the ROW_NUM column is significant: it provides a deterministic sequence number that reporting tools and PL/SQL routines can use for ordered display or iteration, while HIERARCHY_LEVEL conveys the depth of each organization within the tree.

Underlying Base Objects

The view is defined as a UNION of two queries, drawing on several documented base objects:

• HR_ALL_ORGANIZATION_UNITS (synonym) — supplies the top node organization in the first branch of the union.
• PER_ORG_STRUCTURE_ELEMENTS (synonym) — provides the parent/child organization relationships that drive the recursive CONNECT BY traversal in the second branch.
• PQH_PSF_BUS (package) — supplies position-control logic, including POSITION_CONTROL_ENABLED, GET_PC_TOPNODE, and GET_PC_STR_VERSION, which anchor the hierarchy to the correct top node and structure version.
• HR_GENERAL (package) — provides DECODE_ORGANIZATION and GET_BUSINESS_GROUP_ID for resolving organization names and defaulting the business group.
• FND_PROFILE (package) — retrieves the PER_BUSINESS_GROUP_ID profile value when no explicit business group context is available.

The union synthesizes a synthetic root row (with ROW_NUM = 0 and HIERARCHY_LEVEL = 0) with the recursively derived descendant rows produced by the CONNECT BY clause.

Key Columns

• ROW_NUM — A sequential identifier. The top node is assigned 0; descendant rows are numbered by ROWNUM within the query, giving a stable ordinal for sorting and display.
• HIERARCHY_LEVEL — The depth of the organization within the tree (0 at the top node, increasing with depth).
• BUSINESS_GROUP_NAME / BUSINESS_GROUP_ID — The business group to which the organization belongs, with the name resolved via HR_GENERAL.DECODE_ORGANIZATION.
• ORGANIZATION_NAME / ORGANIZATION_ID — The organization's decoded name and its primary key, used to join to other HR objects.
• PC_ENABLED_FLAG — Indicates whether position control is enabled for the organization; only organizations returning 'Y' are included.

Common Use Cases and Queries

Typical scenarios include position-control hierarchy reporting, validation of enabled organizations during position creation, and building pick lists for position-control setup. A representative query orders the hierarchy by level and row number:

• SELECT row_num, hierarchy_level, organization_id, organization_name FROM pqh_posn_ctl_hierarchy_v ORDER BY hierarchy_level, row_num;
• SELECT * FROM pqh_posn_ctl_hierarchy_v WHERE pc_enabled_flag = 'Y';
• SELECT organization_id FROM pqh_posn_ctl_hierarchy_v WHERE hierarchy_level = 1;

Because the view enforces the top node and structure version internally, consumers obtain a consistent, position-control-aware slice of the organization hierarchy without replicating the underlying business rules.