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:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The 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:
array
Title:
Links
The 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 Resources
The 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 Items
Item structure components that are part of a supply plan. -
Items: array
Items
Title:
Items
Item structure components that are part of a supply plan. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
Operations: array
Operations
Title:
Operations
Operations needed to make an item that are part of a supply plan. -
OutputItems: array
Output Items
Title:
Output Items
Output items that are produced at an operation of a process work definition of a supply plan. -
PlanInputId: integer
Read Only:
true
Value that uniquely identifies the plan inputs. Plan inputs always uses -1 as the identifier. -
PlanInputName: string
Read Only:
true
Maximum Length:10
Name associated with the plan inputs. -
PlanningDemands: array
Planning Demands
Title:
Planning Demands
The 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 Supplies
The 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 Requirements
The resource requirements for resources generated by planning. -
Resources: array
Resources
Title:
Resources
The 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 Capacities
The 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 Items
The Supplier Items resource manages which items are purchased from which suppliers.
Nested Schema : Bill of Resources
Type:
array
Title:
Bill of Resources
The 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:
array
Title:
Component Items
Item structure components that are part of a supply plan.
Show Source
Nested Schema : Items
Type:
array
Title:
Items
Item structure components that are part of a supply plan.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Operations
Type:
array
Title:
Operations
Operations needed to make an item that are part of a supply plan.
Show Source
Nested Schema : Output Items
Type:
array
Title:
Output Items
Output items that are produced at an operation of a process work definition of a supply plan.
Show Source
Nested Schema : Planning Demands
Type:
array
Title:
Planning Demands
The 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:
array
Title:
Planning Supplies
The 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:
array
Title:
Resource Requirements
The resource requirements for resources generated by planning.
Show Source
Nested Schema : Resources
Type:
array
Title:
Resources
The 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:
array
Title:
Supplier Capacities
The 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:
array
Title:
Supplier Items
The 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 Resources
The 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:
true
Maximum Length:240
Description of the assembly item. -
AssemblyItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the assembly item. -
AssemblyItemLevel: string
Read Only:
true
Maximum Length:8
Data load level of the item being produced. Valid values are Item and Category. -
AssemblyItemName: string
Read Only:
true
Maximum Length:300
Name of the assembly item. -
AssemblyQuantity: number
Read Only:
true
Quantity of the item being produced. -
AssemblyUOM: string
Read Only:
true
Maximum Length:4000
Planning unit of measure of the assembly item. -
BasisType: number
Read Only:
true
Value 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:
true
Value that uniquely identifies the bill of resources. -
CatalogId: integer
(int64)
Read Only:
true
Value that uniquely identifies the catalog. -
CatalogName: string
Read Only:
true
Maximum Length:30
Category 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:
true
Value that uniquely identifies the category. -
CategoryName: string
Read Only:
true
Maximum Length:250
Name 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:
true
Maximum Length:3
Planning unit of measure of the category. -
ComponentDescription: string
Read Only:
true
Maximum Length:240
Description of the component item. -
ComponentItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the component item. -
ComponentItemName: string
Read Only:
true
Maximum Length:300
Name of the component item. -
ComponentUOM: string
Read Only:
true
Maximum Length:4000
Planning unit of measure of the component item. -
ComponentUsageQuantity: number
Read Only:
true
Quantity of the item being consumed. -
ConsumptionType: string
Read Only:
true
Maximum Length:8
Type of consumption. This attribute indicates whether an item or resource is being consumed. Valid values are Item and Resource. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the bill of resources. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the user created the bill of resources. -
EffectiveEndDate: string
(date)
Read Only:
true
Date when the component item or resource is no longer available. -
EffectiveStartDate: string
(date)
Read Only:
true
Date when the component item or resource is available. -
FindNumber: integer
Read Only:
true
Number 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:
true
Date and time when the user most recently updated the bill of resources. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the bill of resources. -
LeadTimeOffsetInDays: number
Read Only:
true
Value that indicates the number of days for which the planning engine offsets the consumption of a component or resource. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OptionDependent: integer
(int32)
Read Only:
true
Value 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 Details
In 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:
true
Maximum Length:4000
Abbreviation that identifies the organization associated with the item. -
OrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the organization. -
ResourceCode: string
Read Only:
true
Maximum Length:40
Abbreviation that identifies the resource. -
ResourceId: integer
(int64)
Read Only:
true
Value that uniquely identifies the resource. -
ResourceUOM: string
Read Only:
true
Maximum Length:4000
Unit of measure associated with the resource. -
ResourceUsageQuantity: number
Read Only:
true
Quantity of the resource being consumed. -
SourceOrganization: string
Read Only:
true
Maximum Length:4000
Name of the organization where the component or resource is defined. -
SourceOrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the source organization. -
SubstituteComponents: array
Substitute Components
Title:
Substitute Components
The 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:
true
Maximum Length:120
Abbreviation that identifies the work center. -
WorkCenterId: integer
(int64)
Read Only:
true
Value that uniquely identifies the work center.
Nested Schema : Alternate Resources
Type:
array
Title:
Alternate Resources
The 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:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Option Dependent Resource Details
Type:
array
Title:
Option Dependent Resource Details
In 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:
array
Title:
Substitute Components
The 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:
true
Maximum Length:40
Abbreviation that identifies the alternate resource. -
AlternateResourceId: integer
(int64)
Read Only:
true
Value that uniquely identifies the alternate resource. -
AlternateResourcePriority: number
Read Only:
true
Value that indicates the priority associated with the resource to use as the alternate resource. -
AlternateResourceQuantity: number
Read Only:
true
Value that indicates the quantity of the alternate resource being consumed. -
AlternateResourceUOM: string
Read Only:
true
Maximum Length:4000
Unit of measure associated with the alternate resource. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the alternate resources in the bill of resources. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the user created the alternate resources in the bill of resources. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the alternate resources in the bill of resources. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the alternate resources in the bill of resources. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
WorkCenterCode: string
Read Only:
true
Maximum Length:120
Abbreviation that identifies the work center to which the alternate resource belongs to in the bill of resources. -
WorkCenterId: integer
(int64)
Read Only:
true
Value that uniquely identifies the work center to which the alternate resource belongs to in bill of resources.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed 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:
true
Value that uniquely identifies the assembly item. -
AssemblyItemName: string
Read Only:
true
Maximum Length:255
Name of the assembly item. -
BorId: integer
Read Only:
true
Value that uniquely identifies the bill of resources. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OperationSequenceNumber: number
Read Only:
true
Number 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:
true
Value that uniquely identifies the optional component for the option dependent resource in the bill of resources. -
OptionMemberId: integer
(int64)
Read Only:
true
Value that uniquely identifies the end option item or class in the optional component lineage in the bill of resources. -
OptionMemberLineageNames: string
Read Only:
true
Maximum Length:4000
Ordered list of names for the parent option items or classes of an optional component in the bill of resources. -
OptionMemberName: string
Read Only:
true
Maximum Length:4000
Name of the end option item or class in the optional component lineage in the bill of resources. -
OptionMemberType: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Value that indicates the quantity of the optional component being consumed in the bill of resources. -
Organization: string
Read Only:
true
Maximum Length:255
Abbreviation that identifies the organization associated with the item. -
OrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the organization. -
ResourceCode: string
Read Only:
true
Maximum Length:255
Abbreviation that identifies the resource. -
ResourceId: integer
(int64)
Read Only:
true
Value that uniquely identifies the resource. -
ResourceUsageQuantity: number
Read Only:
true
Quantity of the resource being consumed.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-BillOfResources-SubstituteComponents-item-response
Type:
Show Source
object
-
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the substitute components in the bill of resources. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the user created the substitute components in the bill of resources. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the substitute components in the bill of resources. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the substitute components in the bill of resources. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
SubstituteCompItemPriority: number
Read Only:
true
Value that indicates the priority associated with the component item to use as the substitute component in the bill of resources. -
SubstituteCompItemQty: number
Read Only:
true
Value that indicates the quantity of the substitute component being consumed. -
SubstituteCompItemUOM: string
Read Only:
true
Maximum Length:4000
Unit of measure associated with the substitute component. -
SubstituteComponentItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the component item to use as the substitute component in the bill of resources. -
SubstituteComponentItemName: string
Read Only:
true
Maximum Length:300
Name of the component item to use as the substitute component in the bill of resources.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-ComponentItems-item-response
Type:
Show Source
object
-
AssemblyItem: string
Title:
Assembly Item
Maximum Length:250
Name of the assembly item. -
AssemblyItemDescription: string
Title:
Assembly Item Description
Maximum Length:240
Description of the assembly item. -
AssemblyItemId: integer
Unique identifier of the assembly item.
-
AssemblyItemUOM: string
Title:
Assembly Item UOM
Maximum Length:400
Unit of measure of the assembly item. -
AssemblyItemUOMCode: string
Title:
Assembly Item UOM
Maximum Length:3
Unit of measure code of the assembly item. -
AssemblyQuantity: number
Title:
Assembly Quantity
Quantity of the assembly item. -
Basis: string
Title:
Basis
Read Only:true
Maximum Length:80
Identifies 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:
true
Value 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 Item
Maximum Length:250
Name of the component item being consumed. -
ComponentItemDescription: string
Title:
Component Description
Maximum Length:240
Description of the component item being consumed. -
ComponentItemEffectiveEndDate: string
(date)
Title:
Component Item Effective End Date
Start date of effectivity for this component. -
ComponentItemEffectiveStartDate: string
(date)
Title:
Component Item Effective Start Date
End date of effectivity for this component. -
ComponentItemId: integer
Unique identifier of the component item.
-
ComponentItemUOM: string
Title:
Component UOM
Maximum Length:400
Unit of measure of the component item. -
ComponentItemUOMCode: string
Maximum Length:
3
Unit of measure code of the component item. -
ComponentSequenceId: integer
Value that uniquely identifies the component on the source application instance.
-
ComponentUsageQuantity: number
Title:
Usage Quantity
Quantity of the component to build one unit of item based on the component's primary UOM. -
ComponentYield: number
Title:
Component Yield
Factor used to multiply component quantity with to obtain the total quantity used of a component that actually becomes part of an assembly. -
EnforceIntegerRequirement: string
Title:
Enforce Integer Requirement
Read Only:true
Maximum Length:80
Specifies 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 Number
Number 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 Sequence
Number that indicates the sequence for a component item for a work order operation. -
ItemStructureName: string
Title:
Item Structure Name
Maximum Length:80
Name 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 Date
Read Only:true
Date when the component item was last updated. -
LastUpdatedBy: string
Title:
Last Updated By
Read Only:true
Maximum Length:64
Name of the user who last updated the component item. -
links: array
Links
Title:
Links
The 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:
Notes
Read Only:true
Number of notes associated with this component item. -
OperationSequenceNumber: integer
Title:
Operation Sequence Number
Read Only:true
Order in which the operation occurs. -
Organization: string
Read Only:
true
Maximum Length:255
Name of the organization. -
OrganizationCode: string
Title:
Organization
Maximum Length:49
Organization 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 Percentage
Planning factor for this component as a percentage. -
Primary: string
Title:
Primary
Read Only:true
Maximum Length:80
Indicates 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 Items
Component items substitutes that are part of the item structures of a supply plan. -
SupplyType: string
Title:
Supply Type
Maximum Length:4000
Value 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 Definition
Maximum Length:300
Name of the work definition associated with this item structure.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Substitute Items
Type:
array
Title:
Substitute Items
Component 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 Item
Read Only:true
Name of the assembly item. -
AssemblyItemId: string
Read Only:
true
Unique 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:
true
Value 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 Item
Read Only:true
Name of the component item being consumed. -
ComponentItemId: string
Read Only:
true
Unique identifier of the component item. -
ComponentSequenceId: integer
(int64)
Value that uniquely identifies the component on the source application instance.
-
EnforceIntegerRequirement: string
Title:
Enforce Integer Requirement
Read Only:true
Maximum Length:80
Specifies 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 Number
Read Only:true
Number 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 Date
Read Only:true
Date when the component item was last updated. -
LastUpdatedBy: string
Title:
Last Updated By
Read Only:true
Maximum Length:64
Name of the user who last updated the component item. -
links: array
Links
Title:
Links
The 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 Number
Read Only:true
Order in which the operation occurs. -
Organization: string
Read Only:
true
Name of the organization. -
OrganizationCode: string
Title:
Organization
Read Only:true
Organization 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 Component
Maximum Length:250
Name of the substitute component. -
SubstituteComponentDescription: string
Title:
Substitute Component Description
Maximum Length:240
Description of the substitute component. -
SubstituteComponentId: integer
(int64)
Unique identifier of the substitute component item.
-
SubstituteComponentPriority: integer
Title:
Substitute Component Priority
A numeric value indicating the priority of the object. -
SubstituteComponentQuantity: number
Title:
Substitute Component Quantity
Quantity needed when using a substitute item in place of the original component item. -
SubstituteComponentUOM: string
Title:
Substitute Component UOM
Maximum Length:4000
Unit of measure of the substitute component item. -
SubstituteComponentUOMCode: string
Maximum Length:
3
Unit 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:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-Items-item-response
Type:
Show Source
object
-
ABCClass: string
Read Only:
true
Maximum Length:40
Code 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:
true
Number 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. -
AnnualCarryingCostPercentage: number
Read Only:
true
Percent of unit cost that represents the internal cost to stock one unit for one year. -
ATPComponents: string
Read Only:
true
Maximum Length:1
Value 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:
true
Maximum Length:4000
Indicates 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:
true
Value 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:
4000
Value 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:
true
Average time, expressed in days, between intervals. -
BackToBack: string
Maximum Length:
4000
Value 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:
true
Value 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:
true
Maximum Length:4000
Value that uniquely identifies the model to use when creating an assemble-to-order configuration. -
BuildInWIP: string
Maximum Length:
4000
Value 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:
true
Contains 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:
true
Maximum Length:240
Name of the buyer associated with the item. -
CalculateATPIndicator: integer
Read Only:
true
Value 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:
4000
Value 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. -
Category: string
Title:
Category
Read Only:true
Maximum Length:4000
Category 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:
true
Maximum Length:4000
Description associated with a product category. -
CategoryId: integer
Read Only:
true
Value that uniquely identifies an item category. -
ConsiderInClearToBuild: string
Read Only:
true
Maximum Length:1
Value 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:
4000
Value 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:
true
Maximum Length:64
User who created the item. -
CreateSupply: integer
Read Only:
true
Value 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:
true
Date after which supplies can be created. This attribute is editable only when the CreateSupply attribute is set to 1. -
CreateSupplyMeaning: string
Maximum Length:
4000
Value 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:
true
Date and time when the user created the supplier item. -
CriticalComponent: integer
Read Only:
true
Value 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:
4000
Value 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:
true
Number 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:
true
Maximum Length:30
Value that indicates the currency associated with the item's price and cost. -
DataSecurityEditAllowed: string
Read Only:
true
Maximum Length:255
Contains 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:
true
Number 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:
true
Period 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:
true
Abbreviation 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:
true
Date before which forecast demand is ignored. -
DemandTimeFenceDays: integer
Read Only:
true
Time horizon, expressed in number of days, within which forecast demand is ignored. -
DemandTimeFenceType: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Maximum Length:240
Description of the item. -
DiscountPercentage: number
Read Only:
true
Average discount for the item. -
EnforcePurchasingLeadTime: integer
(int32)
Read Only:
true
Value 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:
4000
Value 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:
true
Time horizon, expressed in number of days, after which inventory is considered excess. -
FixedDaysOfSupply: number
Read Only:
true
Number of days to use to modify the size and timing of each planned order quantity. -
FixedLeadTime: number
Read Only:
true
Number 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:
true
Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate. -
FixedOrderQuantity: number
Read Only:
true
Quantity to use to modify the size of each planned order quantity or each repetitive daily rate. -
ForecastControl: string
Read Only:
true
Maximum Length:4000
Value that indicates how the forecast is exploded and consumed. This attribute isn't currently used. -
ForecastErrorType: string
Read Only:
true
Maximum Length:30
Value 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:
true
Maximum Length:4000
Meaning associated with the ForecastErrorType Code attribute. -
ForecastName: string
Read Only:
true
Maximum Length:4000
Name of the forecast used for safety stock calculation. -
HardPeggingLevel: string
Read Only:
true
Maximum Length:25
Value 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:
true
Maximum Length:4000
Meaning associated with the HardPeggingLevel attribute. -
IntermittentDemand: number
Read Only:
true
Value 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:
true
Maximum Length:4000
Indicates whether the demand has an irregular frequency. Valid values are Yes and No. -
InventoryItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the item. -
ItemCostUOM: string
Read Only:
true
Maximum Length:4000
Unit of measure associated with an item's cost. -
ItemName: string
Read Only:
true
Maximum Length:255
Name of the item. -
ItemStructureType: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Date and time when the user most recently updated the item. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User most recently updated the item. -
LeadTimeLotSize: number
Read Only:
true
Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate. -
LifeCyclePhase: string
Read Only:
true
Maximum Length:120
Name of lifecycle phase of the item. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
LotControl: string
Read Only:
true
Maximum Length:4000
Meaning 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:
true
Value 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:
true
Maximum Length:4000
Meaning 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:
true
Value 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:
true
Maximum Length:4000
Value 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:
true
Maximum order quantity of the item. -
MinimumOrderQuantity: number
Read Only:
true
Minimum order quantity of the item. -
NetSellingPrice: number
Selling price of an item after applying an average discount to the item's list price.
-
ObsolescenceDate: string
(date)
Read Only:
true
Date when the item is obsolete. -
OrderCost: number
Read Only:
true
Fixed costs that are associated with placing a sales order for the item. -
OrderModifierToStartQuantity: integer
Read Only:
true
Value 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:
true
Maximum Length:4000
Value 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:
true
Maximum Length:49
Abbreviation that identifies the organization associated with the item. -
OrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the organization. -
PickComponents: integer
Read Only:
true
Value 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:
4000
Value 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:
true
Type 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:
true
Maximum Length:10
Abbreviation that identifies the planner responsible for the item. -
PlannerDescription: string
Read Only:
true
Maximum Length:4000
Description of the planner responsible for the item. -
PlanningMethod: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Abbreviation 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:
true
Abbreviation 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:
true
Date before which orders aren't rescheduled. -
PlanningTimeFenceDays: integer
Read Only:
true
Time horizon, in number of days, in which supply orders aren't scheduled to be due. -
PlanningTimeFenceType: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Number of days required to make an item available in inventory once the supply is complete. -
PreprocessingLeadTime: number
Read Only:
true
Number of days which must be added to purchasing or manufacturing lead time to place an order. -
ProcessingLeadTime: number
Read Only:
true
Number of days required to procure or manufacture an item. -
ReleaseTimeFenceCode: integer
Read Only:
true
Abbreviation 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:
true
Date before which orders are automatically released as work orders or purchase requisitions. -
ReleaseTimeFenceDays: integer
Read Only:
true
Time horizon, in number of days, in which orders are automatically released as work orders or purchase requisitions. -
ReleaseTimeFenceType: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Value 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:
4000
Value 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:
true
Value 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:
true
Maximum Length:4000
Demand plan that contains the forecast and forecast error measures that the plan uses to calculate safety stock. -
SafetyStockPlanningMethod: string
Read Only:
true
Maximum Length:4000
Meaning associated with the SafetyStockCode attribute. -
SafetyStockQuantity: number
Read Only:
true
Desired level of safety stock of an item. -
SellingPrice: number
Read Only:
true
Selling price of the item. -
ServiceLevelPercentage: number
Read Only:
true
Desired 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:
true
Average amount of material you expect to lose when manufacturing or storing the item. -
StandardCost: number
Read Only:
true
Standard cost of an item. -
SupplyType: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Volume of one item. -
UnitWeight: number
Read Only:
true
Weight of one item. -
UOM: string
Read Only:
true
Maximum Length:4000
Planning unit of measure of the item. -
UseUpDate: string
(date)
Read Only:
true
Date when the current on-hand quantity for an item is exhausted based on projected gross requirements. -
VariableLeadTime: number
Read Only:
true
Time to produce one unit of an assembly. -
VolumeUOMName: string
Read Only:
true
Maximum Length:4000
Unit of measure to use for the item volume. -
WeightUOMName: string
Read Only:
true
Maximum Length:4000
Unit of measure to use for the item weight.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-Operations-item-response
Type:
Show Source
object
-
ChangeIndicatorFlag: boolean
Read Only:
true
Value 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. -
FixedLeadTime: number
Title:
Fixed Lead Time
Days required to produce a batch of an assembled item. -
Item: string
Title:
Item
Maximum Length:250
Name of the item being made in the operation. -
ItemId: integer
(int64)
Value that uniquely identifies the item.
-
LastUpdateDate: string
(date-time)
Title:
Last Updated Date
Read Only:true
Indicates the date and time of the last update of the row. -
LastUpdatedBy: string
Title:
Last Updated By
Read Only:true
Maximum Length:64
Indicates the user who last updated the row. -
LineCode: string
Title:
Line Code
Read Only:true
Maximum Length:120
Code 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 Sequence
Read Only:true
Stage where the material is consumed on a production line. -
LineRate: number
Title:
Line Rate
Read Only:true
Hourly rate of the production line. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MinimumTransferQuantity: number
Title:
Minimum Transfer Quantity
Minimum 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:
Notes
Read Only:true
Number of notes associated with this operation. -
NumberOfLineOperations: integer
Title:
Number of Operations
Read Only:true
Identifies the number of operations on a production line. -
OperationCost: number
Title:
Operation Cost
Value that indicates the outside processing operation cost. -
OperationDescription: string
Title:
Operation Description
Maximum Length:240
Operation Description -
OperationEffectiveEndDate: string
(date)
Title:
Operation Effective End Date
Operation Effective End Date -
OperationEffectiveStartDate: string
(date)
Title:
Operation Effective Start Date
Operation Effective Start Date -
OperationResources: array
Operation Resources
Title:
Operation Resources
Resources, 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 Number
Number that identifies the execution sequence of the operation. -
OperationType: string
Title:
Operation Type
Maximum Length:80
Operation Type -
OperationYield: number
Title:
Operation Yield
Operation Yield -
OrganizationCode: string
Title:
Organization
Maximum Length:49
Indicates 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 Percentage
Percentage of time a component item or option will be used within a parent model or a product family. -
Primary: string
Title:
Primary
Read Only:true
Maximum Length:255
Indicates whether the related object is the primary object. For example, whether a routing is the primary routing. -
ProcessName: string
Title:
Process Name
Maximum Length:120
Name 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:
Supplier
Read Only:true
Maximum Length:4000
Name of the supplier in the demand exception. -
SupplierId: integer
(int64)
Value that uniquely identifies the supplier.
-
SupplierSite: string
Title:
Supplier Site
Read Only:true
Maximum Length:4000
Name 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 Time
Days required to produce one unit of an assembled item that will be incurred for each item being made. -
WorkDefinitionDescription: string
Title:
Work Definition Description
Maximum Length:960
Description of a work definition for an item. -
WorkDefinitionName: string
Title:
Work Definition
Maximum Length:300
Work Definition -
WorkMethod: string
Title:
Work Method
Read Only:true
Maximum Length:255
Type of manufacturing used for the production process. Valid values are Discrete Manufacturing and Process Manufacturing.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Operation Resources
Type:
array
Title:
Operation Resources
Resources, 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 Resource
Read Only:true
Maximum Length:255
Indicates whether the resource is an alternate, nonprimary resource. Value values are Yes and No. -
AssignedUnits: integer
Title:
Assigned Units
Number of units assigned to a resource. -
Basis: string
Title:
Basis
Read Only:true
Maximum Length:255
Identifies whether component item usage is based on the quantity of an item produced or for the entire lot. -
BasisCode: integer
Title:
Basis
Identifies whether component item usage is based on the quantity of an item produced or for the entire lot. -
ChangeIndicatorFlag: boolean
Read Only:
true
Value 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 By
Read Only:true
Maximum Length:64
Indicates the user who last updated the row. -
LastUpdatedDate: string
(date-time)
Title:
Last Updated Date
Read Only:true
Indicates the date and time of the last update of the row. -
links: array
Links
Title:
Links
The 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 Resource
Maximum Length:40
Name of the primary resource for which a specific resource is an alternate. -
PrimaryResourceId: integer
(int64)
Title:
Primary Resource
Unique identifier of the primary resource for which a specific resource is an alternate. -
PrincipalResource: string
Title:
Principal Resource
Read Only:true
Maximum Length:255
Indicates whether a resource is a main resource or not. Valid Values are Yes and No. -
Priority: integer
Title:
Priority
A numeric value indicating the priority of the object. -
Resource: string
Title:
Resource
Maximum Length:72
Code used to identify a resource. For example, a resource can be a piece of equipment. -
ResourceCost: number
Title:
Resource Cost
Cost associated with a resource. -
ResourceId: integer
(int64)
Value that uniquely identifies the resource.
-
ResourceSequence: integer
Title:
Resource Sequence
Number 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 UOM
Read Only:true
Maximum Length:4000
Unit 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 Type
Maximum Length:80
Indicates 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:
Usage
Amount of a resource that's needed, usually expressed in hours. -
WorkArea: string
Title:
Work Area
Maximum Length:120
Name of the work area. -
WorkCenter: string
Title:
Work Center
Maximum Length:120
Work center name of the resource.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-OutputItems-item-response
Type:
Show Source
object
-
AssemblyItem: string
Title:
Assembly Item
Read Only:true
Maximum Length:300
Name of the assembly item. -
AssemblyItemId: integer
Read Only:
true
Unique identifier of the assembly item. -
BatchQuantity: number
Title:
Batch Quantity
Read Only:true
Quantity of the production batch used for batch sizing and scaling. -
BatchQuantityUOM: string
Title:
Batch Quantity UOM
Read Only:true
Maximum Length:4000
Unit of measure of the output item batch quantity. -
BatchQuantityUOMCode: string
Read Only:
true
Maximum Length:3
Unit of measure code of the output item batch quantity. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the output item. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the user created the output item. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date when the output item was most recently updated. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the output item. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OperationSequenceId: integer
Read Only:
true
Unique identifier of the operation sequence. -
OperationSequenceNumber: integer
Title:
Operation Sequence Number
Read Only:true
Number that identifies the execution sequence of the operation. -
Organization: string
Title:
Organization
Read Only:true
Maximum Length:255
Organization name of the output item. -
OrganizationCode: string
Title:
Organization
Read Only:true
Maximum Length:4000
Organization code of the output item. -
OrganizationId: integer
(int64)
Read Only:
true
Unique identifier of the organization. -
OutputItem: string
Title:
Output Item
Read Only:true
Maximum Length:300
Item produced at various operations of a process work definition. -
OutputItemId: integer
(int64)
Read Only:
true
Unique identifier of the output item. -
OutputQuantity: number
Title:
Output Quantity
Read Only:true
Quantity of the output item. -
OutputQuantityUOM: string
Title:
Output Item UOM
Read Only:true
Maximum Length:4000
Unit of measure of the output item quantity. -
OutputQuantityUOMCode: string
Read Only:
true
Maximum Length:3
Unit of measure code of the output item quantity. -
OutputTypeCode: integer
(int64)
Title:
Output Type
Read Only:true
Code 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 Type
Read Only:true
Maximum Length:255
Type 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:
true
Value that uniquely identifies the plan. -
WorkDefinitionName: string
Title:
Work Definition
Read Only:true
Maximum Length:300
Name of the work definition associated with the output item.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-PlanningDemands-item-response
Type:
Show Source
object
-
AllowSplits: integer
Read Only:
true
Value 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:
true
Value 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:
true
Maximum Length:30
A 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:
true
Maximum Length:80
Number that identifies the asset associated with a maintenance work order. -
BucketType: string
Read Only:
true
Time 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:
true
Maximum Length:240
Name of the buyer associated with the item. -
CategoryName: string
Title:
Category
Read Only:true
Maximum Length:4000
Name of the category to which the item is assigned. -
CompletedQuantity: number
Read Only:
true
Shipped quantity of the sales order. -
ComponentQuantityIssued: number
Read Only:
true
Quantity of a component issued to a work order. -
ConfigurationItem: string
Read Only:
true
Maximum Length:4000
Name of the configuration item. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the order. -
CreationDate: string
(date-time)
Read Only:
true
Date when the user created the order. -
Customer: string
Read Only:
true
Maximum Length:4000
Name of the customer associated with the sales order or forecast. -
CustomerId: integer
(int64)
Read Only:
true
Value that uniquely identifies the customer. -
CustomerPOLineNumber: string
Read Only:
true
Maximum Length:50
Value that uniquely identifies the customer site. -
CustomerPONumber: string
Read Only:
true
Maximum Length:240
Value that uniquely identifies the item. -
CustomerPOScheduleNumber: string
Read Only:
true
Maximum Length:50
Value that uniquely identifies the organization. -
CustomerSite: string
Read Only:
true
Maximum Length:4000
Code associated with a specific customer ship-to location. -
CustomerSiteId: integer
(int64)
Read Only:
true
Value that uniquely identifies the customer site. -
DataSecurityEditAllowed: string
Read Only:
true
Contains 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:
true
Delivery cost per unit. -
DeliveryLeadTime: number
Read Only:
true
Number of days required to deliver the order to the customer. -
DemandClass: string
Read Only:
true
Maximum Length:34
Classification 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:
true
Maximum Length:4000
Code 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:
true
Priority of the demand. -
DestinationTimeZone: string
Read Only:
true
Maximum Length:400
Time 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:
true
Date when the customer can accept the order to arrive at the earliest. -
EarliestAcceptableShipDate: string
(date)
Read Only:
true
Date 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:
true
Contains 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:
true
Contains 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:
true
Date 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:
true
Value 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:
true
Fixed 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:
true
Maximum Length:4000
Status 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:
true
Estimated cost to deliver a fulfillment line to a customer. The amount includes item cost and shipping cost. -
FulfillmentLine: number
Read Only:
true
Fulfillment line number associated with a sales order. -
GOPReferenceId: string
Read Only:
true
Maximum Length:300
Value that uniquely identifies the cross reference of the recommended split fulfillment line created by Oracle Global Order Promising Cloud. -
IncludedItemsIndicator: integer
Read Only:
true
Value 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:
true
Value that uniquely identifies the item. -
Item: string
Read Only:
true
Maximum Length:300
Name of the item associated with the demand. -
ItemDescription: string
Read Only:
true
Maximum Length:240
Description of the item associated with the demand. -
ItemSubTypeCode: string
Read Only:
true
Maximum Length:30
Abbreviation 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:
true
Maximum Length:30
Abbreviation 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:
true
Date when the demand was most recently updated. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the demand. -
LatestAcceptableArrivalDate: string
(date)
Read Only:
true
Date when the customer can accept the order to arrive at the latest. -
LatestAcceptableDate: string
(date)
Read Only:
true
Date beyond which the demand line must not be promised. -
LatestAcceptableShipDate: string
(date)
Read Only:
true
Date when the customer can accept the order to be shipped at the latest. -
LineNumber: string
Read Only:
true
Maximum Length:150
Line number associated with the demand. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
Lot: string
Read Only:
true
Maximum Length:80
Number that identifies the lot of the on-hand supply. -
MinimumPercentageForSplit: number
Read Only:
true
If splits are allowed, this attribute specifies the minimum percentage required for splitting a fulfillment line. -
MinimumQuantityForSplit: number
Read Only:
true
If splits are allowed, this attribute specifies the minimum quantity required for splitting a fulfillment line. -
MinimumRemainingShelfLife: number
Read Only:
true
Minimum 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. -
OldDueDate: string
(date)
Read Only:
true
Date when the demand quantity was originally due. This attribute value is extracted from the source application. -
OrderDateType: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Value 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:
true
Value 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:
true
Maximum Length:4000
Order number associated with the sales order. -
OrderQuantity: number
Read Only:
true
Quantity associated with the demand. -
OrderType: integer
Read Only:
true
Abbreviation that identifies the type of order. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE. -
OrderTypeText: string
Read Only:
true
Maximum Length:4000
Value 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:
true
Maximum Length:49
Name of the organization associated with the order. -
OrganizationId: integer
Read Only:
true
Value that uniquely identifies the organization. -
OrganizationTimeZone: string
Read Only:
true
Maximum Length:400
Time zone of the organization associated with the demand. -
OrgCurrencyCode: string
Read Only:
true
Maximum Length:4000
Abbreviation that identifies the base currency of the organization. -
OriginalItem: string
Read Only:
true
Maximum Length:4000
Name of the item for which the order was originally scheduled. -
OriginalItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the requested item. -
OriginalOrderQuantity: number
Read Only:
true
Quantity associated with the order. This value is extracted from the source application. -
ParentFulfillmentLine: string
Read Only:
true
Maximum Length:400
For an order with assemble-to-order elements, this attribute indicates the immediate parent of an assemble-to-order component. -
ParentModel: string
Read Only:
true
Maximum Length:4000
Model 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:
true
Date 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:
true
Maximum Length:10
Abbreviation that identifies the planner responsible for the item. -
PlannerDescription: string
Read Only:
true
Maximum Length:4000
Description of the planner responsible for the item. -
PlanningAttributes: array
Planning Attributes
Title:
Planning Attributes
The Planning Attributes resource manages the attribute-based planning attributes associated with a demand or supply. -
ProjectGroupValue: string
Read Only:
true
Maximum Length:4000
Value that identifies the project group. -
ProjectValue: string
Read Only:
true
Maximum Length:4000
Value that identifies the project. -
PromisedArrivalDate: string
(date)
Read Only:
true
Date when a customer has been promised the delivery of the order. -
PromisedShipDate: string
(date)
Read Only:
true
Date when a customer has been promised the shipping of the order. -
PromisingSystem: string
Read Only:
true
Maximum Length:50
Name of the promising application that promises supply for the demand. -
RequestedArrivalDate: string
(date)
Read Only:
true
Date when the material must arrive at the customer site. -
RequestedShipDate: string
(date)
Read Only:
true
Date when the material must be shipped out to the customer. -
RootFulfillmentLine: string
Read Only:
true
Maximum Length:400
For an order having assemble-to-order elements, this attribute indicates the top-most model. -
SalesRepresentativeContact: string
Read Only:
true
Maximum Length:50
Contact details of the sales representative. -
ScheduledArrivalDate: string
(date)
Read Only:
true
Date when the demand has been scheduled to arrive at a customer site. -
ScheduledShipDate: string
(date)
Read Only:
true
Date when the demand has been scheduled to be shipped. -
ScheduleName: string
Read Only:
true
Maximum Length:4000
Name of the supply or demand schedule associated with an order. -
SellingPrice: number
Read Only:
true
Selling price of an item on the order line. -
ShipmentSetName: string
Read Only:
true
Maximum Length:50
On the sales order, the ship set name designates lines that should ship together. -
ShipMethod: string
Read Only:
true
Maximum Length:30
Value 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:
true
Maximum Length:4000
Value 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:
true
Maximum Length:1200
Value that indicates the shipping preference for the order. -
ShipTo: string
Read Only:
true
Maximum Length:4000
Abbreviation that identifies the specific ship-to location. -
SourceOrder: string
Read Only:
true
Maximum Length:240
Value that identifies the order number in the source application against which fulfillment line has been created. -
SourceOrderLine: string
Read Only:
true
Maximum Length:150
Value that identifies the order line number in the source application against which fulfillment line has been created. -
SourceOrganization: string
Read Only:
true
Maximum Length:4000
Name of the organization that will source the order. -
SourceOrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the source organization. -
SourceTablePrimary: string
Read Only:
true
Maximum Length:13
Value that identifies the data table source of the supply. -
SourceTimeZone: string
Read Only:
true
Maximum Length:400
Time zone associated with the entity that's sourcing the order. The sourcing entity can be a supplier or an organization. -
Subinventory: string
Read Only:
true
Maximum Length:10
Subinventory code associated with the demand. -
SuggestedDueDate: string
(date)
Read Only:
true
Date when the demand is recommended to be completed. -
SuggestedShipDate: string
(date)
Read Only:
true
Date when the order is recommended to be shipped. -
Supplier: string
Read Only:
true
Maximum Length:4000
Name of the source supplier. -
SupplierId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supplier. -
SupplierSite: string
Read Only:
true
Maximum Length:4000
Abbreviation that indicates the specific supplier ship-from location. -
SupplierSiteId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supplier site. -
SupplierSiteSourceSystem: integer
Read Only:
true
For drop ship sales orders, the source application for which the supplier site is defined. -
TaskValue: string
Read Only:
true
Maximum Length:4000
Value that identifies task. -
TransactionId: integer
(int64)
Read Only:
true
Value that uniquely identifies the demand. This value is internally generated by the application. -
UOM: string
Read Only:
true
Maximum Length:4000
Name of the unit of measure that's associated with the order quantity. -
UOMCode: string
Read Only:
true
Maximum Length:3
Abbreviation that identifies the unit of measure associated with the order quantity. -
UsingAssembly: string
Read Only:
true
Maximum Length:4000
For component demands, this field refers to the assembly item that uses this item as a component. -
Zone: string
Read Only:
true
Maximum Length:4000
Region or zone where the demand quantity is being shipped.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Planning Attributes
Type:
array
Title:
Planning Attributes
The 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:
Links
The link relations associated with the resource instance. -
OrderNumber: string
Title:
Order Number
Maximum Length:4000
Number that identifies the order associated with the demand or supply. -
PlanningAttributeNumber10: string
Maximum Length:
4000
Value for the planning attribute number 10 in attribute-based planning. -
PlanningAttributeNumber11: string
Maximum Length:
4000
Value for the planning attribute number 11 in attribute-based planning. -
PlanningAttributeNumber12: string
Maximum Length:
4000
Value for the planning attribute number 12 in attribute-based planning. -
PlanningAttributeNumber13: string
Maximum Length:
4000
Value for the planning attribute number 13 in attribute-based planning. -
PlanningAttributeNumber14: string
Maximum Length:
4000
Value for the planning attribute number 14 in attribute-based planning. -
PlanningAttributeNumber15: string
Maximum Length:
4000
Value for the planning attribute number 15 in attribute-based planning. -
PlanningAttributeNumber3: string
Maximum Length:
4000
Value for the planning attribute number 3 in attribute-based planning. -
PlanningAttributeNumber4: string
Maximum Length:
4000
Value for the planning attribute number 4 in attribute-based planning. -
PlanningAttributeNumber5: string
Maximum Length:
4000
Value for the planning attribute number 5 in attribute-based planning. -
PlanningAttributeNumber6: string
Maximum Length:
4000
Value for the planning attribute number 6 in attribute-based planning. -
PlanningAttributeNumber7: string
Maximum Length:
4000
Value for the planning attribute number 7 in attribute-based planning. -
PlanningAttributeNumber8: string
Maximum Length:
4000
Value for the planning attribute number 8 in attribute-based planning. -
PlanningAttributeNumber9: string
Maximum Length:
4000
Value 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:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-PlanningSupplies-item-response
Type:
Show Source
object
-
ActualStartDate: string
(date)
Read Only:
true
Date when the work was started, which applies to work orders in process. -
AlternateBOMDesignator: string
Read Only:
true
Maximum Length:80
Name of the alternate bill of material. -
AlternateRoutingDesignator: string
Read Only:
true
Maximum Length:30
Name of a routing used for the make order. -
AssetNumber: string
Read Only:
true
Maximum Length:80
Number that identifies the asset associated with a maintenance work order. -
BatchQuantity: number
Read Only:
true
Quantity that moves through operations in a process work order. -
BatchUOM: string
Read Only:
true
Maximum Length:3
Unit of measure for the batch quantity in a process work order. -
BmtOption: integer
Read Only:
true
Contains 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:
true
Maximum Length:240
Name of the buyer associated to the item. -
BuyerManagedTransportation: string
Read Only:
true
Maximum Length:400
Contains 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:
true
Value that indicates whether the supply has been canceled. -
CanceledText: string
Read Only:
true
Maximum Length:4000
Value 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:
Category
Read Only:true
Maximum Length:4000
Name of the category to which the item is assigned. -
CompletedQuantity: number
Read Only:
true
Quantity of the work order that's already completed. -
ComponentQuantityIssued: number
Read Only:
true
Quantity of a component issued to a work order. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the order. -
CreationDate: string
(date-time)
Read Only:
true
Date when the user created the order. -
CumulativeYield: number
Read Only:
true
Name 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:
true
Maximum Length:400
Name of the customer associated with the drop ship purchase order. -
CustomerSite: string
Read Only:
true
Maximum Length:400
Code associated with a specific customer ship-to location. -
DataSecurityEditAllowed: string
Read Only:
true
Contains 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:
true
Supply unit price for purchased supply. -
DestinationTimeZone: string
Read Only:
true
Maximum Length:400
Time zone associated with the entity that's receiving the order. The destination entity can be a customer or an organization. -
DestinationType: string
Read Only:
true
Maximum Length:400
Value 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:
true
Maximum Length:400
Number that uniquely identifies the customer whose demand is being met through the drop ship supply. -
DropShipCustomerSite: string
Read Only:
true
Maximum Length:400
Customer site to which the drop ship supply must be shipped to meet the demand. -
DropShipDestType: integer
Read Only:
true
Code 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:
true
Quantity of the work order or planned order that's expected to be scrapped in addition to the quantity already scrapped. -
ExpenseDestinationTransfer: string
Read Only:
true
Maximum Length:400
Contains 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:
true
Contains 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:
true
Date when the existing lot associated with the supply expires. -
FgOrderType: integer
Read Only:
true
Value 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:
true
Date 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:
true
Value 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:
true
Fixed 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:
true
User-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:
true
Maximum Length:400
Status 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:
true
Date on which the on-hand inventory lot is no longer on hold. -
InventoryItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the item. -
Item: string
Read Only:
true
Maximum Length:300
Name of the item associated with the supply. -
ItemDescription: string
Read Only:
true
Maximum Length:240
Description of the item that's associated with the supply. -
ItemStructureName: string
Read Only:
true
Maximum Length:400
Name of the item structure planned to be used for the make order. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date when the order was most recently updated. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the supply. -
LineNumber: string
Read Only:
true
Maximum Length:400
Number that identifies the order line. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
Lot: string
Read Only:
true
Maximum Length:80
Number that identifies the lot of the on-hand supply. -
MakeOrBuy: string
Read Only:
true
Maximum Length:400
Value 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:
true
Date when an inventory lot fully matures. It can then be used to fulfill demand. -
NeedByDate: string
(date)
Read Only:
true
Date when the supply quantity is needed. -
OldDockDate: string
(date)
Read Only:
true
Date 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:
true
Date when the order was originally due. This attribute value is extracted from the source application. -
OrderNumber: string
Read Only:
true
Maximum Length:400
Number that identifies the order associated with the supply. -
OrderQuantity: number
Read Only:
true
Quantity associated with the supply. -
OrderStatus: string
Read Only:
true
Maximum Length:200
SCM 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:
true
Abbreviation that identifies the type of order. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE. -
OrderTypeText: string
Read Only:
true
Maximum Length:400
Type 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:
true
Maximum Length:49
Name of the organization associated with the order. -
OrganizationId: integer
Read Only:
true
Value that uniquely identifies the organization. -
OrganizationTimeZone: string
Read Only:
true
Maximum Length:400
Time zone associated with an organization. -
OriginalNeedByDate: string
(date)
Read Only:
true
Date when the order was originally needed. This value is extracted from the source application. -
OriginalOrderQuantity: number
Read Only:
true
Original quantity associated with the order. This value is extracted from the source application. -
Planner: string
Read Only:
true
Maximum Length:10
Abbreviation that identifies the planner responsible for the item. -
PlannerDescription: string
Read Only:
true
Maximum Length:400
Description of the planner responsible for the item. -
PlanningAttributes: array
Planning Attributes
Title:
Planning Attributes
The Planning Attributes resource manages the attribute-based planning attributes associated with a demand or supply. -
PlanningMakeBuyCode: integer
Read Only:
true
Abbreviation 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:
true
Maximum Length:120
Name of the manufacturing process used for this work order or planned order. -
ProjectGroupValue: string
Read Only:
true
Maximum Length:400
Value that identifies the project group. -
ProjectValue: string
Read Only:
true
Maximum Length:400
Value that identifies the project. -
PromisedArrivalDate: string
(date)
Read Only:
true
Date when a customer has been promised the delivery of the order. -
PromisedShipDate: string
(date)
Read Only:
true
Date when a customer has been promised the shipping of the order. -
ReceiptNumber: string
Read Only:
true
Maximum Length:30
Number that identifies the receipt of the transfer order. -
RemainingQuantity: number
Read Only:
true
Work order quantity that remains to be completed. -
RequestedArrivalDate: string
(date)
Read Only:
true
Date when the material must arrive at the customer site. -
RequestedShipDate: string
(date)
Read Only:
true
Date when the material must be shipped out to the customer. -
Revision: string
Read Only:
true
Maximum Length:10
Abbreviation that identifies the revision of the inventory item. -
ScheduleLineNumber: string
Read Only:
true
Maximum Length:30
Number that identifies the purchase order line location information for collection at the schedule level. -
ScheduleName: string
Read Only:
true
Maximum Length:10
Name of the schedule associated to the supply. -
SchedulePriority: number
Read Only:
true
Value that identifies the priority of the work order. -
ScrappedQuantity: number
Read Only:
true
Work order quantity that has been scrapped. -
ShipmentHeaderNumber: string
Read Only:
true
Maximum Length:30
Number that identifies the shipment header of the transfer order. -
ShipmentLineNumber: string
Read Only:
true
Maximum Length:30
Number that identifies the shipment line of the transfer order. -
ShipMethod: string
Read Only:
true
Maximum Length:30
Value 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:
true
Maximum Length:400
Value 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:
true
Maximum Length:400
Name of the organization that will source the order. -
SourceOrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the source organization. -
SourceSubinventoryCode: string
Read Only:
true
Maximum Length:10
Abbreviation that identifies the subinventory associated with the source of the supply. -
SourceTablePrimary: string
Read Only:
true
Maximum Length:13
Value that identifies the data table source of the supply. -
SourceTimeZone: string
Read Only:
true
Maximum Length:400
Time zone associated with the entity that's sourcing the order. The sourcing entity can be a supplier or an organization. -
StartQuantity: number
Read Only:
true
Quantity at the beginning of a manufacturing process. -
Subinventory: string
Read Only:
true
Maximum Length:10
Subinventory code associated with the supply. -
SuggestedCompletionDate: string
(date)
Read Only:
true
Date 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:
true
Date when the order is recommended to arrive at the receiving dock. -
SuggestedDueDate: string
(date)
Read Only:
true
Date when a supply is expected to be completed. -
SuggestedOrderDate: string
(date)
Read Only:
true
Date when an order is recommended to be placed. -
SuggestedShipDate: string
(date)
Read Only:
true
Date when the order is recommended to be shipped. -
SuggestedStartDate: string
(date)
Read Only:
true
Date when work on the order is recommended to begin. -
Supplier: string
Read Only:
true
Maximum Length:400
Name of the source supplier. -
SupplierId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supplier. -
SupplierSite: string
Read Only:
true
Maximum Length:400
Abbreviation that indicates the specific supplier location from where the item is being sourced. -
SupplierSiteId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supplier site. -
TaskValue: string
Read Only:
true
Maximum Length:400
Value that identifies task. -
TransactionId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supply transaction. This value is internally generated by the application. -
Undercompleted: integer
Read Only:
true
Contains 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:
true
Maximum Length:4000
Contains 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:
true
Maximum Length:30
Number 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:
true
Maximum Length:400
Name of the unit of measure associated with the order quantity. -
UOMCode: string
Read Only:
true
Maximum Length:3
Abbreviation that identifies the unit of measure associated with the order quantity. -
WIPStatusCode: integer
Read Only:
true
Abbreviation 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:
true
Type 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:
true
Maximum Length:400
Name that uniquely identifies a work definition used for a make order. -
WorkMethod: string
Read Only:
true
Maximum Length:400
Type of manufacturing used for the production process. Valid values are Discrete Manufacturing and Process Manufacturing. -
WorkMethodCode: number
Read Only:
true
Type of manufacturing used for the production process. Valid values are 1: Discrete Manufacturing and 2: Process Manufacturing. -
WorkOrderStatus: string
Read Only:
true
Maximum Length:400
Value 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:
true
Work 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:
Zone
Read Only:true
Maximum Length:400
Region or zone where the demand quantity is being shipped.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Planning Attributes
Type:
array
Title:
Planning Attributes
The 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:
Links
The link relations associated with the resource instance. -
OrderNumber: string
Title:
Order Number
Maximum Length:4000
Number that identifies the order associated with the demand or supply. -
PlanningAttributeNumber10: string
Maximum Length:
4000
Value for the planning attribute number 10 in attribute-based planning. -
PlanningAttributeNumber11: string
Maximum Length:
4000
Value for the planning attribute number 11 in attribute-based planning. -
PlanningAttributeNumber12: string
Maximum Length:
4000
Value for the planning attribute number 12 in attribute-based planning. -
PlanningAttributeNumber13: string
Maximum Length:
4000
Value for the planning attribute number 13 in attribute-based planning. -
PlanningAttributeNumber14: string
Maximum Length:
4000
Value for the planning attribute number 14 in attribute-based planning. -
PlanningAttributeNumber15: string
Maximum Length:
4000
Value for the planning attribute number 15 in attribute-based planning. -
PlanningAttributeNumber3: string
Maximum Length:
4000
Value for the planning attribute number 3 in attribute-based planning. -
PlanningAttributeNumber4: string
Maximum Length:
4000
Value for the planning attribute number 4 in attribute-based planning. -
PlanningAttributeNumber5: string
Maximum Length:
4000
Value for the planning attribute number 5 in attribute-based planning. -
PlanningAttributeNumber6: string
Maximum Length:
4000
Value for the planning attribute number 6 in attribute-based planning. -
PlanningAttributeNumber7: string
Maximum Length:
4000
Value for the planning attribute number 7 in attribute-based planning. -
PlanningAttributeNumber8: string
Maximum Length:
4000
Value for the planning attribute number 8 in attribute-based planning. -
PlanningAttributeNumber9: string
Maximum Length:
4000
Value 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:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-ResourceRequirements-item-response
Type:
Show Source
object
-
ActualStartDate: string
(date)
Read Only:
true
Actual operation start date. This is the first day that the resource is required for production. -
AlternateNumber: integer
Read Only:
true
Alternate number of the corresponding operation resource. -
AssemblyItemId: integer
(int64)
Read Only:
true
Assembly that uses the resource for the production generating resource requirement. -
AssignedUnits: number
Read Only:
true
Number 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:
true
Maximum Length:255
Name of the plan. -
ConstrDateAdditionalCap: number
Read Only:
true
Additional capacity required by the resource computed by the planning engine on the resource constraint date. -
ConstrDateResourceCapacity: number
Read Only:
true
Total capacity required by the resource computed by the planning engine on the resource constraint date. -
ConsumptionStartDate: string
(date)
Read Only:
true
Start 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:
true
This 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:
true
Maximum Length:4000
Indicates 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:
true
The 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:
true
Maximum Length:4000
Indicates 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:
true
Maximum Length:64
Indicates the user who created the row. -
CreationDate: string
(date-time)
Read Only:
true
Indicates the date and time of the creation of the row. -
CummulativeQuantity: number
Read Only:
true
Indicates the total resource requirement of the resource. -
DepartmentCode: string
Read Only:
true
Maximum Length:120
Value that uniquely identifies the department that the resource belongs to. -
DepartmentId: integer
(int64)
Read Only:
true
Department identifier or the work center of the resource. -
Description: string
Read Only:
true
Maximum Length:4000
Description of the resource. -
EarliestStartDate: string
(date)
Read Only:
true
Earliest start date for improved exceptions. -
EndDate: string
(date)
Read Only:
true
End date of the resource requirement. The resource isn't required after this date. -
ExecutionSequence: number
Read Only:
true
Indicates the execution sequence number of the operation if the work order has resequence operations. -
FirmEndDate: string
(date)
Read Only:
true
End date marked as firm so that it doesn't change during replan. -
FirmPlannedType: integer
Read Only:
true
Indicates whether the resource requirement is marked as firm. -
FirmStartDate: string
(date)
Read Only:
true
Start date is marked to be firm. -
FirmStatus: string
Read Only:
true
Maximum Length:4000
Description of how a resource requirement is firmed. -
FixedLeadTime: number
Read Only:
true
Value of the Fixed Lead Time. This is used irrespective of the quantity being manufactured. -
HoursExpended: number
Read Only:
true
Hours expended on a resource of a job. -
ItemName: string
Read Only:
true
Maximum Length:4000
Value that uniquely identifies the assembly item associated with the resource requirement. -
LastUpdateDate: string
(date-time)
Read Only:
true
Indicates the date and time of the last update of the row. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
Indicates the user who last updated the row. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
Indicates the session sign-in associated with the user who last updated the row. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MaterialAvailDate: string
(date)
Read Only:
true
Completion 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:
true
Number of maximum resource units assigned to perform the operation. -
NeedByDate: string
(date)
Read Only:
true
Date on which a resource requirement should be complete to meet the demand on time. -
NewScheduleDate: string
(date)
Read Only:
true
Value that indicates the new schedule date of the resource requirement demand. -
OperationCost: number
Read Only:
true
Value that indicates the outside processing operation cost. -
OperationSequenceId: integer
Read Only:
true
Operation sequence identifier of the operation where the resource requirement is generated. -
OperationSequenceNumber: integer
Read Only:
true
Sequence number of the operation for the resource requirement. -
OrderNumber: string
Read Only:
true
Maximum Length:240
Value that uniquely identifies the order number of the supply that generates the resource requirement. -
OrganizationCode: string
Read Only:
true
Maximum Length:4000
Indicates the organization identifier. -
OrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the organization that the department resource belongs to. -
OSPOperationType: integer
Read Only:
true
Value that indicates the type of outside processing operation. -
OSPOperationTypeStr: string
Read Only:
true
Maximum Length:4000
Descriptive value of the type of resource requirements, whether In-House or Supplier. -
ParentId: integer
(int64)
Read Only:
true
Reference to the parent transaction identifier of the resource requirement. -
PlanId: integer
Read Only:
true
Value that uniquely identifies the plan associated with the resource requirements of a resource. -
QuantityInQueue: number
Read Only:
true
Number of units in the queue of the operation. -
ResourceCode: string
Read Only:
true
Maximum Length:40
Identifier of the resource associated with the resource requirement. -
ResourceConstraintDate: string
(date)
Read Only:
true
Date populated by the planning engine process for a bottleneck or resource marked critical because it's constrained. -
ResourceHours: number
Read Only:
true
Value that indicates the resource hours required. -
ResourceId: integer
Read Only:
true
Value that uniquely identifies the resource. -
ResourceSequenceNumber: integer
Read Only:
true
Identifier of the planned resource sequence for the operation requirement. -
ResourceUOMCode: string
Read Only:
true
Maximum Length:4000
Identifier of the unit of measure of the resource. -
RoutingSequenceId: integer
Read Only:
true
Routing sequence identifier for the routing or the work definition. -
SchedulePriority: number
Read Only:
true
Order priority of the resource requirement. -
ScheduleType: integer
Read Only:
true
Schedule identifier on the resource. If this is set then the resource is used in planning. -
ScheduleTypeCode: string
Read Only:
true
Maximum Length:4000
Descriptive value of how the resource requirement is scheduled. -
StartDate: string
(date)
Read Only:
true
Start date of the resource requirement. -
Supplier: string
Read Only:
true
Maximum Length:4000
Value that identifies the supplier of an outside processing operation. -
SupplierId: integer
(int64)
Read Only:
true
Value that indicates the unique supplier identifier of an outside processing operation. -
SupplierSite: string
Read Only:
true
Maximum Length:4000
Value that uniquely identifies the supplier site of an outside processing operation. -
SupplierSiteId: integer
(int64)
Read Only:
true
Value that indicates the unique supplier site identifier for an outside processing operation in the planning system. -
SupplyId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supply generating the Resource Requirements resource. -
SupplyType: integer
Read Only:
true
Value that indicates the type of supply generating the resource requirement. -
SupplyTypeCode: string
Read Only:
true
Maximum Length:4000
Descriptive value of the supply type generating the Resource Requirements resource. -
TimezoneName: string
Read Only:
true
Maximum Length:4000
Value that uniquely identifies the time zone. -
TotalResourceHours: number
Read Only:
true
Total inflated resource hours required for an activity of a job. -
TransactionId: integer
(int64)
Read Only:
true
Value that uniquely identifies a resource requirement entry. -
UnadjustedResourceHours: number
Read Only:
true
Resource hours unadjusted for utilization and efficiency. -
UOMCode: string
Read Only:
true
Maximum Length:4000
Value that uniquely identifies the unit of measure. -
UsageRate: number
Read Only:
true
Rate per assembly or amount per job or schedule. -
VariableLeadTime: number
Read Only:
true
Variable 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:
true
Maximum Length:120
Value that uniquely identifies the work area that the department resource belongs to. -
WorkAreaId: integer
(int64)
Read Only:
true
Value indicates the work area identifier of the department resource. -
Yield: number
Read Only:
true
Indicates the operation yield that uses the resource.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-Resources-item-response
Type:
Show Source
object
-
AvailableAllDayIndicator: integer
Read Only:
true
Value 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:
true
Maximum Length:4000
Value 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:
true
Maximum Length:4000
Value 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:
true
Value 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:
true
Maximum Length:4000
Indicates 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:
true
Number of units of this resource that are available. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the resource. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the user created the resource. -
Critical: integer
(int64)
Read Only:
true
Value 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:
true
Maximum Length:4000
Value 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:
true
Value 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:
true
Maximum Length:4000
Code for the currency in which the resource cost is defined. -
DataSecurityEditAllowed: string
Read Only:
true
Contains 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:
true
Date when the resource is no longer available. -
EfficiencyPercent: number
Read Only:
true
Percentage of the actual output compared to the expected standard output. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the resource. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the resource. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
NotesCount: integer
Read Only:
true
Value 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:
true
Cost associated with using the resource. -
NumberOfLineOperations: number
Read Only:
true
Cost associated with using the resource. -
Organization: string
Read Only:
true
Maximum Length:4000
Abbreviation that identifies the organization. -
OrganizationId: integer
(int64)
Read Only:
true
Value that uniquely identifies the organization. -
ResourceCapacities: array
Resource Capacities
Title:
Resource Capacities
The Resource Capacities resource manages how many hours a resource is available for each day. -
ResourceCode: string
Read Only:
true
Maximum Length:40
Abbreviation that identifies the resource. -
ResourceCost: number
Read Only:
true
Cost associated with using the resource. -
ResourceDescription: string
Read Only:
true
Maximum Length:240
Description of the resource. -
ResourceId: integer
(int64)
Read Only:
true
Value that uniquely identifies the resource. -
ResourceName: string
Read Only:
true
Maximum Length:80
Name of the resource. -
ResourceType: integer
Read Only:
true
Value 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:
true
Maximum Length:4000
Value that indicates the type of resource. Valid values are Equipment or Crew. -
ResourceUOM: string
Read Only:
true
Maximum Length:3
Unit of measure associated with the resource. -
RunRate: number
Read Only:
true
Cost associated with using the resource. -
UnitOfMeasureDisplay: string
Read Only:
true
Maximum Length:4000
Unit of measure associated with the resource. -
UtilizationPercent: number
Read Only:
true
Percentage of how much a resource is utilized. -
WorkAreaCode: string
Read Only:
true
Maximum Length:120
Abbreviation that identifies the work area. -
WorkAreaDescription: string
Read Only:
true
Maximum Length:240
Description of the work area. -
WorkAreaId: integer
(int64)
Read Only:
true
Value that uniquely identifies the work area. -
WorkAreaName: string
Read Only:
true
Maximum Length:80
Name of the work area. -
WorkCenterCode: string
Read Only:
true
Maximum Length:120
Abbreviation that identifies the work center. -
WorkCenterDescription: string
Read Only:
true
Maximum Length:240
Description of the work center. -
WorkCenterId: integer
(int64)
Read Only:
true
Value that uniquely identifies the work center. -
WorkCenterName: string
Read Only:
true
Maximum Length:80
Name of the work center.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Resource Capacities
Type:
array
Title:
Resource Capacities
The 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:
true
Date when the resource capacity is available. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the resource capacity. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the user created the resource capacity. -
DailyAvailability: number
Read Only:
true
Daily availability for each capacity unit of the resource. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the resource capacity. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the resource capacity. -
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : planInputs-SupplierCapacities-item-response
Type:
Show Source
object
-
AslId: integer
Read Only:
true
Value that uniquely identifies the supplier item. -
Capacity: number
Read Only:
true
Daily available capacity for the supplier item. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the supplier capacity. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the user created the supplier capacity. -
FromDate: string
(date)
Read Only:
true
Date when the supplier capacity is available. -
InventoryItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the item. -
ItemName: string
Read Only:
true
Maximum Length:4000
Name of the item. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the supplier capacity. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the supplier capacity. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
SupplierId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supplier. -
SupplierName: string
Read Only:
true
Maximum Length:4000
Name of the supplier. -
SupplierSiteCode: string
Read Only:
true
Maximum Length:4000
Abbreviation that identifies the supplier site. -
SupplierSiteId: integer
(int64)
Read Only:
true
Value that uniquely identifies the supplier site. -
ToDate: string
(date)
Read Only:
true
Date when the supplier capacity is no longer available.
Nested Schema : Links
Type:
array
Title:
Links
The 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:
true
Maximum Length:240
Name of the delivery calendar associated with the supplier item. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the supplier item. -
CreationDate: string
(date-time)
Read Only:
true
Date 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:
25
Abbreviation 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:
true
Maximum Length:4000
Name of the item. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the supplier item. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the supplier item. -
links: array
Links
Title:
Links
The 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:
true
Maximum Length:4000
Name of the supplier. -
SupplierSiteCode: string
Read Only:
true
Maximum Length:4000
Abbreviation that identifies the supplier site. -
SupplierSiteId: integer
(int64)
Value that uniquely identifies the supplier site.
-
UOMCode: string
Maximum Length:
3
Abbreviation that identifies the unit of measure associated with the supplier item.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source