Excel Add-In for Oracle Fusion Cloud SCM

Build 26.0.9770

DemandAndSupplyPlansworkDefinitionVersions

Lists the work definitions and their versions used in the demand and supply plan.

Columns

Name Type SupportedFinders Description
DemandAndSupplyPlansPlanId [KEY] Long Value that uniquely identifies the plan.
CreatedBy String User who created the work definition version.
CreationDate Datetime Date and time when the user created the work definition version.
LastUpdateDate Datetime Date when the user most recently updated the work definition version.
LastUpdateLogin String Session login associated with the user who updated the work definition version.
LastUpdatedBy String User who most recently updated the work definition version.
ItemId [KEY] Long Value that uniquely identifies the assembly item.
ItemName String Name of the item associated with the work definition.
OrganizationId [KEY] Long Value that uniquely identifies the organization.
Organization String The organization code associated with the work definition.
StartDate Date Date when the work definition version started.
EndDate Date The end date of the work definition version.
MaximumBatchQuantity Decimal The maximum batch quantity that can be made using the work definition.
MinimumBatchQuantity Decimal The minimum batch quantity that can be made using the work definition.
PartitionKey Long The partition key associated with the work definition version.
PlanId [KEY] Long PrimaryKey Value that uniquely identifies the plan.
RoutingSequenceId [KEY] Long Value that uniquely identifies the routing sequence.
Version String Value that uniquely identifies the version of the work definition.
WorkDefinitionName String Name of the work definition.
WorkDefinitionDescription String Description of the work definition for an item.
ProductionPriority Int Value that identifies the work definition's priority. 1 is the highest priority and is referred to as the primary work definition. Work definitions with a priority greater than 1 are considered alternate work definitions.
WorkDefinitionCode String Code that uniquely identifies the work definition used for a make order.
WorkMethodCode Int Value that uniquely identifies the work method for which this work definition is applicable.
WorkMethod String Name of the work method.
EnableParallelOperation Int Contains one of the following values: 0 or 1. If 0, then no parallel operations exist. If 1, then parallel operations exist. The default value is 0.
ParallelOperationValue String Contains one of the following values: true or false. If true, then parallel operations exist for the work definition. If false, then no parallel operations exist for the work definition.
Notes Int Indicates whether an associated note exists. Contains one of the following values: 0 or 1. If 0, then there are no associated notes. If 1, then there is at least one associated note.
Finder String The name of the finder method used to search and filter records.

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