Search Results alternate_resource

Overview

The GMP_ALTRESOURCE_PRODUCTS table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as a repository for defining product-specific alternate resources within the context of production process plans. This table enables planners to designate specific substitute or alternative resources that can be used for manufacturing a particular item, providing critical flexibility for scheduling and capacity planning. Its existence is essential for managing production scenarios where the primary resource is unavailable, allowing the system to automatically consider valid, pre-defined alternatives during planning and execution runs.

Key Information Stored

The table's structure centers on mapping a primary resource to a valid alternate for a specific inventory item. Based on the documented primary key constraint (GMP_ALTRESOURCE_PRODUCTS_U1), the table is uniquely identified by a combination of four key columns. The PRIMARY_RESOURCE and ALTERNATE_RESOURCE columns store identifiers for the primary and substitute resources, respectively, which are typically tied to the CRP resource master. The INVENTORY_ITEM_ID and ITEM_ID columns hold identifiers for the manufactured product, linking the alternate resource rule to a specific item in inventory. This design ensures that alternate resource assignments are scoped precisely to both the resource and the product, preventing unintended substitutions across different items or processes.

Common Use Cases and Queries

A primary use case is during detailed scheduling or capacity planning, where the planning engine queries this table to find permissible alternate resources if the primary one is constrained. This supports "what-if" analysis for plant load and helps maintain production continuity. For reporting, analysts often query this table to audit and validate alternate resource setups. A typical SQL pattern involves joining to inventory and resource tables to present a readable list.

• Sample Query: SELECT item.segment1 item_code, prim.resource_code primary_resource, alt.resource_code alternate_resource FROM gmp_altresource_products gap, mtl_system_items_b item, crp_resources prim, crp_resources alt WHERE gap.inventory_item_id = item.inventory_item_id AND gap.organization_id = item.organization_id AND gap.primary_resource = prim.resource_id AND gap.alternate_resource = alt.resource_id;
• Setup Validation: Queries are used to ensure no circular or duplicate alternate definitions exist for the same primary resource and item combination.

Related Objects

This table is intrinsically linked to other fundamental objects within the GMP and related manufacturing schemas. Its foreign key relationships and logical dependencies include:

• CRP_RESOURCES: The PRIMARY_RESOURCE and ALTERNATE_RESOURCE columns likely reference the RESOURCE_ID in this table, which defines all resources available for scheduling.
• MTL_SYSTEM_ITEMS_B: The INVENTORY_ITEM_ID and implied ORGANIZATION_ID link to this base items table to identify the product for which the alternate is valid.
• GMP_PROCESS_PLANS / GMP_OPERATIONS: The alternate resources defined in this table are utilized within process plans and their operations where the specific item is manufactured.
• Planning Engines (APS/MSC): The table is a key data source for the Advanced Planning and Scheduling and Manufacturing Scheduling engines when generating planned orders and schedules that require resource substitution.