Manufacturing
In the Manufacturing data model, the add-in 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 add-in.
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.