ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkCentersWorkCenterResource

Tracks resources allocated to work centers, supporting detailed resource planning and allocation.

Columns

Name Type Description
WorkCentersWorkCenterId [KEY] Long The unique identifier that links the work center resource to its associated work center. This identifier ensures that all resources are properly mapped to the correct work center for accurate resource management and production planning.
ResourceId [KEY] Long The primary key that uniquely identifies the work center resource. This system-generated key ensures that each resource is distinct and traceable within the work center structure.
ResourceName String The name assigned to the work center resource. This name provides a user-friendly label to help identify the resource in reports, configurations, and operational workflows.
ResourceDescription String A detailed description of the work center resource, explaining its purpose, capabilities, or role within the production process. This description helps users understand how the resource contributes to operational workflows.
ResourceCode String A short code or abbreviation assigned to the work center resource. This code simplifies referencing and managing resources in system interfaces and reports.
ResourceType String Specifies the type of resource (for example, 'Labor,' 'Machine,' or 'Tool'). This categorization supports effective resource allocation, scheduling, and reporting based on resource roles.
WorkCenterId [KEY] Long The unique identifier for the work center associated with the resource. This linkage ensures that resources are correctly aligned with the work centers they serve.
ResourceQuantity Decimal The number of resources assigned to the work center. This field supports capacity planning by specifying how many of the resource type are available within the work center.
Available24HoursFlag Bool Indicates whether the work center resource is available 24 hours a day. If the value is 'true', the resource is continuously available. If the value is 'false', the resource is available only during specific shifts assigned to the work center resource. This field is critical for shift-based resource scheduling and availability planning.
CheckCtpFlag Bool Indicates whether the capacity of this work center resource is considered during Oracle Global Order Promising Cloud’s capable-to-promise (CTP) checks. If the value is 'true', the resource’s capacity is factored into CTP calculations. If the value is 'false', the resource’s capacity is excluded from these checks, enabling more flexible planning for non-critical resources.
UtilizationPercentage Decimal The percentage of time that the resource is available to perform tasks relative to its total scheduled time. This metric helps measure resource availability and assists in capacity planning.
EfficiencyPercentage Decimal The percentage of time that the work center resource requires to complete a task compared to the standard or expected time. This metric evaluates resource performance and productivity, enabling optimization of work center operations.
ChangedDate Date The date when changes were last made to the work center resource’s configuration or attributes. This value ensures traceability and provides an audit trail for resource updates.
Finder String A utility field that enables advanced search and filtering capabilities for work center resources. This field enhances usability by allowing users to locate specific resources quickly based on various attributes.
SubinventoryName String The name of the subinventory associated with the work center resource. This name identifies where materials or components required by the resource are stored, supporting inventory integration and operational efficiency.

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