SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount

The Exceptions for Operation Resources resource gets the count of exceptions that occurred during the operation.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkorderoperationWorkOrderOperationId [KEY] Long WorkorderoperationWorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkorderoperationresourceWorkOrderOperationResourceId [KEY] Long WorkorderoperationresourceWorkOrderOperationResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkOrderResourceExceptionCount Long WorkOrderResourceExceptionCount of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
ResourceId [KEY] Long ResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkOrderOperationId [KEY] Long WorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
DueDays Int DueDays of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
Finder String Finder of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
ItemNumber String ItemNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
SerialNumber String SerialNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
Tolerance Int Tolerance of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060