Search Results gmd_recipe_orgn_resources
The GMD_RECIPE_ORGN_RESOURCES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Oracle Process Manufacturing (OPM) module, specifically tied to the Global Manufacturing and Distribution (GMD) application. This table stores information about organizational resources associated with recipes, which are essential for production planning, execution, and costing in manufacturing environments. Below is a detailed technical and functional analysis of this table.
Functional Overview
The GMD_RECIPE_ORGN_RESOURCES table serves as a junction between recipes and organizational resources, enabling manufacturers to define and manage resource allocations for production processes. Resources may include labor, equipment, or facilities required to execute a recipe. This linkage ensures accurate resource scheduling, capacity planning, and cost calculations during manufacturing operations.Technical Structure
Key columns in the table include:- RECIPE_ORGN_RESOURCE_ID: Primary key, uniquely identifying each resource assignment.
- RECIPE_ID: Foreign key referencing GMD_RECIPES_B, linking to the recipe.
- ORGANIZATION_ID: Identifies the inventory organization where the resource is utilized.
- RESOURCE_ID: Foreign key to CR_RSRC_DEFN_B, specifying the resource (e.g., machine, labor).
- USAGE_UOM: Unit of measure for resource consumption (e.g., hours, minutes).
- ACTIVITY: Describes the role of the resource in the recipe (e.g., setup, processing).
- COST_ANALYSIS_CODE: Determines how resource costs are allocated (fixed, variable).
- START_DATE and END_DATE: Define the validity period of the resource assignment.
Integration Points
The table integrates with:- GMD_RECIPES_B: Core recipe definition table.
- CR_RSRC_DEFN_B: Resource master data.
- BOM_RESOURCES: Bill of Materials resources for costing.
- GME_BATCH_STEP_RESOURCES: Tracks actual resource usage during batch execution.
Business Process Context
During recipe creation, resources are assigned to steps or operations, influencing:- Scheduling: Finite/infinite capacity planning via Oracle Advanced Supply Chain Planning (ASCP).
- Costing: Resource costs roll up into standard cost calculations.
- Execution: Real-time resource tracking in Oracle Process Execution (OPEX).
Customization Considerations
Modifications to this table require caution due to:- Dependencies on OPM’s costing and scheduling engines.
- Potential impacts on batch documentation and compliance reporting.
- Integration with Oracle’s Manufacturing Execution Systems (MES).
Data Management
Typical operations include:- Bulk loading via Oracle’s Open Interfaces (e.g., GMD_RECIPE_LOAD).
- Audit trails through FND_AUDIT_COLUMNS columns (created_by, creation_date, etc.).
- Archiving strategies for historical data retention.
Performance Implications
Indexes on RECIPE_ID, RESOURCE_ID, and ORGANIZATION_ID are critical for query performance, especially in complex manufacturing environments with thousands of recipes. Partitioning may be considered for high-volume implementations.Conclusion
The GMD_RECIPE_ORGN_RESOURCES table is a foundational component in Oracle OPM, bridging recipe design with operational execution. Its proper configuration ensures accurate resource planning, cost management, and regulatory compliance in process manufacturing. Understanding its structure and relationships is essential for implementations, upgrades, and customizations in Oracle EBS 12.1.1/12.2.2 environments.-
Table: GMD_RECIPE_ORGN_RESOURCES
12.1.1
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_RECIPE_ORGN_RESOURCES, object_name:GMD_RECIPE_ORGN_RESOURCES, status:VALID, product: GMD - Process Manufacturing Product Development , description: This table stores updates to operation resources at the recipe level. , implementation_dba_data: GMD.GMD_RECIPE_ORGN_RESOURCES ,
-
Table: GMD_RECIPE_ORGN_RESOURCES
12.2.2
owner:GMD, object_type:TABLE, fnd_design_data:GMD.GMD_RECIPE_ORGN_RESOURCES, object_name:GMD_RECIPE_ORGN_RESOURCES, status:VALID, product: GMD - Process Manufacturing Product Development , description: This table stores updates to operation resources at the recipe level. , implementation_dba_data: GMD.GMD_RECIPE_ORGN_RESOURCES ,
-
APPS.GMD_COMMON_VAL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_MBR_UTIL_PKG dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_MBR_UTIL_PKG dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_ROUTING_STEPS_PVT dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_ROUTING_STEPS_PVT dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_VERSION_CONTROL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_PROC_PARAMS_MIGR dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_RECIPE_ORGN_RESOURCES
12.1.1
-
APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_VERSION_CONTROL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_COMMON_VAL dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_PROC_PARAMS_MIGR dependencies on GMD_RECIPE_ORGN_RESOURCES
12.2.2
-
APPS.GMD_PROC_PARAMS_MIGR dependencies on GME_BATCH_STEP_RESOURCES
12.1.1
-
APPS.GMD_PROC_PARAMS_MIGR dependencies on GME_BATCH_STEP_RESOURCES
12.2.2
-
VIEW: APPS.GMD_RECIPE_ORGN_RESOURCES_DFV
12.1.1
-
APPS.GMD_PROC_PARAMS_MIGR dependencies on GMD_OPERATION_RESOURCES
12.1.1
-
APPS.GMD_PROC_PARAMS_MIGR dependencies on GMD_OPERATION_RESOURCES
12.2.2
-
VIEW: APPS.GMD_RECIPE_ORGN_RESOURCES_DFV
12.2.2
-
SYNONYM: APPS.GMD_RECIPE_ORGN_RESOURCES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMD_RECIPE_ORGN_RESOURCES, status:VALID,
-
SYNONYM: APPS.GMD_RECIPE_ORGN_RESOURCES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMD_RECIPE_ORGN_RESOURCES, status:VALID,
-
VIEW: GMD.GMD_RECIPE_ORGN_RESOURCES#
12.2.2
owner:GMD, object_type:VIEW, object_name:GMD_RECIPE_ORGN_RESOURCES#, status:VALID,
-
APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_RECIPE_ORGN_ACTIVITIES
12.2.2
-
VIEW: GMD.GMD_RECIPE_ORGN_RESOURCES#
12.2.2
-
APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_RECIPE_ORGN_ACTIVITIES
12.1.1
-
PACKAGE BODY: APPS.GMD_MBR_UTIL_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_MBR_UTIL_PKG, status:VALID,
-
VIEW: APPS.GMD_RECIPE_ORGN_RESOURCES_DFV
12.1.1
owner:APPS, object_type:VIEW, object_name:GMD_RECIPE_ORGN_RESOURCES_DFV, status:VALID,
-
PACKAGE BODY: APPS.GMD_MBR_UTIL_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_MBR_UTIL_PKG, status:VALID,
-
VIEW: APPS.GMD_RECIPE_ORGN_RESOURCES_DFV
12.2.2
owner:APPS, object_type:VIEW, object_name:GMD_RECIPE_ORGN_RESOURCES_DFV, status:VALID,
-
PACKAGE BODY: APPS.GMD_PROC_PARAMS_MIGR
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_PROC_PARAMS_MIGR, status:VALID,
-
PACKAGE BODY: APPS.GMD_PROC_PARAMS_MIGR
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_PROC_PARAMS_MIGR, status:VALID,
-
APPS.GMD_COMMON_VAL dependencies on CR_RSRC_DTL
12.1.1
-
APPS.GMD_COMMON_VAL dependencies on CR_RSRC_DTL
12.2.2
-
PACKAGE BODY: APPS.GMD_RECIPE_FETCH_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RECIPE_FETCH_PUB, status:VALID,
-
PACKAGE BODY: APPS.GMD_RECIPE_DETAIL_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RECIPE_DETAIL_PVT, status:VALID,
-
APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_OPERATION_ACTIVITIES
12.1.1
-
PACKAGE BODY: APPS.GMD_RECIPE_DETAIL_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_RECIPE_DETAIL_PVT, status:VALID,