Results for “current_flag”

50+ results




Overview
Explore in AI Chat

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

Overview

PA_RES_PROFILES_V is an Oracle E-Business Suite (EBS) Projects (PA) view owned by the APPS schema. It presents the detailed information of resource role profiles, exposing the descriptive and control attributes of role-profile assignments defined in the Projects application. In Release 12.1.1 and 12.2.2 the view remains the primary reporting surface for role profiles, and it is the object most frequently referenced when developers search on the column name "profile_id". The view consolidates the role-profile definition with its type lookup meaning and its approval status, and additionally derives a computed flag indicating whether a profile is currently active as an "actual" resource-role assignment. Because it joins lookup and status reference data, the view is well suited to operational reports, discoverer workbooks, custom concurrent programs, and integration extracts that require fully decoded role-profile data without embedding join logic against the lookup and status tables.

Underlying Base Objects

The view is defined over three documented base objects: PA_ROLE_PROFILES (synonym), which supplies the core profile rows including PROFILE_ID, PROFILE_NAME, RESOURCE_ID, PROFILE_TYPE_CODE, DESCRIPTION, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and APPROVAL_STATUS_CODE; PA_LOOKUPS (view), which is joined on LOOKUP_TYPE = 'PA_ROLE_PROFILE_TYPE' to translate the profile type code into a readable meaning; and PA_PROJECT_STATUSES (synonym), which is joined on STATUS_TYPE = 'ASGMT_APPRVL' to translate the approval status code into a project status name. The join conditions are therefore driven by PROFILE_TYPE_CODE = LOOKUP.LOOKUP_CODE and APPROVAL_STATUS_CODE = STATUS.PROJECT_STATUS_CODE, producing one row per role profile enriched with its type and approval descriptions. The CURRENT_FLAG value is derived through a scalar DECODE subquery against PA_ROLE_PROFILES, testing whether an overlapping "ACTUAL" profile exists for the same profile identifier with a RESOURCE_ID and a system date falling within its effective range.

Key Columns

  • PROFILE_ID — the unique identifier of the resource role profile; the column most commonly used in predicates and joins.
  • PROFILE_NAME — the user-visible name of the role profile.
  • RESOURCE_ID — the resource associated with the profile, where populated.
  • PROFILE_TYPE_CODE and PROFILE_TYPE_NAME — the profile type code and its decoded lookup meaning from PA_LOOKUPS.
  • DESCRIPTION — free-form description of the profile.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — the date range during which the profile is effective.
  • APPROVAL_STATUS_CODE and APPROVAL_STATUS_NAME — the approval status code and its decoded name from PA_PROJECT_STATUSES.
  • CURRENT_FLAG — a derived indicator (Y or N) signifying whether the profile is currently active as an actual resource assignment.

Common Use Cases and Queries

Typical uses include validating role-profile setup, listing currently effective profiles, driving resource-assignment reports, and filtering by approval status in integration extracts. The following example filters on the commonly searched identifier and returns only currently effective rows.

  • Lookup by identifier: SELECT profile_id, profile_name, resource_id, profile_type_name, approval_status_name, current_flag FROM pa_res_profiles_v WHERE profile_id = :p_profile_id;
  • Active profiles by type: SELECT profile_id, profile_name, effective_start_date, effective_end_date FROM pa_res_profiles_v WHERE profile_type_name = 'ACTUAL' AND TRUNC(SYSDATE) BETWEEN effective_start_date AND NVL(effective_end_date, TRUNC(SYSDATE)) ORDER BY profile_name;
  • Currently flagged assignments: SELECT profile_id, profile_name, resource_id FROM pa_res_profiles_v WHERE current_flag = 'Y';
  • Approval status reporting: SELECT approval_status_name, COUNT(*) FROM pa_res_profiles_v GROUP BY approval_status_name;