Get all plan inputs
get
/fscmRestApi/resources/11.13.18.05/planInputs
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables- PrimaryKey Find plan inputs according to the plan inputs identifier.
Finder Variables- PlanInputId; integer; Value that uniquely identifies the plan inputs.
- PrimaryKey Find plan inputs according to the plan inputs identifier.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- PlanInputId; integer; Value that uniquely identifies the plan inputs. Plan inputs always uses -1 as the identifier.
- PlanInputName; string; Name associated with the plan inputs.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : planInputs
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-item-response
Type:
Show Source
object-
BillOfResources: array
Bill of Resources
Title:
Bill of ResourcesThe Bill of Resources resource manages the collected bill of resources used as input for the Oracle Supply Chain Planning Cloud solution. -
ComponentItems: array
Component Items
Title:
Component ItemsItem structure components that are part of a supply plan. -
Items: array
Items
Title:
ItemsItem structure components that are part of a supply plan. -
ItemSubinventories: array
Item Subinventories
Title:
Item SubinventoriesA collected item subinventory used as input for Oracle Fusion Cloud Supply Chain Planning. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Operations: array
Operations
Title:
OperationsOperations needed to make an item that are part of a supply plan. -
OutputItems: array
Output Items
Title:
Output ItemsOutput items that are produced at an operation of a process work definition of a supply plan. -
PlanInputId: integer
Read Only:
trueValue that uniquely identifies the plan inputs. Plan inputs always uses -1 as the identifier. -
PlanInputName: string
Read Only:
trueMaximum Length:10Name associated with the plan inputs. -
PlanningDemands: array
Planning Demands
Title:
Planning DemandsThe Planning Demands resource manages the collected demand orders and forecasts used as input for the Oracle Supply Chain Planning Cloud solution. -
PlanningSupplies: array
Planning Supplies
Title:
Planning SuppliesThe Planning Supplies resource manages the collected supply orders such as work orders and purchase orders used as input for the Oracle Supply Chain Planning Cloud solution. -
ResourceRequirements: array
Resource Requirements
Title:
Resource RequirementsThe resource requirements for resources generated by planning. -
Resources: array
Resources
Title:
ResourcesThe Bill of Resources resource manages the collected bill of resources used as input for the Oracle Supply Chain Planning Cloud solution. -
SupplierCapacities: array
Supplier Capacities
Title:
Supplier CapacitiesThe Supplier Capacities resource manages how much of an item can be purchased from a supplier during a specified time period. -
SupplierItems: array
Supplier Items
Title:
Supplier ItemsThe Supplier Items resource manages which items are purchased from which suppliers.
Nested Schema : Bill of Resources
Type:
arrayTitle:
Bill of ResourcesThe Bill of Resources resource manages the collected bill of resources used as input for the Oracle Supply Chain Planning Cloud solution.
Show Source
Nested Schema : Component Items
Type:
arrayTitle:
Component ItemsItem structure components that are part of a supply plan.
Show Source
Nested Schema : Items
Type:
arrayTitle:
ItemsItem structure components that are part of a supply plan.
Show Source
Nested Schema : Item Subinventories
Type:
arrayTitle:
Item SubinventoriesA collected item subinventory used as input for Oracle Fusion Cloud Supply Chain Planning.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Operations
Type:
arrayTitle:
OperationsOperations needed to make an item that are part of a supply plan.
Show Source
Nested Schema : Output Items
Type:
arrayTitle:
Output ItemsOutput items that are produced at an operation of a process work definition of a supply plan.
Show Source
Nested Schema : Planning Demands
Type:
arrayTitle:
Planning DemandsThe Planning Demands resource manages the collected demand orders and forecasts used as input for the Oracle Supply Chain Planning Cloud solution.
Show Source
Nested Schema : Planning Supplies
Type:
arrayTitle:
Planning SuppliesThe Planning Supplies resource manages the collected supply orders such as work orders and purchase orders used as input for the Oracle Supply Chain Planning Cloud solution.
Show Source
Nested Schema : Resource Requirements
Type:
arrayTitle:
Resource RequirementsThe resource requirements for resources generated by planning.
Show Source
Nested Schema : Resources
Type:
arrayTitle:
ResourcesThe Bill of Resources resource manages the collected bill of resources used as input for the Oracle Supply Chain Planning Cloud solution.
Show Source
Nested Schema : Supplier Capacities
Type:
arrayTitle:
Supplier CapacitiesThe Supplier Capacities resource manages how much of an item can be purchased from a supplier during a specified time period.
Show Source
Nested Schema : Supplier Items
Type:
arrayTitle:
Supplier ItemsThe Supplier Items resource manages which items are purchased from which suppliers.
Show Source
Nested Schema : planInputs-BillOfResources-item-response
Type:
Show Source
object-
AlternateResources: array
Alternate Resources
Title:
Alternate ResourcesThe Alternate Resources resource manages the collected alternate resources in the bill of resources that are used as input for the planning engine. -
AssemblyDescription: string
Read Only:
trueMaximum Length:240Description of the assembly item. -
AssemblyItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the assembly item. -
AssemblyItemLevel: string
Read Only:
trueMaximum Length:8Data load level of the item being produced. Valid values are Item and Category. -
AssemblyItemName: string
Read Only:
trueMaximum Length:300Name of the assembly item. -
AssemblyQuantity: number
Read Only:
trueQuantity of the item being produced. -
AssemblyUOM: string
Read Only:
trueMaximum Length:4000Planning unit of measure of the assembly item. -
BasisType: number
Read Only:
trueValue that indicates whether the component item or resource usage quantity in an assembly item's bill of resources is fixed or variable. Contains one of the following values: 1 or 2. If 1, then usage quantity is variable. If 2, then usage quantity is fixed. The default value is 1. -
BorId: integer
(int64)
Read Only:
trueValue that uniquely identifies the bill of resources. -
CatalogId: integer
(int64)
Read Only:
trueValue that uniquely identifies the catalog. -
CatalogName: string
Read Only:
trueMaximum Length:30Category set or name of the catalog to which an item belongs. If Assembly Item Level is set to Category, then this value is required. -
CategoryId: integer
(int64)
Read Only:
trueValue that uniquely identifies the category. -
CategoryName: string
Read Only:
trueMaximum Length:250Name of the category to which an item belongs. If Assembly Item Level is set to Category, then this value is required. -
CategoryUOM: string
Read Only:
trueMaximum Length:3Planning unit of measure of the category. -
ComponentDescription: string
Read Only:
trueMaximum Length:240Description of the component item. -
ComponentItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the component item. -
ComponentItemName: string
Read Only:
trueMaximum Length:300Name of the component item. -
ComponentUOM: string
Read Only:
trueMaximum Length:4000Planning unit of measure of the component item. -
ComponentUsageQuantity: number
Read Only:
trueQuantity of the item being consumed. -
ConsumptionType: string
Read Only:
trueMaximum Length:8Type of consumption. This attribute indicates whether an item or resource is being consumed. Valid values are Item and Resource. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the bill of resources. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the bill of resources. -
EffectiveEndDate: string
(date)
Read Only:
trueDate when the component item or resource is no longer available. -
EffectiveStartDate: string
(date)
Read Only:
trueDate when the component item or resource is available. -
FindNumber: integer
Read Only:
trueNumber that uniquely identifies a component when the same component occurs multiple times at the same level in a bill of material. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the bill of resources. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the bill of resources. -
LeadTimeOffsetInDays: number
Read Only:
trueValue that indicates the number of days for which the planning engine offsets the consumption of a component or resource. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OptionDependent: integer
(int32)
Read Only:
trueValue that indicates whether the resource in an assembly item's bill of resources is used in operations that are dependent on the choice of one or multiple optional components. Contains one of the following values: 1 or 2. If 1, then the resource is option dependent. If 2, then the resource isn't option dependent. This attribute doesn't have a default value. -
OptionDependentDetails: array
Option Dependent Resource Details
Title:
Option Dependent Resource DetailsIn the bill of resources, the Option Dependent Resource Details resource manages the details for resources used in operations that are dependent on the choice of one or multiple optional components. The details are used as input for the planning engine. -
Organization: string
Read Only:
trueMaximum Length:4000Abbreviation that identifies the organization associated with the item. -
OrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the organization. -
ResourceCode: string
Read Only:
trueMaximum Length:40Abbreviation that identifies the resource. -
ResourceId: integer
(int64)
Read Only:
trueValue that uniquely identifies the resource. -
ResourceUOM: string
Read Only:
trueMaximum Length:4000Unit of measure associated with the resource. -
ResourceUsageQuantity: number
Read Only:
trueQuantity of the resource being consumed. -
SourceOrganization: string
Read Only:
trueMaximum Length:4000Name of the organization where the component or resource is defined. -
SourceOrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the source organization. -
SubstituteComponents: array
Substitute Components
Title:
Substitute ComponentsThe Substitute Components resource manages the collected substitute component, in the bill of resources, which is used as input for the planning engine. -
WorkCenterCode: string
Read Only:
trueMaximum Length:120Abbreviation that identifies the work center. -
WorkCenterId: integer
(int64)
Read Only:
trueValue that uniquely identifies the work center.
Nested Schema : Alternate Resources
Type:
arrayTitle:
Alternate ResourcesThe Alternate Resources resource manages the collected alternate resources in the bill of resources that are used as input for the planning engine.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Option Dependent Resource Details
Type:
arrayTitle:
Option Dependent Resource DetailsIn the bill of resources, the Option Dependent Resource Details resource manages the details for resources used in operations that are dependent on the choice of one or multiple optional components. The details are used as input for the planning engine.
Show Source
Nested Schema : Substitute Components
Type:
arrayTitle:
Substitute ComponentsThe Substitute Components resource manages the collected substitute component, in the bill of resources, which is used as input for the planning engine.
Show Source
Nested Schema : planInputs-BillOfResources-AlternateResources-item-response
Type:
Show Source
object-
AlternateResourceCode: string
Read Only:
trueMaximum Length:40Abbreviation that identifies the alternate resource. -
AlternateResourceId: integer
(int64)
Read Only:
trueValue that uniquely identifies the alternate resource. -
AlternateResourcePriority: number
Read Only:
trueValue that indicates the priority associated with the resource to use as the alternate resource. -
AlternateResourceQuantity: number
Read Only:
trueValue that indicates the quantity of the alternate resource being consumed. -
AlternateResourceUOM: string
Read Only:
trueMaximum Length:4000Unit of measure associated with the alternate resource. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the alternate resources in the bill of resources. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the alternate resources in the bill of resources. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the alternate resources in the bill of resources. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the alternate resources in the bill of resources. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
WorkCenterCode: string
Read Only:
trueMaximum Length:120Abbreviation that identifies the work center to which the alternate resource belongs to in the bill of resources. -
WorkCenterId: integer
(int64)
Read Only:
trueValue that uniquely identifies the work center to which the alternate resource belongs to in bill of resources.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : planInputs-BillOfResources-OptionDependentDetails-item-response
Type:
Show Source
object-
AssemblyItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the assembly item. -
AssemblyItemName: string
Read Only:
trueMaximum Length:255Name of the assembly item. -
BorId: integer
Read Only:
trueValue that uniquely identifies the bill of resources. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OperationSequenceNumber: number
Read Only:
trueNumber that indicates the order for operations that are dependent on the choice of one or multiple optional components in the bill of resources. -
OptionId: integer
(int64)
Read Only:
trueValue that uniquely identifies the optional component for the option dependent resource in the bill of resources. -
OptionMemberId: integer
(int64)
Read Only:
trueValue that uniquely identifies the end option item or class in the optional component lineage in the bill of resources. -
OptionMemberLineageNames: string
Read Only:
trueMaximum Length:4000Ordered list of names for the parent option items or classes of an optional component in the bill of resources. -
OptionMemberName: string
Read Only:
trueMaximum Length:4000Name of the end option item or class in the optional component lineage in the bill of resources. -
OptionMemberType: string
Read Only:
trueMaximum Length:4000Value that indicates whether the optional component in the bill of resources is an item or class. Contains one of the following values: 0 or 1. If 0, then the component is an option item. If 1, then the component is an option class. This attribute doesn't have a default value. -
OptionMemberUsageQuantity: number
Read Only:
trueValue that indicates the quantity of the optional component being consumed in the bill of resources. -
Organization: string
Read Only:
trueMaximum Length:255Abbreviation that identifies the organization associated with the item. -
OrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the organization. -
ResourceCode: string
Read Only:
trueMaximum Length:255Abbreviation that identifies the resource. -
ResourceId: integer
(int64)
Read Only:
trueValue that uniquely identifies the resource. -
ResourceUsageQuantity: number
Read Only:
trueQuantity of the resource being consumed.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-BillOfResources-SubstituteComponents-item-response
Type:
Show Source
object-
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the substitute components in the bill of resources. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the substitute components in the bill of resources. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the substitute components in the bill of resources. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the substitute components in the bill of resources. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
SubstituteCompItemPriority: number
Read Only:
trueValue that indicates the priority associated with the component item to use as the substitute component in the bill of resources. -
SubstituteCompItemQty: number
Read Only:
trueValue that indicates the quantity of the substitute component being consumed. -
SubstituteCompItemUOM: string
Read Only:
trueMaximum Length:4000Unit of measure associated with the substitute component. -
SubstituteComponentItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the component item to use as the substitute component in the bill of resources. -
SubstituteComponentItemName: string
Read Only:
trueMaximum Length:300Name of the component item to use as the substitute component in the bill of resources.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-ComponentItems-item-response
Type:
Show Source
object-
AssemblyItem: string
Title:
Assembly ItemMaximum Length:250Name of the assembly item. -
AssemblyItemDescription: string
Title:
Assembly Item DescriptionMaximum Length:240Description of the assembly item. -
AssemblyItemId: integer
Unique identifier of the assembly item.
-
AssemblyItemUOM: string
Title:
Assembly Item UOMMaximum Length:400Unit of measure of the assembly item. -
AssemblyItemUOMCode: string
Title:
Assembly Item UOMMaximum Length:3Unit of measure code of the assembly item. -
AssemblyQuantity: number
Title:
Assembly QuantityQuantity of the assembly item. -
Basis: string
Title:
BasisRead Only:trueMaximum Length:80Identifies whether component item usage is based on the quantity of an item produced or for the entire lot. -
BillSequenceId: integer
Value that uniquely identifies the sequence in which a component is used within an operation.
-
BillSequenceIdSecondary: integer
Value that uniquely identifies the sequence in which a component is used within an operation.
-
ChangeIndicatorFlag: boolean
Read Only:
trueValue that identifies whether the component item has been modified. Valid values are true or false. If true, then the row is new or modified. If false, then the row isn't new or modified. -
ComponentItem: string
Title:
Component ItemMaximum Length:250Name of the component item being consumed. -
ComponentItemDescription: string
Title:
Component DescriptionMaximum Length:240Description of the component item being consumed. -
ComponentItemEffectiveEndDate: string
(date)
Title:
Component Item Effective End DateStart date of effectivity for this component. -
ComponentItemEffectiveStartDate: string
(date)
Title:
Component Item Effective Start DateEnd date of effectivity for this component. -
ComponentItemId: integer
Unique identifier of the component item.
-
ComponentItemUOM: string
Title:
Component UOMMaximum Length:400Unit of measure of the component item. -
ComponentItemUOMCode: string
Maximum Length:
3Unit of measure code of the component item. -
ComponentSequenceId: integer
Value that uniquely identifies the component on the source application instance.
-
ComponentUsageQuantity: number
Title:
Usage QuantityQuantity of the component to build one unit of item based on the component's primary UOM. -
ComponentYield: number
Title:
Component YieldFactor used to multiply component quantity with to obtain the total quantity used of a component that actually becomes part of an assembly. -
DataSecurityEditAllowed: string
Read Only:
trueMaximum Length:255Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
EnforceIntegerRequirement: string
Title:
Enforce Integer RequirementRead Only:trueMaximum Length:80Specifies whether the result of a component's calculated quantity or inverse quantity is required to be an integer. Valid values for this option are None, Round up, and Round down. -
FindNumber: integer
Title:
Find NumberNumber used to locate a specific instance of an item in a structure. This number enables users to define multiple occurrences of the same component for an assembly in its item structure. -
ItemSequence: integer
Title:
Item SequenceNumber that indicates the sequence for a component item for a work order operation. -
ItemStructureName: string
Title:
Item Structure NameMaximum Length:80Name for the categorization of an item structure, such as a design structure or manufacturing bill of material, that controls the usage and behavior of the structure. -
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueDate when the component item was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64Name of the user who last updated the component item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NewPlanId: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
NewPlanIdSecondary: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
NotesCount: integer
Title:
NotesRead Only:trueNumber of notes associated with this component item. -
OperationSequenceNumber: integer
Title:
Operation Sequence NumberRead Only:trueOrder in which the operation occurs. -
Organization: string
Read Only:
trueMaximum Length:255Name of the organization. -
OrganizationCode: string
Title:
OrganizationMaximum Length:49Organization code for the assembly item. -
OrganizationId: integer
Unique identifier of the organization.
-
OrganizationIdSecondary: integer
Unique identifier of the organization.
-
PlanId: integer
Value that uniquely identifies the supply plan associated with the component item
-
PlanIdSecondary: integer
Value that uniquely identifies the supply plan associated with the component item
-
PlanningPercentage: number
Title:
Planning PercentagePlanning factor for this component as a percentage. -
Primary: string
Title:
PrimaryRead Only:trueMaximum Length:80Indicates if the component item is the primary item structure. -
SimulationSetId: integer
(int64)
Value that uniquely identifies the simulation set.
-
SimulationSetIdSecondary: integer
(int64)
Value that uniquely identifies the simulation set.
-
SubstituteItems: array
Substitute Items
Title:
Substitute ItemsComponent items substitutes that are part of the item structures of a supply plan. -
SupplyType: string
Title:
Supply TypeMaximum Length:4000Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE. -
WorkDefinitionName: string
Title:
Work DefinitionMaximum Length:300Name of the work definition associated with this item structure.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Substitute Items
Type:
arrayTitle:
Substitute ItemsComponent items substitutes that are part of the item structures of a supply plan.
Show Source
Nested Schema : planInputs-ComponentItems-SubstituteItems-item-response
Type:
Show Source
object-
AssemblyItem: string
Title:
Assembly ItemRead Only:trueName of the assembly item. -
AssemblyItemId: string
Read Only:
trueUnique identifier of the assembly item. -
BillSequenceId: integer
(int64)
Value that uniquely identifies the sequence in which a component is used within an operation.
-
ChangeIndicatorFlag: boolean
Read Only:
trueValue that identifies whether the substitute component has been modified. Valid values are true or false. If true, then the row is new or modified. If false, then the row isn't new or modified. -
ComponentItem: string
Title:
Component ItemRead Only:trueName of the component item being consumed. -
ComponentItemId: string
Read Only:
trueUnique identifier of the component item. -
ComponentSequenceId: integer
(int64)
Value that uniquely identifies the component on the source application instance.
-
EnforceIntegerRequirement: string
Title:
Enforce Integer RequirementRead Only:trueMaximum Length:80Specifies whether the result of a component's calculated quantity or inverse quantity is required to be an integer. Valid values for this option are None, Round up, and Round down. -
FindNumber: string
Title:
Find NumberRead Only:trueNumber used to locate a specific instance of an item in a structure. This number enables users to define multiple occurrences of the same component for an assembly in its item structure. -
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueDate when the component item was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64Name of the user who last updated the component item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NewPlanId: integer
Value that uniquely identifies the new plan that the duplication process creates.
-
OperationSequenceNumber: string
Title:
Operation Sequence NumberRead Only:trueOrder in which the operation occurs. -
Organization: string
Read Only:
trueName of the organization. -
OrganizationCode: string
Title:
OrganizationRead Only:trueOrganization code for the assembly item. -
OrganizationId: integer
(int64)
Unique identifier of the organization.
-
PlanId: integer
Value that uniquely identifies the supply plan associated with the component item
-
SimulationSetId: integer
Value that uniquely identifies the simulation set.
-
SubstituteComponent: string
Title:
Substitute ComponentMaximum Length:250Name of the substitute component. -
SubstituteComponentDescription: string
Title:
Substitute Component DescriptionMaximum Length:240Description of the substitute component. -
SubstituteComponentId: integer
(int64)
Unique identifier of the substitute component item.
-
SubstituteComponentPriority: integer
Title:
Substitute Component PriorityA numeric value indicating the priority of the object. -
SubstituteComponentQuantity: number
Title:
Substitute Component QuantityQuantity needed when using a substitute item in place of the original component item. -
SubstituteComponentUOM: string
Title:
Substitute Component UOMMaximum Length:4000Unit of measure of the substitute component item. -
SubstituteComponentUOMCode: string
Maximum Length:
3Unit of measure code of the substitute component item. -
SubstituteSequenceId: integer
Value that uniquely identifies the substitute component on the source application instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-Items-item-response
Type:
Show Source
object-
ABCClass: string
Read Only:
trueMaximum Length:40Code assigned to the item for classification purposes. Items are divided into categories called ABC classes, such as A, B, and C, according to a criterion such as revenue generation, turnover, or value. -
AcceptableEarlyDays: integer
Read Only:
trueNumber of days before which the planning process won't reschedule the sales order. For example, if the due date on the original sales order is June 10, and if the Acceptable Early Days is 3, and if the new due date is less than or equal to June 13 then the planning process won't suggest rescheduling. -
AlternateUOM: string
Read Only:
trueMaximum Length:4000Secondary unit of measure for the item, represented as an alternate unit of measure in planning. -
AnnualCarryingCostPercentage: number
Read Only:
truePercent of unit cost that represents the internal cost to stock one unit for one year. -
ATPComponents: string
Read Only:
trueMaximum Length:1Value that indicates whether to enable available-to-promise functionality in Oracle Fusion Cloud Global Order Promising when planning for this item. Valid values are 1 and 2. If 1, then available-to-promise functionality is enabled. If 2, then available-to-promise functionality isn't enabled. -
ATPComponentsMeaning: string
Read Only:
trueMaximum Length:4000Indicates whether to include additional components in the item structure for assemble-to-order and pick-to-order items when performing available-to-promise checking. Valid values are Yes and No. -
AutocreatedConfiguration: integer
(int32)
Read Only:
trueValue that indicates whether the item is a configured item or not. Valid values are: 1 or 2. If 1, then item is a configured item. If 2, then not. -
AutocreatedConfigurationMeaning: string
Maximum Length:
4000Value that indicates whether the item is configured or not. Valid values are: Yes or No. If Yes, then the item is configured. If No, then the item isn't configured. -
AverageInterarrivalTime: number
Read Only:
trueAverage time, expressed in days, between intervals. -
BackToBack: string
Maximum Length:
4000Value that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: Yes or No. If Yes, then the item is enabled for back-to-back ordering. If No, then the item isn't enabled for back-to-back ordering. -
BackToBackEnabled: integer
Read Only:
trueValue that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: 1 or 2. If 1, then item is enabled for back-to-back ordering. If 2, then not. -
BaseModel: string
Read Only:
trueMaximum Length:4000Value that uniquely identifies the model to use when creating an assemble-to-order configuration. -
BuildInWIP: string
Maximum Length:
4000Value that indicates whether work orders can be created or not. Valid values are Yes or No. If Yes, then work orders can be created. If No, then work orders can't be created. -
BuildInWIPOption: integer
Read Only:
trueContains one of the following values: 1 or 2. If 1, then work orders can be created. If No, then work orders can't be created. -
Buyer: string
Read Only:
trueMaximum Length:240Name of the buyer associated with the item. -
CalculateATPIndicator: integer
Read Only:
trueValue that indicates whether to enable available-to-promise functionality in Oracle Fusion Cloud Global Order Promising when planning for this item. Valid values are 1 and 2. If 1, then available-to-promise functionality is enabled. If 2, then available-to-promise functionality isn't enabled. -
CalculateATPMeaning: string
Maximum Length:
4000Value that indicates whether to enable the available-to-promise rule in Oracle Fusion Cloud Global Order Promising. Valid values are Yes or No. If Yes, then the available-to-promise rule is enabled. If No, then the available-to-promise rule isn't enabled. -
CatalogId: string
Read Only:
trueValue that uniquely identifies the catalog. -
Category: string
Title:
CategoryRead Only:trueMaximum Length:4000Category of the item in the exception. the category is derived from the default product hierarchy or any product hierarchy of the item associated in the plan's dimension catalog. -
CategoryDescription: string
Read Only:
trueMaximum Length:4000Description associated with a product category. -
CategoryId: integer
Read Only:
trueValue that uniquely identifies an item category. -
ConsiderInClearToBuild: string
Read Only:
trueMaximum Length:1Value that indicates whether to include this component item when calculating clear-to-build for an assembly item. Valid values are 1 or 2. If 1, then this component item is included. If 2, then it's not. -
ConsiderInClearToBuildMeaning: string
Maximum Length:
4000Value that indicates whether to include this component item when calculating clear to build for an assembly item. Valid values are Yes or No. If Yes, then this component item is included. If No, then this component item isn't included. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the item. -
CreateSupply: integer
Read Only:
trueValue that indicates whether planning creates planned orders for this item. Valid values are 1 or 2. If 1, then planned orders are created. If 2, then planned orders aren't created. -
CreateSupplyAfter: string
(date)
Read Only:
trueDate after which supplies can be created. This attribute is editable only when the CreateSupply attribute is set to 1. -
CreateSupplyMeaning: string
Maximum Length:
4000Value that indicates whether planning creates planned orders for this item. Valid values are Yes or No. If Yes, then planned orders are created. If No, then planned orders aren't created. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the supplier item. -
CriticalComponent: integer
Read Only:
trueValue that indicates whether the item is a critical component or not. Valid values are 1 or 2. If 1, then the item is a critical component. If 2, then the item isn't a critical component. -
CriticalComponentMeaning: string
Maximum Length:
4000Value that indicates whether the item is a critical component or not. Valid values are Yes or No. If Yes, then the item is a critical component. If No, then the item isn't a critical component. -
CumulativeManufacturingLT: number
Read Only:
trueNumber of days required to manufacture the item, including the adjusted, cumulative, and total lead time for the component that requires the longest time to assemble. -
Currency: string
Read Only:
trueMaximum Length:30Value that indicates the currency associated with the item's price and cost. -
DataSecurityEditAllowed: string
Read Only:
trueMaximum Length:255Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
DaysOfCover: number
Read Only:
trueNumber of days of cover for the item. Days of Cover is multiplied by the average demand to calculate the safety stock level. -
DaysOfCoverDemandPeriod: integer
Read Only:
truePeriod of time, specified as a number of days, used to determine the average gross demand when using the Days of Cover method to calculate safety stock. -
DemandTimeFenceCode: integer
Read Only:
trueAbbreviation that identifies the point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
DemandTimeFenceDate: string
(date)
Read Only:
trueDate before which forecast demand is ignored. -
DemandTimeFenceDays: integer
Read Only:
trueTime horizon, expressed in number of days, within which forecast demand is ignored. -
DemandTimeFenceType: string
Read Only:
trueMaximum Length:4000Value that identifies the point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
Description: string
Read Only:
trueMaximum Length:240Description of the item. -
DiscountPercentage: number
Read Only:
trueAverage discount for the item. -
EnforcePurchasingLeadTime: integer
(int32)
Read Only:
trueValue that indicates whether purchasing lead times are imposed as a hard constraint during constraint-based planning. Valid values are: 1 or 2. If 1, then purchasing lead times are enforced. If 2, then not. -
EnforcePurchasingLeadTimeMeaning: string
Maximum Length:
4000Value that indicates whether purchasing lead times are imposed as a hard constraint during constraint-based planning. Valid values are: Yes or No. If Yes, then purchasing lead times are enforced. If No, then purchasing lead times aren't enforced. -
ExcessHorizon: number
Read Only:
trueTime horizon, expressed in number of days, after which inventory is considered excess. -
FixedDaysOfSupply: number
Read Only:
trueNumber of days to use to modify the size and timing of each planned order quantity. -
FixedLeadTime: number
Read Only:
trueNumber of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time. -
FixedLotMultiplier: number
Read Only:
trueMultiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate. -
FixedOrderQuantity: number
Read Only:
trueQuantity to use to modify the size of each planned order quantity or each repetitive daily rate. -
ForecastControl: string
Read Only:
trueMaximum Length:4000Value that indicates how the forecast is exploded and consumed. This attribute isn't currently used. -
ForecastErrorType: string
Read Only:
trueMaximum Length:30Value that indicates how the quality of a forecast is measured. A list of accepted values is defined in the lookup type MSC_FORECAST_ERROR_TYPES. -
ForecastErrorTypeStr: string
Read Only:
trueMaximum Length:4000Meaning associated with the ForecastErrorType Code attribute. -
ForecastName: string
Read Only:
trueMaximum Length:4000Name of the forecast used for safety stock calculation. -
HardPeggingLevel: string
Read Only:
trueMaximum Length:25Value that identifies the type of pegging considered by the planning engine during the supply and demand netting process. A list of accepted values is defined in the lookup type ORA_MSC_HARD_PEGGING_LEVEL. -
HardPeggingLevelStr: string
Read Only:
trueMaximum Length:4000Meaning associated with the HardPeggingLevel attribute. -
IntermittentDemand: number
Read Only:
trueValue that indicates whether the demand for the item has an irregular frequency or not. Valid values are: 1 or 2. If 1, then demand for the item has an irregular frequency . If 2, then not. -
IntermittentDemandMeaning: string
Read Only:
trueMaximum Length:4000Indicates whether the demand has an irregular frequency. Valid values are Yes and No. -
InventoryItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the item. -
ItemCostUOM: string
Read Only:
trueMaximum Length:4000Unit of measure associated with an item's cost. -
ItemName: string
Read Only:
trueMaximum Length:255Name of the item. -
ItemStructureType: string
Read Only:
trueMaximum Length:4000Value that indicates the type of bill of material. A list of accepted values is defined in the lookup type ORA_MSC_BOM_ITEM_TYPE. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the item. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User most recently updated the item. -
LeadTimeLotSize: number
Read Only:
trueMultiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate. -
LifeCyclePhase: string
Read Only:
trueMaximum Length:120Name of lifecycle phase of the item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LotControl: string
Read Only:
trueMaximum Length:4000Meaning associated with the LotControlCode attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE. -
LotControlCode: integer
Read Only:
trueValue that identifies whether the item is lot controlled. Valid values are 1 and 2. If 1, then lot control isn't established for the item. If 2, then lot control is used to track inventory balances by the lot number. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE. -
LotExpirationControl: string
Read Only:
trueMaximum Length:4000Meaning associated with the LotsExpiration attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL. -
LotsExpiration: integer
(int64)
Read Only:
trueValue that identifies how lot expiration dates are calculated. Valid values are 1 and 2. If 1, then lots don't expire. If 2, then lot expiration is based on the number of shelf life days for the item. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL. -
MakeOrBuy: string
Read Only:
trueMaximum Length:4000Value that indicates whether the item is manufactured or purchased. Valid values are Make or Buy. If Make, then the item is manufactured. If Buy, then the item is purchased. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MAKE_BUY. -
MaximumOrderQuantity: number
Read Only:
trueMaximum order quantity of the item. -
MinimumOrderQuantity: number
Read Only:
trueMinimum order quantity of the item. -
NetSellingPrice: number
Selling price of an item after applying an average discount to the item's list price.
-
NotesIndicator: integer
Read Only:
trueCost associated with using the resource. -
ObsolescenceDate: string
(date)
Read Only:
trueDate when the item is obsolete. -
OrderCost: number
Read Only:
trueFixed costs that are associated with placing a sales order for the item. -
OrderModifierToStartQuantity: integer
Read Only:
trueValue that indicates whether order modifiers are applied to start quantity or not. Valid values are: 1 or 2. If 1, then order modifiers are applied to start quantity. If 2, then not. -
OrderModifierToStartQuantityMeaning: string
Read Only:
trueMaximum Length:4000Value that determines whether the order modifier for the item should be applied to the start quantity of the supply for the item. Valid values are Yes or No. -
Organization: string
Read Only:
trueMaximum Length:49Abbreviation that identifies the organization associated with the item. -
OrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the organization. -
PickComponents: integer
Read Only:
trueValue that indicates whether the item can be picked from finished goods inventory. Valid values are: 1 or 2. If 1, then the item can be picked from finished goods inventory. If 2, then not. -
PickComponentsMeaning: string
Maximum Length:
4000Value that indicates whether the item can be picked from the finished goods inventory. Valid values are: Yes or No. If Yes, then the item can be picked from the finished goods inventory. If No, then the item can't be picked from the finished goods inventory. -
PlannedSafetyStockType: integer
Read Only:
trueType of safety stock planning used to calculate safety stock for the item and organization combination. A list of accepted values is defined in the lookup type ORA_MSC_PLANNED_SS_TYPE. -
Planner: string
Read Only:
trueMaximum Length:10Abbreviation that identifies the planner responsible for the item. -
PlannerDescription: string
Read Only:
trueMaximum Length:4000Description of the planner responsible for the item. -
PlanningMethod: string
Read Only:
trueMaximum Length:4000Value that indicates the type of planning used for the item. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_CODE. -
PlanningMethodCode: integer
Read Only:
trueAbbreviation that indicates the type of planning used for the item. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_CODE. -
PlanningTimeFenceCode: integer
Read Only:
trueAbbreviation that identifies the point in time inside which the planning process won't schedule a supply order to be due. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
PlanningTimeFenceDate: string
(date)
Read Only:
trueDate before which orders aren't rescheduled. -
PlanningTimeFenceDays: integer
Read Only:
trueTime horizon, in number of days, in which supply orders aren't scheduled to be due. -
PlanningTimeFenceType: string
Read Only:
trueMaximum Length:4000Value that identifies the point in time inside which the planning process won't schedule a supply order to be due. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
PostprocessingLeadTime: number
Read Only:
trueNumber of days required to make an item available in inventory once the supply is complete. -
PreprocessingLeadTime: number
Read Only:
trueNumber of days which must be added to purchasing or manufacturing lead time to place an order. -
ProcessingLeadTime: number
Read Only:
trueNumber of days required to procure or manufacture an item. -
ReleaseTimeFenceCode: integer
Read Only:
trueAbbreviation that identifies the point in time inside which planned orders with certain criteria are automatically released as work orders or purchase orders. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
ReleaseTimeFenceDate: string
(date)
Read Only:
trueDate before which orders are automatically released as work orders or purchase requisitions. -
ReleaseTimeFenceDays: integer
Read Only:
trueTime horizon, in number of days, in which orders are automatically released as work orders or purchase requisitions. -
ReleaseTimeFenceType: string
Read Only:
trueMaximum Length:4000Value that identifies the point in time inside which planned orders with certain criteria are automatically released as work orders or purchase orders. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
Rounding: integer
Read Only:
trueValue that indicates whether planned order quantity is rounded to a whole number or not. Valid values are: 1 or 2. If 1, then planned order quantity is rounded. If 2, then not. -
RoundingMeaning: string
Maximum Length:
4000Value that indicates whether the planned order quantity is rounded to a whole number or not. Valid values are: Yes or No. If Yes, then the planned order quantity is rounded. If No, then the planned order quantity isn't rounded. -
SafetyStockCode: integer
Read Only:
trueValue that identifies the method that planning uses to calculate safety stock levels for the item. A list of accepted values is defined in the lookup type ORA_MSC_SS_PLANNING_METHD. -
SafetyStockForecastPlan: string
Read Only:
trueMaximum Length:4000Demand plan that contains the forecast and forecast error measures that the plan uses to calculate safety stock. -
SafetyStockPlanningMethod: string
Read Only:
trueMaximum Length:4000Meaning associated with the SafetyStockCode attribute. -
SafetyStockQuantity: number
Read Only:
trueDesired level of safety stock of an item. -
SellingPrice: number
Read Only:
trueSelling price of the item. -
ServiceLevelPercentage: number
Read Only:
trueDesired level of customer service, expressed as a percentage, in satisfying product demand. This represents the probability that an order can be filled from available inventory. -
ShrinkageRate: number
Read Only:
trueAverage amount of material you expect to lose when manufacturing or storing the item. -
StandardCost: number
Read Only:
trueStandard cost of an item. -
SupplyType: string
Read Only:
trueMaximum Length:4000Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE. -
UnitVolume: number
Read Only:
trueVolume of one item. -
UnitWeight: number
Read Only:
trueWeight of one item. -
UOM: string
Read Only:
trueMaximum Length:4000Planning unit of measure of the item. -
UOMCode: string
Read Only:
trueMaximum Length:3Abbreviation that identifies the unit of measure associated with the order quantity. -
UseUpDate: string
(date)
Read Only:
trueDate when the current on-hand quantity for an item is exhausted based on projected gross requirements. -
VariableLeadTime: number
Read Only:
trueTime to produce one unit of an assembly. -
VolumeUOMName: string
Read Only:
trueMaximum Length:4000Unit of measure to use for the item volume. -
WeightUOMName: string
Read Only:
trueMaximum Length:4000Unit of measure to use for the item weight.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-ItemSubinventories-item-response
Type:
Show Source
object-
CreatedBy: string
Read Only:
trueMaximum Length:255User who created the item subinventory. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the item subinventory. -
DataSecurityEditAllowed: string
Read Only:
trueMaximum Length:255Value that indicates whether the record is editable. -
Description: string
Read Only:
trueMaximum Length:240Description of the item. -
FixedLotMultiplier: number
Read Only:
trueFixed lot multiplier order modifier for the item. -
InventoryItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the item. -
ItemName: string
Read Only:
trueMaximum Length:300Name of the item. -
LastUpdateDate: string
(date-time)
Read Only:
trueIndicates the date and time of the last update of the row. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64Indicates the user who last updated the row. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32Indicates the session sign-in associated with the user who last updated the row. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Location: string
Read Only:
trueMaximum Length:4000Name of the organization or subinventory. -
MaximumMinmaxQuantity: number
Read Only:
trueMaximum inventory level. -
MaximumOrderQuantity: number
Read Only:
trueMaximum order quantity of the item. -
MinimumMinmaxQuantity: number
Read Only:
trueMinimum inventory level. -
MinimumOrderQuantity: number
Read Only:
trueMinimum order quantity of the item. -
NewPlanId: integer
Read Only:
trueValue that uniquely identifies the new plan that the duplication process creates. -
ObjectVersionNumber: integer
(int32)
Read Only:
trueValue that indicates if the row has been updated. -
OrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the organization. -
PlanId: integer
Read Only:
trueValue that uniquely identifies the plan. -
PostprocessingLeadTime: number
Read Only:
truePostprocessing lead time. -
PreprocessingLeadTime: number
Read Only:
truePreprocessing lead time. -
ProcessingLeadTime: number
Read Only:
trueNumber of days required to procure an item. -
RefreshNumber: integer
Read Only:
trueValue that indicates the refresh number. -
SimEditFlags: integer
Read Only:
trueValue that indicates whether the column is editable in a simulation set. -
SimulationSetId: integer
Read Only:
trueValue that uniquely identifies the simulation set. -
SubInventoryCode: string
Read Only:
trueMaximum Length:10Name of the subinventory. -
SubInventoryId: integer
(int64)
Read Only:
trueValue that uniquely identifies the subinventory.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-Operations-item-response
Type:
Show Source
object-
ChangeIndicatorFlag: boolean
Read Only:
trueValue that identifies whether the work definition operation has been modified. Valid values are true or false. If true, then the row is new or modified. If false, then the row isn't new or modified. -
DataSecurityEditAllowed: string
Read Only:
trueMaximum Length:255Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
FixedLeadTime: number
Title:
Fixed Lead TimeDays required to produce a batch of an assembled item. -
Item: string
Title:
ItemMaximum Length:250Name of the item being made in the operation. -
ItemId: integer
(int64)
Value that uniquely identifies the item.
-
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueIndicates the date and time of the last update of the row. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64Indicates the user who last updated the row. -
LineCode: string
Title:
Line CodeRead Only:trueMaximum Length:120Code for the production line represents a collection of machines and assembly workstations used to manufacture a product or a group of products. -
LineOperationSequence: integer
Title:
Line Operation SequenceRead Only:trueStage where the material is consumed on a production line. -
LineRate: number
Title:
Line RateRead Only:trueHourly rate of the production line. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MinimumTransferQuantity: number
Title:
Minimum Transfer QuantityMinimum amount of a supply to be transferred. -
NewPlanId: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
NewPlanIdSecondary: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
NotesCount: integer
Title:
NotesRead Only:trueNumber of notes associated with this operation. -
NumberOfLineOperations: integer
Title:
Number of OperationsRead Only:trueIdentifies the number of operations on a production line. -
OperationCost: number
Title:
Operation CostValue that indicates the outside processing operation cost. -
OperationDescription: string
Title:
Operation DescriptionMaximum Length:240Operation Description -
OperationEffectiveEndDate: string
(date)
Title:
Operation Effective End DateOperation Effective End Date -
OperationEffectiveStartDate: string
(date)
Title:
Operation Effective Start DateOperation Effective Start Date -
OperationResources: array
Operation Resources
Title:
Operation ResourcesResources, such as equipment and labor, required in each operation to make an item. -
OperationSequenceId: integer
(int64)
Unique identifier of the operation sequence.
-
OperationSequenceNumber: integer
(int64)
Title:
Operation Sequence NumberNumber that identifies the execution sequence of the operation. -
OperationType: string
Title:
Operation TypeMaximum Length:80Operation Type -
OperationYield: number
Title:
Operation YieldOperation Yield -
OrganizationCode: string
Title:
OrganizationMaximum Length:49Indicates the organization identifier. -
OrganizationId: integer
(int64)
Unique identifier of the organization.
-
OrganizationIdSecondary: integer
Unique identifier of the organization.
-
PlanId: integer
Value that uniquely identifies the plan.
-
PlanIdSecondary: integer
Value that uniquely identifies the plan.
-
PlanningPercentage: number
Title:
Planning PercentagePercentage of time a component item or option will be used within a parent model or a product family. -
Primary: string
Title:
PrimaryRead Only:trueMaximum Length:255Indicates whether the related object is the primary object. For example, whether a routing is the primary routing. -
ProcessName: string
Title:
Process NameMaximum Length:120Name of the work definition process. -
RoutingSequenceId: integer
Routing sequence identifier for the routing or the work definition.
-
RoutingSequenceIdSecondary: integer
(int64)
Routing sequence identifier for the routing or the work definition.
-
SimulationSetId: integer
(int64)
Value that uniquely identifies the simulation set.
-
SimulationSetIdSecondary: integer
(int64)
Value that uniquely identifies the simulation set.
-
Supplier: string
Title:
SupplierRead Only:trueMaximum Length:4000Name of the supplier in the demand exception. -
SupplierId: integer
(int64)
Value that uniquely identifies the supplier.
-
SupplierSite: string
Title:
Supplier SiteRead Only:trueMaximum Length:4000Name of the supplier site in the demand exception. -
SupplierSiteId: integer
(int64)
Value that uniquely identifies the supplier site in the demand exception.
-
VariableLeadTime: number
Title:
Variable Lead TimeDays required to produce one unit of an assembled item that will be incurred for each item being made. -
WorkDefinitionDescription: string
Title:
Work Definition DescriptionMaximum Length:960Description of a work definition for an item. -
WorkDefinitionName: string
Title:
Work DefinitionMaximum Length:300Work Definition -
WorkMethod: string
Title:
Work MethodRead Only:trueMaximum Length:255Type of manufacturing used for the production process. Valid values are Discrete Manufacturing and Process Manufacturing.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Operation Resources
Type:
arrayTitle:
Operation ResourcesResources, such as equipment and labor, required in each operation to make an item.
Show Source
Nested Schema : planInputs-Operations-OperationResources-item-response
Type:
Show Source
object-
AlternateResource: string
Title:
Alternate ResourceRead Only:trueMaximum Length:255Indicates whether the resource is an alternate, nonprimary resource. Value values are Yes and No. -
AssignedUnits: integer
Title:
Assigned UnitsNumber of units assigned to a resource. -
Basis: string
Title:
BasisRead Only:trueMaximum Length:255Identifies whether component item usage is based on the quantity of an item produced or for the entire lot. -
BasisCode: integer
Title:
BasisIdentifies whether component item usage is based on the quantity of an item produced or for the entire lot. -
ChangeIndicatorFlag: boolean
Read Only:
trueValue that identifies whether the operation description has been modified. Valid values are true or false. If true, then the row is new or modified. If false, then the row isn't new or modified. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64Indicates the user who last updated the row. -
LastUpdatedDate: string
(date-time)
Title:
Last Updated DateRead Only:trueIndicates the date and time of the last update of the row. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NewPlanId: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
NewPlanIdSecondary: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
OperationSequenceId: integer
Unique identifier of the operation sequence.
-
OperationSequenceIdSecondary: integer
Unique identifier of the operation sequence.
-
OrganizationId: integer
(int64)
Unique identifier of the organization.
-
OrganizationIdSecondary: integer
(int64)
Unique identifier of the organization.
-
PlanId: integer
Value that uniquely identifies the plan.
-
PlanIdSecondary: integer
Value that uniquely identifies the plan.
-
PrimaryResource: string
Title:
Primary ResourceMaximum Length:40Name of the primary resource for which a specific resource is an alternate. -
PrimaryResourceId: integer
(int64)
Title:
Primary ResourceUnique identifier of the primary resource for which a specific resource is an alternate. -
PrincipalResource: string
Title:
Principal ResourceRead Only:trueMaximum Length:255Indicates whether a resource is a main resource or not. Valid Values are Yes and No. -
Priority: integer
Title:
PriorityA numeric value indicating the priority of the object. -
Resource: string
Title:
ResourceMaximum Length:72Code used to identify a resource. For example, a resource can be a piece of equipment. -
ResourceCost: number
Title:
Resource CostCost associated with a resource. -
ResourceId: integer
(int64)
Value that uniquely identifies the resource.
-
ResourceSequence: integer
Title:
Resource SequenceNumber representing the order in which the resources are assigned in the same operation. -
ResourceSequenceSecondary: integer
(int64)
Number representing the order in which the resources are assigned in the same operation.
-
ResourceUOM: string
Title:
Resource UOMRead Only:trueMaximum Length:4000Unit of measure associated with the resource. -
RoutingSequenceId: integer
Routing sequence identifier for the routing or the work definition.
-
RoutingSequenceIdSecondary: integer
Routing sequence identifier for the routing or the work definition.
-
ScheduleType: string
Title:
Schedule TypeMaximum Length:80Indicates whether the resource needs to be scheduled or not. Valid values are Yes and No. -
SimulationSetId: integer
(int64)
Value that uniquely identifies the simulation set.
-
SimulationSetIdSecondary: integer
(int64)
Value that uniquely identifies the simulation set.
-
Usage: number
Title:
UsageAmount of a resource that's needed, usually expressed in hours. -
WorkArea: string
Title:
Work AreaMaximum Length:120Name of the work area. -
WorkCenter: string
Title:
Work CenterMaximum Length:120Work center name of the resource.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-OutputItems-item-response
Type:
Show Source
object-
AssemblyItem: string
Title:
Assembly ItemRead Only:trueMaximum Length:300Name of the assembly item. -
AssemblyItemId: integer
Read Only:
trueUnique identifier of the assembly item. -
BatchQuantity: number
Title:
Batch QuantityRead Only:trueQuantity of the production batch used for batch sizing and scaling. -
BatchQuantityUOM: string
Title:
Batch Quantity UOMRead Only:trueMaximum Length:4000Unit of measure of the output item batch quantity. -
BatchQuantityUOMCode: string
Read Only:
trueMaximum Length:3Unit of measure code of the output item batch quantity. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the output item. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the output item. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate when the output item was most recently updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the output item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OperationSequenceId: integer
Read Only:
trueUnique identifier of the operation sequence. -
OperationSequenceNumber: integer
Title:
Operation Sequence NumberRead Only:trueNumber that identifies the execution sequence of the operation. -
Organization: string
Title:
OrganizationRead Only:trueMaximum Length:255Organization name of the output item. -
OrganizationCode: string
Title:
OrganizationRead Only:trueMaximum Length:4000Organization code of the output item. -
OrganizationId: integer
(int64)
Read Only:
trueUnique identifier of the organization. -
OutputItem: string
Title:
Output ItemRead Only:trueMaximum Length:300Item produced at various operations of a process work definition. -
OutputItemId: integer
(int64)
Read Only:
trueUnique identifier of the output item. -
OutputQuantity: number
Title:
Output QuantityRead Only:trueQuantity of the output item. -
OutputQuantityUOM: string
Title:
Output Item UOMRead Only:trueMaximum Length:4000Unit of measure of the output item quantity. -
OutputQuantityUOMCode: string
Read Only:
trueMaximum Length:3Unit of measure code of the output item quantity. -
OutputTypeCode: integer
(int64)
Title:
Output TypeRead Only:trueCode of the type of output produced by an operation in a process work definition. Output type can be primary product, co-product, or by-product. -
OutputTypeName: string
Title:
Output TypeRead Only:trueMaximum Length:255Type of output produced by an operation in a process work definition. Output type can be primary product, co-product, or by-product. -
PlanId: integer
(int64)
Read Only:
trueValue that uniquely identifies the plan. -
WorkDefinitionName: string
Title:
Work DefinitionRead Only:trueMaximum Length:300Name of the work definition associated with the output item.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-PlanningDemands-item-response
Type:
Show Source
object-
AllowSplits: integer
Read Only:
trueValue that indicates whether Oracle Global Order Promising Cloud can automatically split a fulfillment line into two or more lines to optimize promising results. Valid values are 1 or 2. If 1, then Global Order Promising can automatically split a fulfillment line. If 2, then Global Order Promising can't automatically split a fulfillment line. -
AllowSubstitution: integer
Read Only:
trueValue that indicates whether Oracle Global Order Promising Cloud can consider end item substitution to optimize promising results. Valid values are 1 or 2. If 1, then Global Order Promising considers end item substitution. If 2, then Global Order Promising doesn't consider end item substitution. -
ArrivalSetName: string
Read Only:
trueMaximum Length:30A named set designating the order lines that should arrive together. On the sales order, the arrival set name designates lines that should arrive together at the customer site. -
AssetNumber: string
Read Only:
trueMaximum Length:80Number that identifies the asset associated with a maintenance work order. -
BucketType: string
Read Only:
trueTime bucket used for forecast demands. Valid values include Day, Month, Period, or Week. A list of accepted values is defined in the lookup types ORA_MSC_TIME_LEVELS_GREGORIAN and ORA_MSC_TIME_LEVELS_MFG. -
Buyer: string
Read Only:
trueMaximum Length:240Name of the buyer associated with the item. -
CategoryName: string
Title:
CategoryRead Only:trueMaximum Length:4000Name of the category to which the item is assigned. -
CompletedQuantity: number
Read Only:
trueShipped quantity of the sales order. -
ComponentQuantityIssued: number
Read Only:
trueQuantity of a component issued to a work order. -
ConfigurationItem: string
Read Only:
trueMaximum Length:4000Name of the configuration item. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the order. -
CreationDate: string
(date-time)
Read Only:
trueDate when the user created the order. -
Customer: string
Read Only:
trueMaximum Length:4000Name of the customer associated with the sales order or forecast. -
CustomerId: integer
(int64)
Read Only:
trueValue that uniquely identifies the customer. -
CustomerPOLineNumber: string
Read Only:
trueMaximum Length:50Value that uniquely identifies the customer site. -
CustomerPONumber: string
Read Only:
trueMaximum Length:240Value that uniquely identifies the item. -
CustomerPOScheduleNumber: string
Read Only:
trueMaximum Length:50Value that uniquely identifies the organization. -
CustomerSite: string
Read Only:
trueMaximum Length:4000Code associated with a specific customer ship-to location. -
CustomerSiteId: integer
(int64)
Read Only:
trueValue that uniquely identifies the customer site. -
DataSecurityEditAllowed: string
Read Only:
trueContains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
DeliveryCost: number
Read Only:
trueDelivery cost per unit. -
DeliveryLeadTime: number
Read Only:
trueNumber of days required to deliver the order to the customer. -
DemandClass: string
Read Only:
trueMaximum Length:34Classification of demand used to track and consume different types of demand. Review and update the value for this attribute using the Manage Demand Classes task. -
DemandClassCode: string
Read Only:
trueMaximum Length:4000Code that identifies the demand class associated with the order. A list of accepted values is defined in the MSC_SR_LOOKUP_VALUES_TL table where LOOKUP_TYPE is DEMAND_CLASS. -
DemandPriority: integer
Read Only:
truePriority of the demand. -
DestinationTimeZone: string
Read Only:
trueMaximum Length:400Time zone associated with the entity that's receiving the order. The destination entity can be a customer or an organization. -
EarliestAcceptableArrivalDate: string
(date)
Read Only:
trueDate when the customer can accept the order to arrive at the earliest. -
EarliestAcceptableShipDate: string
(date)
Read Only:
trueDate when the customer can accept the order to be shipped at the earliest. -
EndDemandValue: number
Monetary value associated with the end demand.
-
ExpenseDestinationTransfer: string
Read Only:
trueContains one of the following values: Yes or No. If Yes, then the transfer is to an expense destination. If No, then the transfer isn't to an expense destination. -
ExpenseTransfer: number
Read Only:
trueContains one of the following values: Yes or No. If Yes, then the transfer is to an expense destination. If No, then the transfer isn't to an expense destination. -
FirmDate: string
(date)
Read Only:
trueDate when the demand is due. This attribute is a fixed value that can't be rescheduled by planning and is only populated when the firm status is firm. -
FirmPlannedType: integer
Read Only:
trueValue that indicates whether the demand is firmed or not. Valid values are 1 or 2. If 1, then the demand is firm. If 2, then the demand isn't firm. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_FIRM_STATUS. -
FirmQuantity: number
Read Only:
trueFixed quantity of demand. This attribute value can't be changed by planning and is only populated when the firm status is firm. -
FirmStatus: string
Read Only:
trueMaximum Length:4000Status that indicates whether the order is firm or not. Valid values include Firm and Not firm. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_FIRM_STATUS. -
FulfillmentCost: number
Read Only:
trueEstimated cost to deliver a fulfillment line to a customer. The amount includes item cost and shipping cost. -
FulfillmentLine: number
Read Only:
trueFulfillment line number associated with a sales order. -
GOPReferenceId: string
Read Only:
trueMaximum Length:300Value that uniquely identifies the cross reference of the recommended split fulfillment line created by Oracle Global Order Promising Cloud. -
IncludedItemsIndicator: integer
Read Only:
trueValue that indicates whether the sales order line is communicated to Oracle Global Order Promising Cloud for pick-to-order items. Valid values are 1 or 2. If 1, then pick-to-order items are communicated to Global Order Promising. If 2, then pick-to-order items aren't communicated to Global Order Promising. -
InventoryItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the item. -
Item: string
Read Only:
trueMaximum Length:300Name of the item associated with the demand. -
ItemDescription: string
Read Only:
trueMaximum Length:240Description of the item associated with the demand. -
ItemSubTypeCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the subclassification of the item on the order. A list of accepted values is defined in the lookup type ORA_MSC_OP_CTO_ITEM_SUB_TYPE. -
ItemTypeCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the type of the item on the order. Valid values are 1, 2 or 3. If 1, then Model Item. If 2, then Option Class. If 3, then Standard Item. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate when the demand was most recently updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the demand. -
LatestAcceptableArrivalDate: string
(date)
Read Only:
trueDate when the customer can accept the order to arrive at the latest. -
LatestAcceptableDate: string
(date)
Read Only:
trueDate beyond which the demand line must not be promised. -
LatestAcceptableShipDate: string
(date)
Read Only:
trueDate when the customer can accept the order to be shipped at the latest. -
LineNumber: string
Read Only:
trueMaximum Length:150Line number associated with the demand. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Lot: string
Read Only:
trueMaximum Length:80Number that identifies the lot of the on-hand supply. -
MinimumPercentageForSplit: number
Read Only:
trueIf splits are allowed, this attribute specifies the minimum percentage required for splitting a fulfillment line. -
MinimumQuantityForSplit: number
Read Only:
trueIf splits are allowed, this attribute specifies the minimum quantity required for splitting a fulfillment line. -
MinimumRemainingShelfLife: number
Read Only:
trueMinimum duration of shelf life remaining when perishable products such as pharmaceuticals or groceries arrive at the customer site, so that there will be enough time for the end consumer to buy and use the products. -
Notes: integer
Contains information created or updated for an exception detail represented as notes.
-
OldDueDate: string
(date)
Read Only:
trueDate when the demand quantity was originally due. This attribute value is extracted from the source application. -
OrderDateType: string
Read Only:
trueMaximum Length:4000Value that indicates the date specified by the customer. This attribute applies only to sales orders. Valid values include Ship date or Arrival date. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_DATE_TYPE_CODE. -
OrderDateTypeCode: integer
Read Only:
trueValue that indicates the date specified by the customer. This attribute applies only to sales orders. Valid values include: 1 where customer has specified a requested ship date or 2 where customer has specified a requested arrival date. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_DATE_TYPE_CODE. -
OrderMargin: number
Read Only:
trueValue that indicates the difference between the revenue from the fulfillment line and the cost of promising the fulfillment line based on the current promising result. -
OrderNumber: string
Read Only:
trueMaximum Length:4000Order number associated with the sales order. -
OrderQuantity: number
Read Only:
trueQuantity associated with the demand. -
OrderType: integer
Read Only:
trueAbbreviation that identifies the type of order. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE. -
OrderTypeText: string
Read Only:
trueMaximum Length:4000Value that indicates the type of order such as sales order or forecast. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE. -
Organization: string
Read Only:
trueMaximum Length:49Name of the organization associated with the order. -
OrganizationId: integer
Read Only:
trueValue that uniquely identifies the organization. -
OrganizationTimeZone: string
Read Only:
trueMaximum Length:400Time zone of the organization associated with the demand. -
OrgCurrencyCode: string
Read Only:
trueMaximum Length:4000Abbreviation that identifies the base currency of the organization. -
OriginalItem: string
Read Only:
trueMaximum Length:4000Name of the item for which the order was originally scheduled. -
OriginalItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the requested item. -
OriginalOrderQuantity: number
Read Only:
trueQuantity associated with the order. This value is extracted from the source application. -
ParentFulfillmentLine: string
Read Only:
trueMaximum Length:400For an order with assemble-to-order elements, this attribute indicates the immediate parent of an assemble-to-order component. -
ParentModel: string
Read Only:
trueMaximum Length:4000Model at a higher level in a hierarchy that's used to drive the forecast of a child model, option class, or option. -
PlannedArrivalDate: string
(date)
Read Only:
trueDate when the item will arrive. The attribute value is calculated using the suggested ship date, carrier calendar, in-transit lead time, and the receiving calendar. -
Planner: string
Read Only:
trueMaximum Length:10Abbreviation that identifies the planner responsible for the item. -
PlannerDescription: string
Read Only:
trueMaximum Length:4000Description of the planner responsible for the item. -
PlanningAttributes: array
Planning Attributes
Title:
Planning AttributesThe Planning Attributes resource manages the attribute-based planning attributes associated with a demand or supply. -
ProjectGroupValue: string
Read Only:
trueMaximum Length:4000Value that identifies the project group. -
ProjectValue: string
Read Only:
trueMaximum Length:4000Value that identifies the project. -
PromisedArrivalDate: string
(date)
Read Only:
trueDate when a customer has been promised the delivery of the order. -
PromisedShipDate: string
(date)
Read Only:
trueDate when a customer has been promised the shipping of the order. -
PromisingSystem: string
Read Only:
trueMaximum Length:50Name of the promising application that promises supply for the demand. -
RequestedArrivalDate: string
(date)
Read Only:
trueDate when the material must arrive at the customer site. -
RequestedShipDate: string
(date)
Read Only:
trueDate when the material must be shipped out to the customer. -
RootFulfillmentLine: string
Read Only:
trueMaximum Length:400For an order having assemble-to-order elements, this attribute indicates the top-most model. -
RoundingControlType: integer
Read Only:
trueValue that indicates whether planned order quantity is rounded to a whole number or not. Valid values are: 1 or 2. If 1, then planned order quantity is rounded. If 2, then not. -
SalesRepresentativeContact: string
Read Only:
trueMaximum Length:50Contact details of the sales representative. -
ScheduledArrivalDate: string
(date)
Read Only:
trueDate when the demand has been scheduled to arrive at a customer site. -
ScheduledShipDate: string
(date)
Read Only:
trueDate when the demand has been scheduled to be shipped. -
ScheduleName: string
Read Only:
trueMaximum Length:4000Name of the supply or demand schedule associated with an order. -
SellingPrice: number
Read Only:
trueSelling price of an item on the order line. -
ShipmentSetName: string
Read Only:
trueMaximum Length:50On the sales order, the ship set name designates lines that should ship together. -
ShipMethod: string
Read Only:
trueMaximum Length:30Value that indicates the shipping method associated with the order. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab. -
ShippingMethod: string
Read Only:
trueMaximum Length:4000Value that indicates the shipping method used to ship the order, or is a concatenation of carrier name, method of transportation, and service level associated with the order. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab. -
ShippingPreference: string
Read Only:
trueMaximum Length:1200Value that indicates the shipping preference for the order. -
ShipTo: string
Read Only:
trueMaximum Length:4000Abbreviation that identifies the specific ship-to location. -
SourceOrder: string
Read Only:
trueMaximum Length:240Value that identifies the order number in the source application against which fulfillment line has been created. -
SourceOrderLine: string
Read Only:
trueMaximum Length:150Value that identifies the order line number in the source application against which fulfillment line has been created. -
SourceOrganization: string
Read Only:
trueMaximum Length:4000Name of the organization that will source the order. -
SourceOrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the source organization. -
SourceTablePrimary: string
Read Only:
trueMaximum Length:13Value that identifies the data table source of the supply. -
SourceTimeZone: string
Read Only:
trueMaximum Length:400Time zone associated with the entity that's sourcing the order. The sourcing entity can be a supplier or an organization. -
Subinventory: string
Read Only:
trueMaximum Length:10Subinventory code associated with the demand. -
SuggestedDueDate: string
(date)
Read Only:
trueDate when the demand is recommended to be completed. -
SuggestedShipDate: string
(date)
Read Only:
trueDate when the order is recommended to be shipped. -
Supplier: string
Read Only:
trueMaximum Length:4000Name of the source supplier. -
SupplierId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supplier. -
SupplierSite: string
Read Only:
trueMaximum Length:4000Abbreviation that indicates the specific supplier ship-from location. -
SupplierSiteId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supplier site. -
SupplierSiteSourceSystem: integer
Read Only:
trueFor drop ship sales orders, the source application for which the supplier site is defined. -
TaskValue: string
Read Only:
trueMaximum Length:4000Value that identifies task. -
TransactionId: integer
(int64)
Read Only:
trueValue that uniquely identifies the demand. This value is internally generated by the application. -
UOM: string
Read Only:
trueMaximum Length:4000Name of the unit of measure that's associated with the order quantity. -
UOMCode: string
Read Only:
trueMaximum Length:3Abbreviation that identifies the unit of measure associated with the order quantity. -
UsingAssembly: string
Read Only:
trueMaximum Length:4000For component demands, this field refers to the assembly item that uses this item as a component. -
Zone: string
Read Only:
trueMaximum Length:4000Region or zone where the demand quantity is being shipped.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Planning Attributes
Type:
arrayTitle:
Planning AttributesThe Planning Attributes resource manages the attribute-based planning attributes associated with a demand or supply.
Show Source
Nested Schema : planInputs-PlanningDemands-PlanningAttributes-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrderNumber: string
Title:
Order NumberMaximum Length:4000Number that identifies the order associated with the demand or supply. -
PlanningAttributeNumber10: string
Maximum Length:
4000Value for the planning attribute number 10 in attribute-based planning. -
PlanningAttributeNumber11: string
Maximum Length:
4000Value for the planning attribute number 11 in attribute-based planning. -
PlanningAttributeNumber12: string
Maximum Length:
4000Value for the planning attribute number 12 in attribute-based planning. -
PlanningAttributeNumber13: string
Maximum Length:
4000Value for the planning attribute number 13 in attribute-based planning. -
PlanningAttributeNumber14: string
Maximum Length:
4000Value for the planning attribute number 14 in attribute-based planning. -
PlanningAttributeNumber15: string
Maximum Length:
4000Value for the planning attribute number 15 in attribute-based planning. -
PlanningAttributeNumber3: string
Maximum Length:
4000Value for the planning attribute number 3 in attribute-based planning. -
PlanningAttributeNumber4: string
Maximum Length:
4000Value for the planning attribute number 4 in attribute-based planning. -
PlanningAttributeNumber5: string
Maximum Length:
4000Value for the planning attribute number 5 in attribute-based planning. -
PlanningAttributeNumber6: string
Maximum Length:
4000Value for the planning attribute number 6 in attribute-based planning. -
PlanningAttributeNumber7: string
Maximum Length:
4000Value for the planning attribute number 7 in attribute-based planning. -
PlanningAttributeNumber8: string
Maximum Length:
4000Value for the planning attribute number 8 in attribute-based planning. -
PlanningAttributeNumber9: string
Maximum Length:
4000Value for the planning attribute number 9 in attribute-based planning. -
TransactionId: integer
(int64)
Value that uniquely identifies the demand or supply. This value is internally generated by the application.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-PlanningSupplies-item-response
Type:
Show Source
object-
ActualStartDate: string
(date)
Read Only:
trueDate when the work was started, which applies to work orders in process. -
AlternateBOMDesignator: string
Read Only:
trueMaximum Length:80Name of the alternate bill of material. -
AlternateRoutingDesignator: string
Read Only:
trueMaximum Length:30Name of a routing used for the make order. -
AssetNumber: string
Read Only:
trueMaximum Length:80Number that identifies the asset associated with a maintenance work order. -
BatchQuantity: number
Read Only:
trueQuantity that moves through operations in a process work order. -
BatchUOM: string
Read Only:
trueMaximum Length:3Unit of measure for the batch quantity in a process work order. -
BillSequenceId: integer
(int64)
Read Only:
trueValue that uniquely identifies the sequence in which a component is used within an operation. -
BmtOption: integer
Read Only:
trueContains one of the following values: 1 or 2. If 1, then the buyer is responsible for the transportation of the purchased item. If 2, then the buyer isn't responsible for the transportation of the purchased item. This attribute applies only to purchased items. -
Buyer: string
Read Only:
trueMaximum Length:240Name of the buyer associated to the item. -
BuyerManagedTransportation: string
Read Only:
trueMaximum Length:400Contains one of the following values: Yes or No. If Yes, then the buyer is responsible for the transportation of the purchased item. If No, then the buyer isn't responsible for the transportation of the purchased item. This attribute applies only to purchased items. -
Canceled: integer
Read Only:
trueValue that indicates whether the supply has been canceled. -
CanceledText: string
Read Only:
trueMaximum Length:4000Value that indicates whether the supply has been canceled. Valid values are: Yes or No. If Yes, then the supply has been canceled. If No, then the supply hasn't been canceled. -
CategoryName: string
Title:
CategoryRead Only:trueMaximum Length:4000Name of the category to which the item is assigned. -
CompletedQuantity: number
Read Only:
trueQuantity of the work order that's already completed. -
ComponentQuantityIssued: number
Read Only:
trueQuantity of a component issued to a work order. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the order. -
CreationDate: string
(date-time)
Read Only:
trueDate when the user created the order. -
CumulativeYield: number
Read Only:
trueName of the column that contains the cumulative yield. For example, the name of the column in the Supplies and Demands view. This column is the product of operation yields of all the operations in the work definition of an item. -
Customer: string
Read Only:
trueMaximum Length:400Name of the customer associated with the drop ship purchase order. -
CustomerId: integer
Read Only:
trueValue that uniquely identifies the customer. -
CustomerSite: string
Read Only:
trueMaximum Length:400Code associated with a specific customer ship-to location. -
CustomerSiteId: integer
Read Only:
trueValue that uniquely identifies the customer site. -
DataSecurityEditAllowed: string
Read Only:
trueContains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
DeliveryPrice: number
Read Only:
trueSupply unit price for purchased supply. -
DestinationTimeZone: string
Read Only:
trueMaximum Length:400Time zone associated with the entity that's receiving the order. The destination entity can be a customer or an organization. -
DestinationType: string
Read Only:
trueMaximum Length:400Value that indicates where the supply is destined. A list of accepted values is defined in the lookup type ORA_MSC_DESTINATION_TYPE. -
DropShipCustomer: string
Read Only:
trueMaximum Length:400Number that uniquely identifies the customer whose demand is being met through the drop ship supply. -
DropShipCustomerSite: string
Read Only:
trueMaximum Length:400Customer site to which the drop ship supply must be shipped to meet the demand. -
DropShipDestType: integer
Read Only:
trueCode that identifies where the supply is destined. A list of accepted values is defined in the lookup type ORA_MSC_DESTINATION_TYPE. -
ExpectedScrapQuantity: number
Read Only:
trueQuantity of the work order or planned order that's expected to be scrapped in addition to the quantity already scrapped. -
ExpenseDestinationTransfer: string
Read Only:
trueMaximum Length:400Contains one of the following values: Yes or No. If Yes, then the transfer is to an expense destination. If No, then the transfer isn't to an expense destination. -
ExpenseTransfer: integer
Read Only:
trueContains one of the following values: Yes or No. If Yes, then the transfer is to an expense destination. If No, then the transfer isn't to an expense destination. -
ExpirationDate: string
(date)
Read Only:
trueDate when the existing lot associated with the supply expires. -
FgOrderType: integer
Read Only:
trueValue used by the planning engine to identify the type of order at a more granular level than the OrderType attribute. -
FirmDate: string
(date)
Read Only:
trueDate when supply is due. This attribute is a fixed value that can't be rescheduled by planning and is only populated when the firm status is firm. -
FirmPlannedType: integer
Read Only:
trueValue that indicates whether the order is firmed or not. Valid values are 1 or 2. If 1, then the order is firm. If 2, then the order isn't firm. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_FIRM_STATUS. -
FirmQuantity: number
Read Only:
trueFixed quantity of supply. This attribute value can't be changed by planning and is only populated when the firm status is firm. -
FirmStartQuantity: number
Read Only:
trueUser-specified start quantity of a supply. This attribute value can't be changed by planning and is only populated when the firm status is firm. -
FirmStatus: string
Read Only:
trueMaximum Length:400Status that indicates whether the order is firm or not. Valid values include Firm and Not firm. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_FIRM_STATUS. -
HoldDate: string
(date)
Read Only:
trueDate on which the on-hand inventory lot is no longer on hold. -
InventoryItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the item. -
Item: string
Read Only:
trueMaximum Length:300Name of the item associated with the supply. -
ItemDescription: string
Read Only:
trueMaximum Length:240Description of the item that's associated with the supply. -
ItemStructureName: string
Read Only:
trueMaximum Length:400Name of the item structure planned to be used for the make order. -
LastCompletedOperationSequenceNumber: integer
Read Only:
trueThe sequence number of the last completed operation on a production line. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate when the order was most recently updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the supply. -
LineNumber: string
Read Only:
trueMaximum Length:400Number that identifies the order line. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Lot: string
Read Only:
trueMaximum Length:80Number that identifies the lot of the on-hand supply. -
MakeOrBuy: string
Read Only:
trueMaximum Length:400Value that indicates whether the item is a manufactured item or a purchased item. Valid values include Make or Buy. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MAKE_BUY. -
MaturityDate: string
(date)
Read Only:
trueDate when an inventory lot fully matures. It can then be used to fulfill demand. -
NeedByDate: string
(date)
Read Only:
trueDate when the supply quantity is needed. -
Notes: integer
Contains information created or updated for an exception detail represented as notes.
-
OldDockDate: string
(date)
Read Only:
trueDate when the order was originally to arrive at the receiving dock. This attribute value is extracted from the source application. -
OldDueDate: string
(date)
Read Only:
trueDate when the order was originally due. This attribute value is extracted from the source application. -
OrderNumber: string
Read Only:
trueMaximum Length:400Number that identifies the order associated with the supply. -
OrderQuantity: number
Read Only:
trueQuantity associated with the supply. -
OrderStatus: string
Read Only:
trueMaximum Length:200SCM Cloud transactional status of a work order, purchase order, or transfer order supplies that are referred to by the planning process. -
OrderType: integer
Read Only:
trueAbbreviation that identifies the type of order. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE. -
OrderTypeText: string
Read Only:
trueMaximum Length:400Type of order such as on hand, purchase order, or work order. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE. -
Organization: string
Read Only:
trueMaximum Length:49Name of the organization associated with the order. -
OrganizationId: integer
Read Only:
trueValue that uniquely identifies the organization. -
OrganizationTimeZone: string
Read Only:
trueMaximum Length:400Time zone associated with an organization. -
OriginalNeedByDate: string
(date)
Read Only:
trueDate when the order was originally needed. This value is extracted from the source application. -
OriginalOrderQuantity: number
Read Only:
trueOriginal quantity associated with the order. This value is extracted from the source application. -
Planner: string
Read Only:
trueMaximum Length:10Abbreviation that identifies the planner responsible for the item. -
PlannerDescription: string
Read Only:
trueMaximum Length:400Description of the planner responsible for the item. -
PlanningAttributes: array
Planning Attributes
Title:
Planning AttributesThe Planning Attributes resource manages the attribute-based planning attributes associated with a demand or supply. -
PlanningMakeBuyCode: integer
Read Only:
trueAbbreviation that indicates whether the item is manufactured or purchased. Valid values are 1 or 2. If 1, then the item is a manufactured item. If 2, then the item is a purchased item. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MAKE_BUY. -
ProcessName: string
Read Only:
trueMaximum Length:120Name of the manufacturing process used for this work order or planned order. -
ProjectGroupValue: string
Read Only:
trueMaximum Length:400Value that identifies the project group. -
ProjectValue: string
Read Only:
trueMaximum Length:400Value that identifies the project. -
PromisedArrivalDate: string
(date)
Read Only:
trueDate when a customer has been promised the delivery of the order. -
PromisedShipDate: string
(date)
Read Only:
trueDate when a customer has been promised the shipping of the order. -
ReceiptNumber: string
Read Only:
trueMaximum Length:30Number that identifies the receipt of the transfer order. -
RemainingQuantity: number
Read Only:
trueWork order quantity that remains to be completed. -
RequestedArrivalDate: string
(date)
Read Only:
trueDate when the material must arrive at the customer site. -
RequestedShipDate: string
(date)
Read Only:
trueDate when the material must be shipped out to the customer. -
Revision: string
Read Only:
trueMaximum Length:10Abbreviation that identifies the revision of the inventory item. -
RoundingControlType: integer
Read Only:
trueValue that indicates whether planned order quantity is rounded to a whole number or not. Valid values are: 1 or 2. If 1, then planned order quantity is rounded. If 2, then not. -
RoutingSequenceId: integer
(int64)
Read Only:
trueValue that uniquely identifies the routing that was used for the make order. -
ScheduleLineNumber: string
Read Only:
trueMaximum Length:30Number that identifies the purchase order line location information for collection at the schedule level. -
ScheduleName: string
Read Only:
trueMaximum Length:10Name of the schedule associated to the supply. -
SchedulePriority: number
Read Only:
trueValue that identifies the priority of the work order. -
ScrappedQuantity: number
Read Only:
trueWork order quantity that has been scrapped. -
ShipmentHeaderNumber: string
Read Only:
trueMaximum Length:30Number that identifies the shipment header of the transfer order. -
ShipmentLineNumber: string
Read Only:
trueMaximum Length:30Number that identifies the shipment line of the transfer order. -
ShipMethod: string
Read Only:
trueMaximum Length:30Value that indicates the shipping method used to ship the order. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab. -
ShippingMethod: string
Read Only:
trueMaximum Length:400Value that indicates the shipping method used to ship the order, or is a concatenation of carrier name, method of transportation, and service level associated with the order. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab. -
SourceOrganization: string
Read Only:
trueMaximum Length:400Name of the organization that will source the order. -
SourceOrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the source organization. -
SourceSubinventoryCode: string
Read Only:
trueMaximum Length:10Abbreviation that identifies the subinventory associated with the source of the supply. -
SourceTablePrimary: string
Read Only:
trueMaximum Length:13Value that identifies the data table source of the supply. -
SourceTimeZone: string
Read Only:
trueMaximum Length:400Time zone associated with the entity that's sourcing the order. The sourcing entity can be a supplier or an organization. -
StartQuantity: number
Read Only:
trueQuantity at the beginning of a manufacturing process. -
Subinventory: string
Read Only:
trueMaximum Length:10Subinventory code associated with the supply. -
SuggestedCompletionDate: string
(date)
Read Only:
trueDate when the process work order or a planned order completed. This attribute is required because the primary product can be produced in an operation that's prior to the last operation of the order. -
SuggestedDockDate: string
(date)
Read Only:
trueDate when the order is recommended to arrive at the receiving dock. -
SuggestedDueDate: string
(date)
Read Only:
trueDate when a supply is expected to be completed. -
SuggestedOrderDate: string
(date)
Read Only:
trueDate when an order is recommended to be placed. -
SuggestedShipDate: string
(date)
Read Only:
trueDate when the order is recommended to be shipped. -
SuggestedStartDate: string
(date)
Read Only:
trueDate when work on the order is recommended to begin. -
Supplier: string
Read Only:
trueMaximum Length:400Name of the source supplier. -
SupplierId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supplier. -
SupplierSite: string
Read Only:
trueMaximum Length:400Abbreviation that indicates the specific supplier location from where the item is being sourced. -
SupplierSiteId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supplier site. -
TaskValue: string
Read Only:
trueMaximum Length:400Value that identifies task. -
TransactionId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supply transaction. This value is internally generated by the application. -
Undercompleted: integer
Read Only:
trueContains one of the following values 1 or 2. If 1, then the work order is undercompleted based on undercompletion tolerance values. If 2, then the work order isn't undercompleted. -
UndercompletedText: string
Read Only:
trueMaximum Length:4000Contains one of the following values Yes or No. If Yes, then the work order is undercompleted based on undercompletion tolerance values. If No, then the work order isn't undercompleted. -
UnitNumber: string
Read Only:
trueMaximum Length:30Number that uniquely identifies the bill of material to be used for building a specific model or unit number effectivity-controlled item. This attribute is also known as End Item Unit Number. -
UOM: string
Read Only:
trueMaximum Length:400Name of the unit of measure associated with the order quantity. -
UOMCode: string
Read Only:
trueMaximum Length:3Abbreviation that identifies the unit of measure associated with the order quantity. -
WIPStatusCode: integer
Read Only:
trueAbbreviation that identifies the status of the work order. A list of accepted values is defined in the lookup type ORA_MSC_WIP_JOB_STATUS. -
WIPSupplyType: integer
Read Only:
trueType of supply transaction created when issuing items from inventory to work orders. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE. -
WorkDefinition: string
Read Only:
trueMaximum Length:400Name that uniquely identifies a work definition used for a make order. -
WorkMethod: string
Read Only:
trueMaximum Length:400Type of manufacturing used for the production process. Valid values are Discrete Manufacturing and Process Manufacturing. -
WorkMethodCode: number
Read Only:
trueType of manufacturing used for the production process. Valid values are 1: Discrete Manufacturing and 2: Process Manufacturing. -
WorkOrderStatus: string
Read Only:
trueMaximum Length:400Value that indicates the status of the work order. Valid values include Unreleased, Released, Complete, or On hold. A list of accepted values is defined in the lookup type ORA_MSC_WIP_JOB_STATUS. -
WorkOrderSubtype: integer
Read Only:
trueWork order subtype associated with the make order. A list of accepted values is defined in the lookup type ORA_MSC_WO_SUB_TYPE . -
Zone: string
Title:
ZoneRead Only:trueMaximum Length:400Region or zone where the demand quantity is being shipped.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Planning Attributes
Type:
arrayTitle:
Planning AttributesThe Planning Attributes resource manages the attribute-based planning attributes associated with a demand or supply.
Show Source
Nested Schema : planInputs-PlanningSupplies-PlanningAttributes-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrderNumber: string
Title:
Order NumberMaximum Length:4000Number that identifies the order associated with the demand or supply. -
PlanningAttributeNumber10: string
Maximum Length:
4000Value for the planning attribute number 10 in attribute-based planning. -
PlanningAttributeNumber11: string
Maximum Length:
4000Value for the planning attribute number 11 in attribute-based planning. -
PlanningAttributeNumber12: string
Maximum Length:
4000Value for the planning attribute number 12 in attribute-based planning. -
PlanningAttributeNumber13: string
Maximum Length:
4000Value for the planning attribute number 13 in attribute-based planning. -
PlanningAttributeNumber14: string
Maximum Length:
4000Value for the planning attribute number 14 in attribute-based planning. -
PlanningAttributeNumber15: string
Maximum Length:
4000Value for the planning attribute number 15 in attribute-based planning. -
PlanningAttributeNumber3: string
Maximum Length:
4000Value for the planning attribute number 3 in attribute-based planning. -
PlanningAttributeNumber4: string
Maximum Length:
4000Value for the planning attribute number 4 in attribute-based planning. -
PlanningAttributeNumber5: string
Maximum Length:
4000Value for the planning attribute number 5 in attribute-based planning. -
PlanningAttributeNumber6: string
Maximum Length:
4000Value for the planning attribute number 6 in attribute-based planning. -
PlanningAttributeNumber7: string
Maximum Length:
4000Value for the planning attribute number 7 in attribute-based planning. -
PlanningAttributeNumber8: string
Maximum Length:
4000Value for the planning attribute number 8 in attribute-based planning. -
PlanningAttributeNumber9: string
Maximum Length:
4000Value for the planning attribute number 9 in attribute-based planning. -
TransactionId: integer
(int64)
Value that uniquely identifies the demand or supply. This value is internally generated by the application.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-ResourceRequirements-item-response
Type:
Show Source
object-
ActualStartDate: string
(date)
Read Only:
trueActual operation start date. This is the first day that the resource is required for production. -
AlternateNumber: integer
Read Only:
trueAlternate number of the corresponding operation resource. -
AssemblyItemId: integer
(int64)
Read Only:
trueAssembly that uses the resource for the production generating resource requirement. -
AssignedUnits: number
Read Only:
trueNumber of resource units assigned to perform the operation. For example assigned units of 2 means that two of that resource are used. -
CompileDesignator: string
Read Only:
trueMaximum Length:255Name of the plan. -
ConstrDateAdditionalCap: number
Read Only:
trueAdditional capacity required by the resource computed by the planning engine on the resource constraint date. -
ConstrDateResourceCapacity: number
Read Only:
trueTotal capacity required by the resource computed by the planning engine on the resource constraint date. -
ConsumptionStartDate: string
(date)
Read Only:
trueStart date of the next resource requirement in the sequence. If this is the last resource requirement in the supply, then this date is the same as the consumption start date of the supply. -
ContributesDmdLateness: number
Read Only:
trueThis attribute value is Yes, if the Need by Date - Earliest Start Date is less than the lead time of the resource requirement. -
ContributesDmdLatenessCode: string
Read Only:
trueMaximum Length:4000Indicates whether the lead time of the resource requirement is greater than the difference between the need-by date and the earliest start date of the resource in a supply plan. If Yes, then it's greater. If no, then it isn't. The default value is Yes. -
ContributesOverload: number
Read Only:
trueThe resource requirement has this attribute set to Yes if it belongs to a time bucket in which the resource capacity is overloaded. -
ContributesOverloadCode: string
Read Only:
trueMaximum Length:4000Indicates whether the resource requirement belongs to a time bucket in which the resource capacity is overloaded in a supply plan. If Yes, then it does. If no, then it doesn't. The default value is Yes. -
CreatedBy: string
Read Only:
trueMaximum Length:64Indicates the user who created the row. -
CreationDate: string
(date-time)
Read Only:
trueIndicates the date and time of the creation of the row. -
CummulativeQuantity: number
Read Only:
trueIndicates the total resource requirement of the resource. -
DepartmentCode: string
Read Only:
trueMaximum Length:120Value that uniquely identifies the department that the resource belongs to. -
DepartmentId: integer
(int64)
Read Only:
trueDepartment identifier or the work center of the resource. -
Description: string
Read Only:
trueMaximum Length:4000Description of the resource. -
EarliestStartDate: string
(date)
Read Only:
trueEarliest start date for improved exceptions. -
EndDate: string
(date)
Read Only:
trueEnd date of the resource requirement. The resource isn't required after this date. -
ExecutionSequence: number
Read Only:
trueIndicates the execution sequence number of the operation if the work order has resequence operations. -
FirmEndDate: string
(date)
Read Only:
trueEnd date marked as firm so that it doesn't change during replan. -
FirmPlannedType: integer
Read Only:
trueIndicates whether the resource requirement is marked as firm. -
FirmStartDate: string
(date)
Read Only:
trueStart date is marked to be firm. -
FirmStatus: string
Read Only:
trueMaximum Length:4000Description of how a resource requirement is firmed. -
FixedLeadTime: number
Read Only:
trueValue of the Fixed Lead Time. This is used irrespective of the quantity being manufactured. -
HoursExpended: number
Read Only:
trueHours expended on a resource of a job. -
ItemName: string
Read Only:
trueMaximum Length:4000Value that uniquely identifies the assembly item associated with the resource requirement. -
LastUpdateDate: string
(date-time)
Read Only:
trueIndicates the date and time of the last update of the row. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64Indicates the user who last updated the row. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32Indicates the session sign-in associated with the user who last updated the row. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MaterialAvailDate: string
(date)
Read Only:
trueCompletion date of the previous resource requirement in the sequence. If this is the first resource requirement in the supply, then this date is the same as the material available date of the supply. -
MaximumAssignedUnits: number
Read Only:
trueNumber of maximum resource units assigned to perform the operation. -
NeedByDate: string
(date)
Read Only:
trueDate on which a resource requirement should be complete to meet the demand on time. -
NewScheduleDate: string
(date)
Read Only:
trueValue that indicates the new schedule date of the resource requirement demand. -
OperationCost: number
Read Only:
trueValue that indicates the outside processing operation cost. -
OperationSequenceId: integer
Read Only:
trueOperation sequence identifier of the operation where the resource requirement is generated. -
OperationSequenceNumber: integer
Read Only:
trueSequence number of the operation for the resource requirement. -
OrderNumber: string
Read Only:
trueMaximum Length:240Value that uniquely identifies the order number of the supply that generates the resource requirement. -
OrganizationCode: string
Read Only:
trueMaximum Length:4000Indicates the organization identifier. -
OrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the organization that the department resource belongs to. -
OSPOperationType: integer
Read Only:
trueValue that indicates the type of outside processing operation. -
OSPOperationTypeStr: string
Read Only:
trueMaximum Length:4000Descriptive value of the type of resource requirements, whether In-House or Supplier. -
ParentId: integer
(int64)
Read Only:
trueReference to the parent transaction identifier of the resource requirement. -
PlanId: integer
Read Only:
trueValue that uniquely identifies the plan associated with the resource requirements of a resource. -
QuantityInQueue: number
Read Only:
trueNumber of units in the queue of the operation. -
ResourceCode: string
Read Only:
trueMaximum Length:40Identifier of the resource associated with the resource requirement. -
ResourceConstraintDate: string
(date)
Read Only:
trueDate populated by the planning engine process for a bottleneck or resource marked critical because it's constrained. -
ResourceHours: number
Read Only:
trueValue that indicates the resource hours required. -
ResourceId: integer
Read Only:
trueValue that uniquely identifies the resource. -
ResourceSequenceNumber: integer
Read Only:
trueIdentifier of the planned resource sequence for the operation requirement. -
ResourceUOMCode: string
Read Only:
trueMaximum Length:4000Identifier of the unit of measure of the resource. -
RoutingSequenceId: integer
Read Only:
trueRouting sequence identifier for the routing or the work definition. -
SchedulePriority: number
Read Only:
trueOrder priority of the resource requirement. -
ScheduleType: integer
Read Only:
trueSchedule identifier on the resource. If this is set then the resource is used in planning. -
ScheduleTypeCode: string
Read Only:
trueMaximum Length:4000Descriptive value of how the resource requirement is scheduled. -
StartDate: string
(date)
Read Only:
trueStart date of the resource requirement. -
Supplier: string
Read Only:
trueMaximum Length:4000Value that identifies the supplier of an outside processing operation. -
SupplierId: integer
(int64)
Read Only:
trueValue that indicates the unique supplier identifier of an outside processing operation. -
SupplierSite: string
Read Only:
trueMaximum Length:4000Value that uniquely identifies the supplier site of an outside processing operation. -
SupplierSiteId: integer
(int64)
Read Only:
trueValue that indicates the unique supplier site identifier for an outside processing operation in the planning system. -
SupplyId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supply generating the Resource Requirements resource. -
SupplyType: integer
Read Only:
trueValue that indicates the type of supply generating the resource requirement. -
SupplyTypeCode: string
Read Only:
trueMaximum Length:4000Descriptive value of the supply type generating the Resource Requirements resource. -
TimezoneName: string
Read Only:
trueMaximum Length:4000Value that uniquely identifies the time zone. -
TotalResourceHours: number
Read Only:
trueTotal inflated resource hours required for an activity of a job. -
TransactionId: integer
(int64)
Read Only:
trueValue that uniquely identifies a resource requirement entry. -
UnadjustedResourceHours: number
Read Only:
trueResource hours unadjusted for utilization and efficiency. -
UOMCode: string
Read Only:
trueMaximum Length:4000Value that uniquely identifies the unit of measure. -
UsageRate: number
Read Only:
trueRate per assembly or amount per job or schedule. -
VariableLeadTime: number
Read Only:
trueVariable lead time used in conjunction with the quantity of the assembly being manufactured. This is used to compute the duration of the outside processing operation. -
WorkAreaCode: string
Read Only:
trueMaximum Length:120Value that uniquely identifies the work area that the department resource belongs to. -
WorkAreaId: integer
(int64)
Read Only:
trueValue indicates the work area identifier of the department resource. -
Yield: number
Read Only:
trueIndicates the operation yield that uses the resource.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-Resources-item-response
Type:
Show Source
object-
AvailableAllDayIndicator: integer
Read Only:
trueValue that indicates whether the resource is available 24 hours a day or not. Valid values are: 1 or 2. If 1, then resource is available 24 hours a day. If 2, then not. -
AvailableAllDayResource: string
Read Only:
trueMaximum Length:4000Value that indicates whether the resource is available 24 hours a day or not. Valid values are: Yes or No. If Yes, then the resource is available 24 hours a day. If No, then the resource isn't available 24 hours a day. -
Bottleneck: string
Read Only:
trueMaximum Length:4000Value that indicates whether the resource is a bottleneck or not. Valid values are: Yes or No. If Yes, then the resource is a bottleneck. If No, then the resource isn't a bottleneck. -
BottleneckIndicator: integer
Read Only:
trueValue that indicates whether the resource is a bottleneck resource or not. Valid values are: 1 or 2. If 1, then resource is a bottleneck. If 2, then not. -
CapableToPromise: string
Read Only:
trueMaximum Length:4000Indicates whether the Capable to Promise option is enabled while using Oracle Fusion Global Order Promising to promise for the end item or assembly. Valid values are: Yes or No. If Yes, then Capable to Promise is enabled. If No, then Capable to Promise isn't enabled. -
CapacityUnits: number
Read Only:
trueNumber of units of this resource that are available. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the resource. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the resource. -
Critical: integer
(int64)
Read Only:
trueValue that indicates whether the resource is critical to honor resource capacity constraint or not. Valid values are: 1 or 2. If 1, then the resource is critical. If 2, then the resource isn't critical. -
CriticalResource: string
Read Only:
trueMaximum Length:4000Value that indicates whether the resource is critical to honor the resource capacity constraint or not. Valid values are: Yes or No. If Yes, then the resource is critical. If No, then the resource isn't critical. -
CtpIndicator: integer
Read Only:
trueValue that indicates whether the resource is used for Oracle Fusion Global Order Promising Capable to Promise feature or not. Valid values are: 1 or 2. If 1, then resource is used. If 2, then not. -
CurrencyCode: string
Read Only:
trueMaximum Length:4000Code for the currency in which the resource cost is defined. -
DataSecurityEditAllowed: string
Read Only:
trueContains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
DisableDate: string
(date)
Read Only:
trueDate when the resource is no longer available. -
EfficiencyPercent: number
Read Only:
truePercentage of the actual output compared to the expected standard output. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the resource. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the resource. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NotesCount: integer
Read Only:
trueValue that's used to enable Create Note or Manage Notes. Valid values are 1 or 2. If 1, then Create Note is enabled. If 2, Manage Notes is enabled. The default value is 1. -
NotesIndicator: integer
Read Only:
trueCost associated with using the resource. -
NumberOfLineOperations: number
Read Only:
trueCost associated with using the resource. -
Organization: string
Read Only:
trueMaximum Length:4000Abbreviation that identifies the organization. -
OrganizationId: integer
(int64)
Read Only:
trueValue that uniquely identifies the organization. -
ResourceCapacities: array
Resource Capacities
Title:
Resource CapacitiesThe Resource Capacities resource manages how many hours a resource is available for each day. -
ResourceCode: string
Read Only:
trueMaximum Length:40Abbreviation that identifies the resource. -
ResourceCost: number
Read Only:
trueCost associated with using the resource. -
ResourceDescription: string
Read Only:
trueMaximum Length:240Description of the resource. -
ResourceId: integer
(int64)
Read Only:
trueValue that uniquely identifies the resource. -
ResourceName: string
Read Only:
trueMaximum Length:80Name of the resource. -
ResourceType: integer
Read Only:
trueValue that identifies the type of resource. Valid values are 1 or 2. If 1, then the resource is a piece of equipment. If 2, then the resource is a crew. A list of accepted values is defined in the lookup type ORA_MSC_RESOURCE_TYPE. -
ResourceTypeName: string
Read Only:
trueMaximum Length:4000Value that indicates the type of resource. Valid values are Equipment or Crew. -
ResourceUOM: string
Read Only:
trueMaximum Length:3Unit of measure associated with the resource. -
RunRate: number
Read Only:
trueCost associated with using the resource. -
UnitOfMeasureDisplay: string
Read Only:
trueMaximum Length:4000Unit of measure associated with the resource. -
UtilizationPercent: number
Read Only:
truePercentage of how much a resource is utilized. -
WorkAreaCode: string
Read Only:
trueMaximum Length:120Abbreviation that identifies the work area. -
WorkAreaDescription: string
Read Only:
trueMaximum Length:240Description of the work area. -
WorkAreaId: integer
(int64)
Read Only:
trueValue that uniquely identifies the work area. -
WorkAreaName: string
Read Only:
trueMaximum Length:80Name of the work area. -
WorkCenterCode: string
Read Only:
trueMaximum Length:120Abbreviation that identifies the work center. -
WorkCenterDescription: string
Read Only:
trueMaximum Length:240Description of the work center. -
WorkCenterId: integer
(int64)
Read Only:
trueValue that uniquely identifies the work center. -
WorkCenterName: string
Read Only:
trueMaximum Length:80Name of the work center.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Resource Capacities
Type:
arrayTitle:
Resource CapacitiesThe Resource Capacities resource manages how many hours a resource is available for each day.
Show Source
Nested Schema : planInputs-Resources-ResourceCapacities-item-response
Type:
Show Source
object-
AvailabilityDate: string
(date)
Read Only:
trueDate when the resource capacity is available. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the resource capacity. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the resource capacity. -
DailyAvailability: number
Read Only:
trueDaily availability for each capacity unit of the resource. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the resource capacity. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the resource capacity. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-SupplierCapacities-item-response
Type:
Show Source
object-
AslId: integer
Read Only:
trueValue that uniquely identifies the supplier item. -
Capacity: number
Read Only:
trueDaily available capacity for the supplier item. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the supplier capacity. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the supplier capacity. -
FromDate: string
(date)
Read Only:
trueDate when the supplier capacity is available. -
InventoryItemId: integer
(int64)
Read Only:
trueValue that uniquely identifies the item. -
ItemName: string
Read Only:
trueMaximum Length:4000Name of the item. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the supplier capacity. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the supplier capacity. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
SupplierId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supplier. -
SupplierName: string
Read Only:
trueMaximum Length:4000Name of the supplier. -
SupplierSiteCode: string
Read Only:
trueMaximum Length:4000Abbreviation that identifies the supplier site. -
SupplierSiteId: integer
(int64)
Read Only:
trueValue that uniquely identifies the supplier site. -
ToDate: string
(date)
Read Only:
trueDate when the supplier capacity is no longer available.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-SupplierItems-item-response
Type:
Show Source
object-
AslId: integer
Value that uniquely identifies the supplier item.
-
CalendarName: string
Read Only:
trueMaximum Length:240Name of the delivery calendar associated with the supplier item. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the supplier item. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the supplier item. -
Critical: integer
(int32)
Value that indicates whether the item supplier is critical to honor supplier capacity constraint or not. Valid values are: 1 or 2. If 1, then the item supplier is critical. If 2, then the item supplier isn't critical.
-
DeliveryCalendarCode: string
Maximum Length:
25Abbreviation that identifies the delivery calendar associated with the supplier item. -
FixedLotMultiplier: number
Value that's used to calculate the order quantity of a planned order. The order quantity is calculated to be a multiple of this quantity.
-
InventoryItemId: integer
(int64)
Value that uniquely identifies the item.
-
ItemName: string
Read Only:
trueMaximum Length:4000Name of the item. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the supplier item. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the supplier item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MinimumOrderQuantity: number
Minimum quantity that can be ordered.
-
ProcessingLeadTime: integer
Number of days required to procure an item.
-
SupplierId: integer
(int64)
Value that uniquely identifies the supplier.
-
SupplierName: string
Read Only:
trueMaximum Length:4000Name of the supplier. -
SupplierSiteCode: string
Read Only:
trueMaximum Length:4000Abbreviation that identifies the supplier site. -
SupplierSiteId: integer
(int64)
Value that uniquely identifies the supplier site.
-
UOMCode: string
Maximum Length:
3Abbreviation that identifies the unit of measure associated with the supplier item.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source