Power BI Connector for Oracle Fusion Cloud SCM

Build 25.0.9539

ProcessWorkOrdersOperationMaterialMaterialExceptionCount

ProcessWorkOrdersOperationMaterialMaterialExceptionCount

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long Parent work order identifier (references process work order).
OperationWorkOrderOperationId [KEY] Long Parent operation identifier for the work order.
MaterialWorkOrderOperationMaterialId [KEY] Long Identifier of the material record within the operation (parent).
WorkOrderMaterialExceptionCount Long Count of material exceptions for the work order.
WorkOrderOperationMaterialId [KEY] Long Identifier of the work order operation material.
BackToBackFlag String Indicates whether the work order is back-to-back.
ContractMfgFlag String Flag indicating contract manufacturing status.
DueDays Int Number of days until (or past) the due date for the work order.
Finder String Finder identifier used to select specific finder logic or view.
FirmPlannedFlag String Flag indicating whether the work order is firm planned.
InventoryItemId Long Identifier of the inventory item associated with the work order or material.
ItemNumber String Item number or SKU.
LastUpdateDate Datetime Date/time when this record was last updated (UTC).
MaterialItemId Long Identifier of the material item used in the operation.
OrganizationId Long Identifier of the organization responsible for the work order.
PlannedCompletionDate Datetime Planned completion date/time for the work order (UTC).
PlannedStartDate Datetime Planned start date/time for the work order (UTC).
ProductSerialId Long Identifier for the product serial number associated with the work order.
ResourceId Long Identifier of the resource assigned to the operation/work order.
SerialNumber String Serial number of the product or component.
SourceHeaderReferenceId Long Reference identifier for the source header associated with this record.
SourceHeaderRefId Long Reference identifier for the source header (alternate field).
SourceLineReferenceId Long Reference identifier for the source line associated with this record.
SourceLineRefId Long Reference identifier for the source line (alternate field).
SourceSystemId Long Identifier of the source system that provided this record.
Tolerance Int Tolerance value for the work order/material (units depend on context).
WoProjectNumber String Project number associated with the work order.
WorkAreaId Long Identifier of the work area where the operation is scheduled.
WorkCenterId Long Identifier of the work center where the operation will be performed.
WorkOrderId Long Primary identifier of the work order.
WorkOrderNumber String Human-readable work order number/code.
WorkOrderStatusId Long Identifier representing the current status of the work order.
WoTaskNumber String Task number within the work order (if applicable).

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