Results for “pa_adw_orgs_v”

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

Overview

PA_ADW_ORGS_V is an Oracle E-Business Suite (EBS) Projects (PA) reporting view owned by the APPS schema. Its documented purpose is to supply the set of organization values that participate in the expenditure/projects organizations dimension within the Oracle Projects analytical data warehouse (ADW) model. In practice, the view presents a flattened, reporting-friendly list of organizations, each tagged with the identifier and name of the business group to which the organization belongs. This business group association is the reason the view surfaces in searches for the term "business_group": business group is a first-class column in the view and is the primary human-readable grouping attribute for the organization dimension.

The view is registered in ETRM with a status of VALID and is described simply as "Values for organizations on the expenditure/projects organizations dimension." It is a thin presentation layer rather than a base data store; its defining query is a straight projection over PA_ADW_ORGS_B_V that exposes a fixed editorial list of columns (ORGANIZATION_ID through USER_COL10). Its role is therefore to give downstream reports, extracts, and dimension loads a stable, denormalized interface to the Projects organizations dimension without requiring consumers to understand the underlying base view or security logic.

Underlying Base Objects

The view text defines PA_ADW_ORGS_V as a SELECT list from PA_ADW_ORGS_B_V, the "base" view in the ADW naming convention. The documented referenced base objects are:

• PA_ADW_ORGS_B_V (VIEW) — the immediate source of all columns exposed by PA_ADW_ORGS_V.
• HR_GENERAL (PACKAGE) — the Human Resources general-purpose package, typically involved in resolving organization and business group attributes.
• HR_SECURITY (PACKAGE) — the HR security package, which governs which organizations and business groups a given user or responsibility is permitted to see.

The relationship is therefore layered: PA_ADW_ORGS_V inherits the security-filtered organization/business group resolution logic implemented in PA_ADW_ORGS_B_V, which in turn depends on the HR_GENERAL and HR_SECURITY packages to derive organization attributes and to enforce access restrictions. Because security is applied at the base view level, data returned from PA_ADW_ORGS_V is already scoped to the accessing session's HR security profile. No independent filtering is added by the wrapper view.

Key Columns

The view exposes the following columns, in the order returned:

• ORGANIZATION_ID — the unique identifier of the organization, the primary key of the dimension and the join key to fact data and to HR/Projects organization tables.
• ORGANIZATION — the organization name, used as the display label of the dimension member.
• BUSINESS_GROUP — the business group associated with the organization. In an HR/Projects context a business group is the highest-level HR organization grouping; this column is the basis for grouping or filtering expenditure and project organizations by business group.
• USER_COL1 … USER_COL10 — ten generic, user-defined attribute columns. These support organization-level descriptive flexfield or custom dimension attributes and allow the warehouse to carry installation-specific classifications without schema changes.

Common Use Cases and Queries

Typical scenarios include deriving the organization dimension for Projects expenditure reporting, validating which business groups and organizations are visible under a security profile, and populating custom extracts or OBIEE/BI Publisher queries. Because it is validated and already HR-secured, it is a safe source for user-facing lists of valid project/expenditure organizations.

List all organizations with their business group:

• SELECT organization_id, organization, business_group FROM apps.pa_adw_orgs_v ORDER BY business_group, organization;

Restrict to a single business group:

• SELECT organization_id, organization FROM apps.pa_adw_orgs_v WHERE business_group = :business_group;

Join the dimension to a project organization fact using the exposed key:

• SELECT v.business_group, v.organization, f.* FROM apps.pa_adw_orgs_v v, some_fact f WHERE f.org_id = v.organization_id;

Surface user-defined attributes when configured:

• SELECT organization_id, user_col1, user_col2 FROM apps.pa_adw_orgs_v WHERE user_col1 IS NOT NULL;

In all cases the results returned are subject to HR security, so the same query may yield different rows for different responsibilities or users.