Results for “pa_objects”

50+ results




Overview
Explore in AI Chat

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.

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.