Search Results csd_wip_transaction_details




Overview
Explore in AI Chat

Overview

CSD_WIP_TRANSACTION_DETAILS is a transaction table owned by the CSD schema (Depot Repair) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the detailed work-in-process (WIP) transaction records generated by the High Volume Repair module, allowing the system to capture component-level and operation-level activity performed against repaired or rebuilt assemblies. Each row represents a discrete WIP transaction detail tied to a work order (WIP entity), an inventory item, and a specific operation and resource sequence, along with the employee, department, and standard operation responsible for the work.

In Data Vault modeling terms, the heuristic classification mined from the foreign key structure is standalone. That is, the table is not modeled as a hub, link, or satellite in a strict Data Vault sense; it functions as a self-contained transaction detail entity. Practically, it can be treated as a transactional satellite-like structure whose grain is defined by its primary key and unique business key combinations.

Key Information Stored

The table contains 48 documented columns. The most significant include:

A second unique index, CSD_WIP_TRANSACTION_DETAILS_U2, covers WIP_ENTITY_ID, INVENTORY_ITEM_ID, OPERATION_SEQ_NUM, and RESOURCE_SEQ_NUM, serving as an alternate business-key candidate.

Common Use Cases and Queries

Typical uses include repair cost analysis, throughput and cycle-time reporting, backflush verification, and material recovery reconciliation. A common query joins the table to WIP entities and items to summarize repair quantities by operation:

  • Summing TRANSACTION_QUANTITY by WIP_ENTITY_ID and OPERATION_SEQ_NUM to report operation progress.
  • Comparing QUANTITY_ISSUED against QUANTITY_RECOVERED to detect material variance.
  • Joining to PSB_EMPLOYEES and BOM_DEPARTMENTS to attribute labor and cost by department or technician.
  • Filtering on BACKFLUSH_FLAG to validate backflush assumptions in high-volume repair runs.
  • Using FIRST_UNIT_START_DATE and LAST_UNIT_COMPLETION_DATE to measure elapsed repair time per operation.

Related Objects

Foreign key relationships connect this table to the following key objects:

  • PSB_EMPLOYEES — joined on EMPLOYEE_ID for labor attribution.
  • BOM_DEPARTMENTS — joined on DEPARTMENT_ID for departmental reporting.
  • WSM_OPERATION_DETAILS — joined on STANDARD_OPERATION_ID for operation definitions.
  • CSD_WIP_TRANSACTION_DETAILS_PK — primary key constraint on WIP_TRANSACTION_DETAIL_ID.
  • Related WIP and inventory entities, such as the WIP entity and item tables referenced by WIP_ENTITY_ID and INVENTORY_ITEM_ID, which provide work order and item context.