MCP Server for Oracle Fusion Cloud SCM

Build 25.0.9440

WorkCentersWorkCenterResourceWorkCenterResourceShift

Manages shifts assigned to work center resources, streamlining resource scheduling.

Columns

Name Type Description
WorkCentersWorkCenterId [KEY] Long The unique identifier linking the work center resource shift to its associated work center. This identifier ensures that shift schedules are accurately tied to the correct work center, supporting proper resource management and production planning.
WorkcenterresourceResourceId [KEY] Long The unique identifier linking the resource shift to the specific work center resource. This identifier ensures that shift data is correctly tied to the resource for accurate scheduling and capacity planning.
WorkcenterresourceWorkCenterId [KEY] Long The unique identifier linking the work center resource to the work center. This identifier ensures that resources are aligned with the correct work centers for operational consistency.
WorkCenterId [KEY] Long The unique identifier for the work center associated with the resource shift. This identifier ensures that shift schedules are properly assigned to the correct work center.
PlantCalendarId Long The unique identifier for the plant calendar that governs the resource shift. This identifier ensures that shifts are aligned with the operational calendar of the plant, supporting global production schedules.
ShiftId [KEY] Long The unique identifier for the specific shift. This identifier ensures traceability and helps distinguish between multiple shifts assigned to a resource or work center.
ShiftName String The name of the shift assigned to the work center resource. This name provides a user-friendly label for identifying and managing shifts in reports and scheduling interfaces.
StartTime String The start time of the shift for the work center resource. This value specifies when the shift begins, ensuring precise alignment with production schedules.
Duration String The duration of the shift, specifying the total time the resource is available during the shift. This field supports capacity planning and ensures accurate scheduling.
AssignedUnits Decimal The number of units (for example, labor hours or machine hours) assigned to the work center resource for this shift. This number is critical for balancing workloads and optimizing resource use.
ChangedDate Date The date when changes were last made to the work center resource shift configuration or schedule. This value ensures traceability and provides an audit trail for modifications.
Finder String A utility field used for advanced search and filtering of work center resource shift records. This field helps users quickly locate specific records based on attributes like shift, resource, or work center.
ResourceId Long The unique identifier for the resource associated with the work center shift. This identifier ties shifts to specific resources, ensuring accurate resource scheduling and allocation.
SubinventoryName String The name of the subinventory associated with the work center resource. This name identifies where materials or components required for the resource are stored, enabling efficient material flow and resource use.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440