Search Results resource_analyst_id




Overview
Explore in AI Chat

Overview

PA_RES_SCH_TIMELINE_ROWLBL_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. Its documented purpose is to supply row label data for the resource schedule timeline, meaning it produces the descriptive entries that populate the resource-oriented rows of the timeline user interface and related reporting structures. The view is a read-only, security-filtered projection: it joins the timeline row label table to a denormalized resource table, then filters the result through Oracle Projects resource authorization and Oracle Applications user identity so that a session sees only the resources it is permitted to view. In EBS 12.1.1 and 12.2.2 the object remains a VALID view in the APPS schema and is used primarily to render resource rows in Project Resource Management scheduling pages and to support queries that need resource names, organizations, managers, and job levels aligned to timeline row labels.

Underlying Base Objects

The view text draws on the following documented base objects: PA_TIMELINE_ROW_LABEL (SYNONYM), which holds the row label records and types; PA_RESOURCES_DENORM (SYNONYM), the denormalized resource source supplying resource name, organization, manager, and job level; FND_GRANTS (SYNONYM) and FND_OBJECTS (SYNONYM), which drive the resource authorization check against the menu returned by PA_SECURITY_PVT.GET_MENU_ID('PA_PRM_RES_AUTH'); WF_ROLES (VIEW), used to link the grantee key to an HZ_PARTY original system; PER_ALL_PEOPLE_F (SYNONYM), used to resolve the party to a person identifier; and the packages PA_EXPENDITURES_UTILS and PA_SECURITY_PVT for organization name and menu resolution. The join is outer on the grants/objects side and constrained to row label type 'RESOURCE', with the resource effective dates bracketing the current system date and the person effective dates bracketing SYSDATE.

Key Columns

Common Use Cases and Queries

Typical usage includes validating resource authorization, reproducing the timeline resource row list, and reporting on resource analysts. Because the view is already security-filtered, results depend on the connected user's grants.

SELECT resource_id, resource_name, resource_analyst_id FROM pa_res_sch_timeline_rowlbl_v;

SELECT resource_id, resource_name, organization_name, manager_name FROM pa_res_sch_timeline_rowlbl_v WHERE sch_upd_pending_flag = 'Y';

SELECT resource_analyst_id, COUNT(*) FROM pa_res_sch_timeline_rowlbl_v GROUP BY resource_analyst_id;

Queries filtered by resource_analyst_id are common when reconciling resources to their assigned analysts, and joins to PER_ALL_PEOPLE_F on resource_analyst_id return the analyst's display name.