Results for “etc_method_code”

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

Overview

The PA.PA_PLAN_RES_DEFAULTS table stores the default settings applied to planning resource classes within Oracle Projects. These defaults govern how planning resources behave when defined at the resource class level, the project level, or the organization level, and they determine attributes such as spread curves, estimate-to-complete (ETC) methods, expenditure types, item category sets, and cost types that are inherited during project planning and budgeting.

In Oracle EBS 12.1.1 and 12.2.2, this table is a foundational configuration object for the Project Management and Project Costing functional areas. It enables planners to avoid re-entering the same planning parameters for every resource, instead applying organization-wide or project-wide defaults. The ETRM metadata classifies this object heuristically as a link in a Data Vault modeling sense, reflecting its role in connecting reference entities (resource classes, spread curves, cost types, expenditure types, and inventory organizations) rather than acting as a pure descriptive satellite or a standalone hub.

Key Information Stored

The table is identified by the surrogate primary key PLAN_RES_DEFAULT_ID, enforced through the constraint PA_PLAN_RES_DEFAULTS_PK. A secondary unique index, PA_PLAN_RES_DEFAULTS_U1, combines PLAN_RES_DEFAULT_ID with ZD_EDITION_NAME, supporting edition-based redefinition in 12.2.x environments.

The most business-significant columns include:

• RESOURCE_CLASS_ID — the planning resource class to which the defaults apply.
• OBJECT_TYPE and OBJECT_ID — indicate whether defaults are scoped at the organization, project, or resource class level.
• SPREAD_CURVE_ID — the default spread curve assigned to the resource class.
• ETC_METHOD_CODE — the default estimate-to-complete method.
• EXPENDITURE_TYPE — the default expenditure type for planning entries.
• ITEM_CATEGORY_SET_ID and ITEM_MASTER_ID — the inventory category set and master organization used when the resource is item-based.
• MFC_COST_TYPE_ID — the default cost type for manufacturing cost rollups.
• ENABLED_FLAG — indicates whether the default record is active.
• RECORD_VERSION_NUMBER — supports optimistic locking and concurrent update control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — standard Who columns for auditing.

Common Use Cases and Queries

Typical uses include verifying which spread curve or ETC method will be inherited by a planning resource, auditing project-level overrides of organization defaults, and reporting on resource class configurations. A common query retrieves enabled defaults for a given resource class:

• SELECT PLAN_RES_DEFAULT_ID, RESOURCE_CLASS_ID, SPREAD_CURVE_ID, ETC_METHOD_CODE, EXPENDITURE_TYPE FROM PA.PA_PLAN_RES_DEFAULTS WHERE RESOURCE_CLASS_ID = :resource_class_id AND ENABLED_FLAG = 'Y';
• To resolve organization-scoped defaults: WHERE OBJECT_TYPE = 'ORG' AND OBJECT_ID = :org_id.
• Joining to PA_RESOURCE_CLASSES_B and PA_SPREAD_CURVES_B produces a readable configuration report naming each default.

Because planning defaults influence budget generation and cost distribution, these queries often feed setup validation reports and project template diagnostics.

Related Objects

The table participates in several foreign key relationships central to project planning configuration:

• PA_RESOURCE_CLASSES_B — joined via RESOURCE_CLASS_ID; supplies the resource class name.
• PA_SPREAD_CURVES_B — joined via SPREAD_CURVE_ID; provides the spread curve definition.
• PA_EXPENDITURE_TYPES — joined via EXPENDITURE_TYPE; defines the default expenditure type.
• MTL_CATEGORY_SETS_B — joined via ITEM_CATEGORY_SET_ID; identifies the item category set.
• HR_ALL_ORGANIZATION_UNITS — joined via ITEM_MASTER_ID; identifies the item master organization.
• CST_COST_TYPES — joined via MFC_COST_TYPE_ID; supplies the manufacturing cost type.

Collectively these relationships make PA_PLAN_RES_DEFAULTS a connective configuration table within the Oracle Projects planning model.