Search Results csd_group_job_param_temp




Overview
Explore in AI Chat

Overview

The CSD_GROUP_JOB_PARAM_TEMP table is a resolving table within the Oracle E-Business Suite (EBS) Depot Repair (CSD) module. Its primary function is to serve as a temporary staging area for data required to create Work in Process (WIP) jobs in bulk for multiple repair orders simultaneously. This table is central to the "mass repair orders" functionality, enabling efficient batch processing of repairs by grouping related orders and their parameters before job creation in the manufacturing subsystem. It acts as an intermediary, holding and organizing the necessary transactional data that links repair management to manufacturing execution.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which dictate the critical data points it stores. The primary key, GROUP_JOB_ID, uniquely identifies each parameter set within the temporary staging process. The foreign keys define the essential linkages: REPAIR_GROUP_ID associates the data with a specific grouping of repair orders in the CSD_REPAIR_ORDER_GROUPS table. INVENTORY_ITEM_ID and ORGANIZATION_ID together reference the specific item being repaired from the MTL_SYSTEM_ITEMS_B table. Finally, INCIDENT_ID links to the CS_INCIDENTS_ALL_B table, connecting the job parameters to the original service request or incident that initiated the repair. Collectively, these columns store the resolved identifiers needed to generate WIP jobs for all items within a repair group.

Common Use Cases and Queries

The primary use case is the background processing of the "Create WIP Jobs" concurrent program for mass repair orders. Data is populated into this table during the submission of this request, which then drives the creation of discrete jobs in WIP. A common diagnostic or reporting query would join this table to its referenced master data to verify parameters before job creation. For example:

  • Verifying staged items for a repair group: SELECT gjt.*, msib.segment1 item_code FROM csd_group_job_param_temp gjt, mtl_system_items_b msib WHERE gjt.inventory_item_id = msib.inventory_item_id AND gjt.organization_id = msib.organization_id AND gjt.repair_group_id = :p_group_id;
  • Identifying errors by checking for unresolved foreign key references or missing mandatory data before the WIP job creation process executes.

Related Objects

CSD_GROUP_JOB_PARAM_TEMP has defined dependencies on several core EBS tables, as documented by its foreign keys:

  • CSD_REPAIR_ORDER_GROUPS: Joined via REPAIR_GROUP_ID. This is the parent table defining the collection of repair orders slated for mass processing.
  • MTL_SYSTEM_ITEMS_B: Joined via the composite key INVENTORY_ITEM_ID and ORGANIZATION_ID. This provides master item information for the product being repaired.
  • CS_INCIDENTS_ALL_B: Joined via INCIDENT_ID. This links the repair job back to the original service request in the Service module.

As a temporary resolving table, it is typically referenced by internal Depot Repair programs and APIs that manage the mass WIP job creation workflow, rather than by other permanent tables.