ADO.NET Provider for Oracle Fusion Cloud SCM

Build 25.0.9539

ProductionCalendarShiftExceptionsresourceAvailabilityOverrides

ProductionCalendarShiftExceptionsresourceAvailabilityOverrides

Columns

Name Type Description
ProductionCalendarShiftExceptionsPlantShiftExceptionId [KEY] Long Value that uniquely identifies the shift exception in the production calendar of a plant. The application generates this value when it creates the exception.
WorkCenterResourceExceptionId Long Value that uniquely identifies the work center resource exception in the production calendar of a plant. The application generates this value when it creates the exception.
WorkCenterResourceExceptionDetailId [KEY] Long Value that uniquely identifies the resource availability override. The application generates this value when it creates the exception for the resource.
PlantShiftExceptionId Long Value that uniquely identifies the shift exception in the production calendar of a plant. The application generates this value when it creates the exception.
ResourceId Long Value that uniquely identifies the resource being updated. This value is required.
ResourceName String Name that uniquely identifies the resource. It's used if the ResourceId isn't provided in the request.
WorkCenterId Long Value that uniquely identifies the work center associated with the resource. This value is required.
WorkCenterCode String User-supplied value that uniquely identifies the work center associated with the resource. It's used if the WorkCenterId isn't provided in the request.
WorkCenterName String Name that uniquely identifies the work center. It's used if the WorkCenterCode isn't provided in the request.
DefaultAvailability Int Value of the resource availability.
AvailabilityOverride Decimal Value of the override quantity. This replaces the default units available for a given resource for the time interval defined by the exception. This value is required.
ExceptionStartTime String Time when the work center resource exception starts. This value is required. It must be formatted as HH:MM AM|PM.
ExceptionStartTimeInMs Long Time in microseconds from midnight when the work center resource exception starts.
ExceptionDuration Int Duration in Hours for the work center resource exception. This value is required.
ExceptionEndTime String Time when the work center resource exception ends. It's derived from the start time and duration and isn't entered.
ExceptionEndTimeInMs Long Time in microseconds from midnight when the work center resource exception ends.
LastUpdateDate Datetime Date and time when the user most recently updated the record.
CreatedBy String User who created the record.
CreationDate Datetime Date and time when the user created the record.
LastUpdatedBy String User who most recently updated the record.
Finder String A system-defined query or lookup used to retrieve the work center resource exception in the production calendar of a plant.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539