Results for “res_util_category_id”

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

Overview

PA_OBJECTS is a Projects (PA) module table that stores the reporting objects for which summarized project balances are created. In Oracle EBS 12.1.1 and 12.2.2, it functions as the dimensional backbone of the Project Summarization process, defining each unique combination of project, task, organization, expenditure type, and related attributes for which PA_SUMM_BALANCES rows are generated. Consumers include project cost reporting, utilization analysis, and summarized inquiry screens that depend on pre-aggregated balances rather than transactional detail.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning. It carries a dense set of descriptive attributes and dimension references rather than acting as a pure hub or a pure link, which suggests modeling it as a satellite over a project-related hub-and-link combination. The object resides in the PA schema and is fully documented as VALID in ETRM 12.2.2 with 25 columns.

Key Information Stored

The primary key is PA_OBJECTS_PK, defined on OBJECT_ID, the surrogate key that PA_SUMM_BALANCES references when storing summarized amounts. Business-key candidates are captured by the unique index PA_OBJECTS_U2, whose column list defines the full dimensional grain of a reporting object.

• OBJECT_ID — surrogate primary key; the join key to PA_SUMM_BALANCES.
• OBJECT_TYPE_CODE and BALANCE_TYPE_CODE — classify the reporting object and the type of balance it represents.
• PROJECT_ID, TASK_ID — the project and task dimension at which the object is defined (PA_PROJECTS_ALL, PA_TASKS).
• PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID — owning/executing organization for the project side.
• EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID — organization responsible for the expenditure side.
• PERSON_ID, ASSIGNMENT_ID — the person and assignment associated with the object (PA_PROJECT_ASSIGNMENTS).
• WORK_TYPE_ID — work type classifier (PA_WORK_TYPES_B).
• ORG_UTIL_CATEGORY_ID, RES_UTIL_CATEGORY_ID — organizational and resource utilization categories (PA_UTIL_CATEGORIES_B).
• EXPENDITURE_TYPE, EXPENDITURE_TYPE_CLASS — expenditure type code and its class.
• LAST_UPDATE_DATE and related audit columns (CREATION_DATE, LAST_UPDATED_BY, CREATED_BY, REQUEST_ID, PROGRAM_ID) — standard EBS Who/audit and concurrent program context.

Common Use Cases and Queries

PA_OBJECTS is typically queried when joining summarized balances back to their descriptive dimensions, or when validating which dimensional combinations have been summarized. A representative pattern:

• Retrieve summarized amounts with project and task context: SELECT o.object_id, o.object_type_code, o.project_id, o.task_id, s.* FROM pa_objects o, pa_summ_balances s WHERE o.object_id = s.object_id AND o.project_id = :project_id;
• List reporting objects for a project organization: SELECT * FROM pa_objects WHERE project_org_id = :org_id AND object_type_code = :type;
• Reconcile object counts against summarized balances to detect missing or stale summarization.
• Feed custom project cost dashboards that need the object grain without touching transactional PA tables.

Related Objects

The following objects are the most significant dependencies, based on documented foreign-key and reference metadata:

• PA_SUMM_BALANCES — references PA_OBJECTS.OBJECT_ID; stores the summarized balances keyed to each reporting object.
• PA_PROJECTS_ALL — joined via PA_OBJECTS.PROJECT_ID.
• PA_TASKS — joined via PA_OBJECTS.TASK_ID.
• PA_PROJECT_ASSIGNMENTS — joined via PA_OBJECTS.ASSIGNMENT_ID.
• PA_WORK_TYPES_B — joined via PA_OBJECTS.WORK_TYPE_ID.
• PA_UTIL_CATEGORIES_B — referenced twice, via ORG_UTIL_CATEGORY_ID and RES_UTIL_CATEGORY_ID.
• HR_ALL_ORGANIZATION_UNITS — referenced by PROJECT_ORG_ID, EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID, and OBJECT_ID.