# DW_MFG_OPERATIONS_AGG_CF (Preview)

This table requires activation of Manufacturing functional area. This fact table stores Manufacturing Work Order Operations Aggregates

## Details

Module:

## Key Columns

SYSTEM_GEN_PK

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_GEN_PK | VARCHAR2 | 512 |  | True | Generated Primary Key for Internal Use Only |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. System Generated |  |
WORK_ORDER_DATE_CAL_MONTH_ID | NUMBER | 38 | 0 |  | Calendar Month for WORK_ORDER_DATE | DW_MONTH_D | CAL_MONTH_ID
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Refers to the top level, final assembly, subassembly, or model item which belongs to the given organization #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORGANIZATION_ID | NUMBER | 38 | 0 |  | The organization identifier that represents the manufacturing plant | DW_INTERNAL_ORG_D | ORGANIZATION_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business unit for the manufacturing plant | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEDGER_ID | NUMBER | 38 | 0 |  | Ledger associated to the business unit | DW_LEDGER_D | LEDGER_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity for the manufacturing plant | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
WORK_METHOD_ID | NUMBER | 38 | 0 |  | Represents the work method identifier for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. | DW_MFG_WORK_METHODS_TL | WORK_METHOD_ID
WORK_METHOD_CODE | VARCHAR2 | 32 |  |  | Work method code |  |
WORK_CENTER_ID | NUMBER | 38 | 0 |  | Indicates the work center where this operation is executed. | DW_MFG_WORK_CENTERS_D | WORK_CENTER_ID
WORK_AREA_ID | NUMBER | 38 | 0 |  | Indicates the work area where this operation is executed. | DW_MFG_WORK_AREAS_D | WORK_AREA_ID
COUNT_WO_OPERATION_ID | NUMBER |  |  |  | Count of Work Order Operations |  |
SUM_PERFORMANCE_RATIO | NUMBER |  |  |  | Sum of performance ratio for Operations |  |
SUM_FIRST_PASS_YIELD | NUMBER |  |  |  | Sum of First Pass Yield for operations |  |

## Notes

#1 In these cases in addition to the inventory item id column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D

Copyright © 2019, 2026, Oracle and/or its affiliates.