Manufacturing
In the Manufacturing data model, the driver models data such as inspection events, production resources, and standard operations as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Oracle Fusion Cloud SCM account are immediately reflected in the driver.
Views
The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your Oracle Fusion Cloud SCM account.
Common views include:
| View | Description |
| WorkOrders | Manages discrete work orders detailing item, quantity, operations, resources, and timelines for discrete manufacturing. |
| WorkOrdersWorkOrderOperation | Manages the sequence of operations required to process a work order, outlining steps for efficient execution. |
| WorkOrdersWorkOrderMaterial | Tracks materials utilized in operations for work orders, supporting material planning and accountability. |
| WorkOrdersWorkOrderResource | Manages resources such as labor and machinery required to execute work orders effectively. |
| WorkOrdersWorkOrderStatus | Tracks the status of work orders, providing visibility into their progression and completion. |
| WorkOrdersWorkOrderStatusHistory | Records the status history of work orders for audit and tracking purposes. |
| WorkOrdersWorkOrderLotNumber | Manages product lots linked to work orders, enabling detailed lot tracking and traceability. |
| WorkOrdersWorkOrderSerialNumber | Manages serial numbers for assemblies referenced by work orders, ensuring traceability and quality control. |
| WorkOrdersWorkOrderReservation | Handles demand reservations for work order output, ensuring proper allocation and fulfillment. |
| WorkOrdersWorkOrderExceptionCount | Tracks the count of exceptions for work orders, supporting issue identification and resolution. |
| ProcessWorkOrders | Manages detailed instructions for manufacturing processes, including outputs, inputs, and resources. |
| ProcessWorkOrdersOperation | Handles operations for processing manufacturing work orders, tracking resources and outputs. |
| ProcessWorkOrdersProcessWorkOrderMaterial | Tracks and manages materials consumed during operations to process work orders, ensuring accurate material planning. |
| ProcessWorkOrdersProcessWorkOrderOutput | Oversees the outputs generated by operations within a process work order, supporting production tracking. |
| ProductionResources | Manages production resources such as labor, equipment, and tools within a manufacturing plant, enabling efficient resource allocation. |
| ProductionResourcesEquipmentInstance | Tracks individual instances of equipment resources, supporting detailed equipment management. |
| ProductionResourcesLaborInstance | Manages individual instances of labor resources, facilitating labor allocation and tracking. |
| WorkCenters | Manages work centers within work areas, tracking resources and capacities for efficient production planning. |
| WorkDefinitionNames | Defines methods for manufacturing products through work definitions, enabling standardized production planning. |
| OperationStartStops | Tracks start and stop times for work order operations, including assembly serials. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including midpoint rescheduling for work orders and resequencing operations.