Oracle Fusion · Data dictionary
WIE_WO_OPERATIONS_B
SharedUsed in 27 subject areas29 reporting columns
Work in Process (WIE), base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: WO_OPERATION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): WORK_ORDER_ID → WIE_WORK_ORDERS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_COMPLETION_DATE | ● | Actual completion date. | |
| ACTUAL_START_DATE | ● | Actual start date. | |
| AUTO_TRANSACT_FLAG | ● | Indicator (Y/N) for the auto transact. | |
| COMPLETED_QUANTITY | ● | Completed quantity. | |
| COUNT_POINT_OPERATION_FLAG | ● | Indicator (Y/N) for the count point operation. | |
| EXECUTION_SEQUENCE | ● | Execution sequence. | |
| FIXED_LEAD_TIME | ● | Fixed lead time. | |
| IN_PROCESS_QUANTITY | ● | In process quantity. | |
| LEAD_TIME_UOM | ● | Lead time unit of measure. | |
| OPERATION_SEQ_NUMBER | ● | Operation seq number. | |
| OPERATION_TYPE | ● | Type of operation. | |
| OP_YIELD_FACTOR | ● | Op yield factor. | |
| OVER_RECEIPT_QUANTITY | ● | Over receipt quantity. | |
| PLANNED_COMPLETION_DATE | ● | Planned completion date. | |
| PLANNED_START_DATE | ● | Planned start date. | |
| PO_APPROVED_QUANTITY | ● | Purchase order approved quantity. | |
| PO_REQUESTED_QUANTITY | ● | Purchase order requested quantity. | |
| READY_QUANTITY | ● | Ready quantity. | |
| RECEIVED_QUANTITY | ● | Received quantity. | |
| REJECTED_QUANTITY | ● | Rejected quantity. | |
| RESEQUENCE_FLAG | ● | Indicator (Y/N) for the resequence. | |
| SCRAPPED_QUANTITY | ● | Scrapped quantity. | |
| SERIAL_TRACKING_FLAG | ● | Indicator (Y/N) for the serial tracking. | |
| SHIPPED_QUANTITY | ● | Shipped quantity. | |
| SHIPPING_DOCUMENTS_FLAG | ● | Indicator (Y/N) for the shipping documents. | |
| VARIABLE_LEAD_TIME | ● | Variable lead time. | |
| VARIANCE_QUANTITY | ● | Variance quantity. | |
| WORK_ORDER_ID | ● | Identifier for the work order. | |
| WO_OPERATION_ID | PK? | ● | Identifier for the wo operation. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Cost Accounting Real Time
- Costing - Work Order Costs Real Time
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Installed Base - Customer Asset Real Time
- Maintenance Management - Asset Equipment Qualification Real Time
- Maintenance Management - Asset Failure Analysis Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Production Exceptions Real Time
- Manufacturing - Purchased Item Usage Real Time
- Manufacturing - Resource Usage Real Time
- Manufacturing - Work Order Performance Real Time
- Manufacturing - Workstation Execution Activities Monitoring Real Time
Need the extract + dbt staging for WIE_WO_OPERATIONS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table