Search Results plan_res_default_id

Overview

The PA_PLAN_RES_DEFAULTS table is a core data repository within the Oracle E-Business Suite Projects (PA) module. Its primary function is to store default configuration settings for planning resource classes, which are logical groupings of resources used for project planning and budgeting. These defaults are critical for streamlining the project planning process by pre-populating key attributes when assigning resources to project tasks. The table supports a hierarchical configuration model, allowing defaults to be defined at three distinct levels: globally for an entire resource class, specifically for a single project, or for an entire organization. This flexibility ensures that planning rules can be applied broadly or tailored to specific operational contexts.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which point to the essential data elements it manages. The primary identifier for each default record is the PLAN_RES_DEFAULT_ID. The table stores the context of the default rule through a RESOURCE_CLASS_ID and links to associated project or organization identifiers. Key operational defaults include a SPREAD_CURVE_ID for budget or forecast spreading, an EXPENDITURE_TYPE for cost classification, and an MFC_COST_TYPE_ID for manufacturing costing. For item-based planning, it references an ITEM_CATEGORY_SET_ID and an ITEM_MASTER_ID, which typically points to an organization that serves as the master inventory organization for the items.

Common Use Cases and Queries

A primary use case is the automated population of planning resource attributes during the creation of project budgets or forecasts. When a planner adds a resource from a specific class, the system queries this table to apply the predefined spread curve, expenditure type, and cost type. For reporting and administration, common queries involve identifying the effective defaults for a given project or resource class. A sample SQL pattern to retrieve all project-level defaults would be:

• SELECT plan_res_default_id, resource_class_id, project_id, spread_curve_id, expenditure_type FROM pa_plan_res_defaults WHERE project_id IS NOT NULL;

Another critical scenario is troubleshooting planning data inconsistencies, where analysts verify that the defaults applied to planned lines match the configured rules in this table.

Related Objects

PA_PLAN_RES_DEFAULTS is centrally connected to several fundamental EBS tables via foreign key constraints, as documented in the ETRM. These relationships define the valid domain of values for its configuration attributes:

• PA_RESOURCE_CLASSES_B: Via RESOURCE_CLASS_ID. This links the default to the specific resource class it configures.
• PA_SPREAD_CURVES_B: Via SPREAD_CURVE_ID. This defines the pattern for distributing planned amounts over time.
• MTL_CATEGORY_SETS_B: Via ITEM_CATEGORY_SET_ID. This links to the inventory category set for item categorization.
• HR_ALL_ORGANIZATION_UNITS: Via ITEM_MASTER_ID. This identifies the master organization for inventory items.
• CST_COST_TYPES: Via MFC_COST_TYPE_ID. This specifies the cost type for manufacturing cost collection.
• PA_EXPENDITURE_TYPES: Via EXPENDITURE_TYPE. This determines the default expenditure type for the planned resource.