Search Results wip_sub_operation_resources




Overview
Explore in AI Chat

Overview

WIP_SUB_OPERATION_RESOURCES is an Oracle Work in Process (WIP) transactional table that stores the resource requirements and consumption detail associated with discrete job and repetitive schedule operations. Within Oracle EBS 12.1.1 and 12.2.2, this table represents the lowest level of the WIP routing hierarchy: an operation may require one or more resources, and each row in WIP_SUB_OPERATION_RESOURCES captures a single resource assignment for a specific operation sequence. The table mirrors the resource snapshot taken from the engineering routing (BOM) at the moment the job or schedule was created or released, and it is subsequently updated by shop floor movement transactions, resource charges, and cost rollup processes.

From a Data Vault modeling perspective, the heuristic classification assigned to this object is link. This classification reflects the table's role as an associative structure that connects a WIP entity/operation to a bill of material resource, with additional descriptive columns scoped by that relationship. Depending on the reporting granularity required, portions of the descriptive payload could also be modeled as satellite attributes attached to that link.

Key Information Stored

The table contains sixty documented columns. The most significant are summarized below.

Common Use Cases and Queries

Typical usage includes WIP resource cost analysis, discrepancy reports between planned and applied resource usage, and reconciliation feeds into CST_ACTIVITIES for cost accounting. A representative query lists resources for a discrete job:

  • SELECT wip_entity_id, operation_seq_num, resource_seq_num, resource_id, usage_rate_or_amount, applied_resource_units, applied_resource_value FROM wip.wip_sub_operation_resources WHERE wip_entity_id = :entity_id ORDER BY operation_seq_num, resource_seq_num;
  • Aggregate applied value by department or activity for period-end cost rollups.
  • Join to BOM_RESOURCES to display resource names and units of measure on shop-floor dispatch reports.

Related Objects

The following objects are the most significant relationships for WIP_SUB_OPERATION_RESOURCES:

  • WIP_OPERATIONS — parent operation; joined on WIP_ENTITY_ID, OPERATION_SEQ_NUM, and REPETITIVE_SCHEDULE_ID.
  • BOM_RESOURCES — resource definition; joined on RESOURCE_ID.
  • BOM_DEPARTMENTS — owning department; joined on DEPARTMENT_ID.
  • CST_ACTIVITIES — cost activity; joined on ACTIVITY_ID.
  • BOM_SETUP_TYPES — setup requirement; joined on SETUP_ID.
  • WIP_ENTITIES and WIP_DISCRETE_JOBS — through WIP_ENTITY_ID for header-level context.