Get all plans

get

/fscmRestApi/resources/11.13.18.05/replenishmentPlans

Request

Query Parameters
  • 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).
  • 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
  • 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 Finds replenishment plans according to the plan identifier.
      Finder Variables
      • PlanId; integer; Value that uniquely identifies the plan.
  • 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.
  • 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
  • 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.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • 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
  • 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:
    • AggregateNonkeyCustomerData; integer; Contains one of the following values: 1 or 2. If 1, then use aggregated data for non-key customers. If 2, then don't use this data. If you aggregate data in a plan, then the application uses the predefined level for each member as the aggregated data. The default value is 2.
    • ArchivePlan; integer; Contains one of the following values: 1 or 2. If 1, then archive the plan before the next run starts. You can archive the plan only if you enable it for archiving. If 2, then don't archive. The default value is 2.
    • ArchiveTimeHierarchy; integer; Time hierarchy that the application uses to archive the plan.
    • ArchiveTimeLevel; integer; Time hierarchy level that the application uses to archive the plan. The ArchiveTimeHierarchy attribute determines the values that you can use for this attribute.
    • ArchiveVersionDays; integer; Number of days that the application retains the archive. The application deletes each archive that's older than the current date minus Most Recent Days to Keep. The application performs this deletion when it creates each new archive.
    • AssignmentSetName; string; Name of the assignment set that specifies the sourcing rules and bills of distribution to use for material flow in the supply chain when running the plan. You can use the Manage Assignment Sets page in one of the work areas for supply chain planning to set the values you can use with this attribute.
    • AutoRelease; integer; Contains one of the following values: 1 or 2. If 1, then release planning recommendations. If 2, then don't release. The default value is 2.
    • CalendarCode; string; Abbreviation that identifies the calendar.
    • Clusters; string; Name of the clusters for which inventory rebalancing is performed.
    • CreatedBy; string; User who created the plan.
    • CreationDate; string; Date when the user created the plan.
    • CutoffDate; string; End date of the planning horizon when planning no longer plans demand or supply.
    • DeleteArchive; integer; Contains one of the following values: 1 or 2. If 1, then delete plan archives that were created before the most recent days to keep during the next plan run. If 2, then don't delete plan archives. The default value is 2.
    • DemandPlanCompletionDate; string; Date and time when demand planning finished running the plan.
    • DemandPlanStartDate; string; Date and time when demand planning started running the plan.
    • Description; string; Description of the plan.
    • EnableArchive; integer; Contains one of the following values: 1 or 2. If 1, then archive the plan measures through the archive plan option. If 2, then don't archive measures. The default value is 2.
    • ExceptionSet; integer; Exception set that the plan references. The exception set determines the exception types that the plan creates.
    • ExcessLtMultiplier; number; Value by which item lead time is multiplied by to calculate the time window within which excess quantity is computed for item substitution or supersession.
    • ForecastOption; integer; Value that indicates whether to generate a forecast or not. Valid values are 1 or 2. If 1, then generate a forecast. If 2, then don't generate a forecast. The default value is 2.
    • ForecastProfiles; string; List of forecast profiles that the plan run uses. A comma separates each forecast profile name.
    • ForecastingTimeLevel; integer; Abbreviation that identifies the time bucket type for forecasting buckets. Valid values vary based on the forecasting calendar type. If the forecasting calendar type is 5, manufacturing calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_MFG. If the forecasting calendar type is 1, Gregorian calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_GREGORIAN. If the forecasting calendar type is 3, fiscal calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_FISCAL.
    • HasRun; integer; Abbreviation that identifies the time bucket type for forecasting buckets. Valid values vary based on the forecasting calendar type. If the forecasting calendar type is 5, manufacturing calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_MFG. If the forecasting calendar type is 1, Gregorian calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_GREGORIAN. If the forecasting calendar type is 3, fiscal calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_FISCAL.
    • IncludeTransferOrders; integer; Contains one of the following values: 1 or 2. If 1, then include transfer orders when loading sales order history. If 2, then don't include. The default value is 2.
    • IncrementalPlanningOption; integer; Value that indicates whether to enable a plan for incremental planning. Valid values are 1 or 2. If 1, then enable incremental planning. If 2, then disable incremental planning. The default value is 2.
    • InvRebIncludeSsOption; integer; Value that indicates whether to include safety stock in shortages computation. Valid values are 1 or 2. If 1, then include safety stock. If 2, then don't include safety stock. The default value is 2.
    • InvRebMoveExcessOption; integer; Value that indicates whether to move excess inventory to sweep location. Valid values are 1 or 2. If 1, then move excess inventory. If 2, then don't move excess inventory. The default value is 1.
    • InvRebalancePartialsOption; integer; Value that indicates whether to create partial orders from source location that doesn't have enough inventory to meet the entire destination location shortages. Valid values are 1 or 2. If 1, then don't create partial orders. If 2, then create partial orders. The default value is 1.
    • ItemListPrice; integer; This attribute isn't currently used.
    • LastUpdatedBy; string; User who performed the most recent update on the plan.
    • LastUpdatedDate; string; Date when the user most recently updated the plan.
    • LeadTimeMultiplier; integer; Item lead time that's multiplied by to calculate the lead time window within which all demands are considered.
    • MeasureCatalogForArchival; string; Measure catalog that the application uses to archive the plan.
    • MultiechelonFlag; integer
    • NumberOfBuckets; integer; Number of planning buckets of the specified type used in the supply planning process.
    • PlanAccess; integer; Contains one of the following values: 1 or 2. If 1, then the plan is public. If 2, then the plan is private. Only the plan owner or users that the plan references can view a private plan. A list of accepted values is defined in the lookup type ORA_MSC_ACCESS. The default value is 1.
    • PlanDimensionCatalog; integer; Dimension catalog that the plan references. The dimension catalog determines the dimensions that you can use in each plan.
    • PlanHorizonStartDate; string; Date when the plan starts planning demand and supply.
    • PlanId; integer; Value that uniquely identifies the plan.
    • PlanMeasureCatalog; string; Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan.
    • PlanName; string; Name of the plan.
    • PlanOrganizationLevelMembers; string; List of level values in the organization hierarchy included in the scope of the plan. A comma separates each value.
    • PlanOwner; string; Name of the user who owns the plan.
    • PlanStatus; integer; Status of the plan run that most recently completed. Valid values include 0: completed, 1: processing, 2: error, or 3: warning. A list of accepted values is defined in the lookup type ORA_MSC_PLAN_STATUS_TYPE. This attribute doesn't have a default value.
    • PlanTimeLevel; integer; Time level used for aggregate planning. Valid values are Day, Week, Period, or Month. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_TIME_LEVEL.
    • PlanType; integer; Type of plan. Contains one of the following values. 1: demand plan, 2: supply plan, or 3: demand and supply plan. A list of accepted values is defined in the lookup type ORA_MSC_PLAN_TYPE.
    • PlanningCalendar; string; Supply planning calendar used for aggregate planning. Review the values for this attribute using the Review Planning Calendars task.
    • PolicyAssignmentSetId; integer; Value that uniquely identifies the policy assignment set. Review and update the value for this attribute using the Manage Policy Assignment Sets task. This attribute is mandatory if CalculatePolicyParamFlag is true.
    • PolicyAssignmentSetName; string; Name of the policy assignment set. Review and update the value for this attribute using the Manage Policy Assignment Sets task. This attribute is mandatory if Calculate Policy Parameters is selected.
    • PolicyComparisonOption; integer; Value that indicates whether to enable a plan for policy comparison. Valid values are 1 or 2. If 1, then enable plan for policy comparison. If 2, then disable plan for policy comparison. The default value is 2.
    • PolicyComparisonThreshold; integer; Percent value of the threshold used in policy comparison.
    • PolicyParametersOption; integer; Value that indicates whether or not to calculate policy parameters. Valid values are 1 or 2. If 1, then calculate policy parameters. If 2, then don't calculate policy parameters. The default value is 2.
    • PriceLists; string; List of price lists to consider in the plan. A comma separates each value.
    • RelatedItemsSuppliesRules; string; Contains one of the following values: 1,2 or 3. If 1, then don't use related items. If 2, then maximize the use of related items to minimize new replenishment orders. If 3, then use related items only when necessary to avoid stockouts. The default value is 1.
    • ReplAggrPlannedOrders; integer; Contains one of the following values: 1 or 2. If 1, then aggregate the planned orders. If 2, then don't aggregate the planned orders. The default value is 1.
    • ReplInvRebalanceOption; integer; Value that indicates whether to perform inventory rebalancing. Valid values are 1 or 2. If 1, then perform inventory rebalancing. If 2, then don't perform inventory rebalancing. The default value is 2.
    • ReplSupplyCutoffDays; integer; Number of days after the plan end date during which the existing supplies are considered. The default value is 0.
    • ReplenishmentsOption; integer; Value that indicates whether to calculate replenishments. Valid values are 1 or 2. If 1, then calculate replenishments. If 2, then don't calculate replenishments. The default value is 1.
    • SegmentGroup; integer; Segment group that planning uses when the plan is run. Review and update the value for this attribute using the Manage Segment Groups task.
    • Segments; string; List of segments to consider in the plan. A comma separates each value. Review and update the value for this attribute using the Manage Segment Groups task.
    • ShortPlanId; integer; Value that uniquely identifies the plan.
    • SimulationSet; integer; Simulation set that planning uses when the plan runs. A simulation set is a set of adjustments that you make to inputs that affect the plan. You can use them to test different business scenarios, such as increasing the available resource capacity.
    • SupplyParameterOverrides; string; Name of the plan parameter override.
    • TimeHorizonForDemand; integer; Value that indicates the horizon within which the demand is considered. Valid values are 1: item lead time, or 2: none. The default value is 2.
  • 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
  • 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".
  • 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 Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • 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".
  • 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.
Body ()
Root Schema : replenishmentPlans
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : replenishmentPlans-item-response
Type: object
Show Source
  • Contains one of the following values: 1 or 2. If 1, then use aggregated data for non-key customers. If 2, then don't use this data. If you aggregate data in a plan, then the application uses the predefined level for each member as the aggregated data. The default value is 2.
  • Contains one of the following values: 1 or 2. If 1, then archive the plan before the next run starts. You can archive the plan only if you enable it for archiving. If 2, then don't archive. The default value is 2.
  • Time hierarchy that the application uses to archive the plan.
  • Time hierarchy level that the application uses to archive the plan. The ArchiveTimeHierarchy attribute determines the values that you can use for this attribute.
  • Number of days that the application retains the archive. The application deletes each archive that's older than the current date minus Most Recent Days to Keep. The application performs this deletion when it creates each new archive.
  • Name of the assignment set that specifies the sourcing rules and bills of distribution to use for material flow in the supply chain when running the plan. You can use the Manage Assignment Sets page in one of the work areas for supply chain planning to set the values you can use with this attribute.
  • Contains one of the following values: 1 or 2. If 1, then release planning recommendations. If 2, then don't release. The default value is 2.
  • Maximum Length: 22
    Abbreviation that identifies the calendar.
  • Name of the clusters for which inventory rebalancing is performed.
  • Read Only: true
    Maximum Length: 64
    User who created the plan.
  • Read Only: true
    Date when the user created the plan.
  • End date of the planning horizon when planning no longer plans demand or supply.
  • Contains one of the following values: 1 or 2. If 1, then delete plan archives that were created before the most recent days to keep during the next plan run. If 2, then don't delete plan archives. The default value is 2.
  • Date and time when demand planning finished running the plan.
  • Date and time when demand planning started running the plan.
  • Maximum Length: 100
    Description of the plan.
  • Contains one of the following values: 1 or 2. If 1, then archive the plan measures through the archive plan option. If 2, then don't archive measures. The default value is 2.
  • Exception set that the plan references. The exception set determines the exception types that the plan creates.
  • Read Only: true
    Value by which item lead time is multiplied by to calculate the time window within which excess quantity is computed for item substitution or supersession.
  • Abbreviation that identifies the time bucket type for forecasting buckets. Valid values vary based on the forecasting calendar type. If the forecasting calendar type is 5, manufacturing calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_MFG. If the forecasting calendar type is 1, Gregorian calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_GREGORIAN. If the forecasting calendar type is 3, fiscal calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_FISCAL.
  • Value that indicates whether to generate a forecast or not. Valid values are 1 or 2. If 1, then generate a forecast. If 2, then don't generate a forecast. The default value is 2.
  • List of forecast profiles that the plan run uses. A comma separates each forecast profile name.
  • Abbreviation that identifies the time bucket type for forecasting buckets. Valid values vary based on the forecasting calendar type. If the forecasting calendar type is 5, manufacturing calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_MFG. If the forecasting calendar type is 1, Gregorian calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_GREGORIAN. If the forecasting calendar type is 3, fiscal calendar, then a list of accepted values is defined in the lookup type ORA_MSC_TIME_LEVELS_FISCAL.
  • Contains one of the following values: 1 or 2. If 1, then include transfer orders when loading sales order history. If 2, then don't include. The default value is 2.
  • Value that indicates whether to enable a plan for incremental planning. Valid values are 1 or 2. If 1, then enable incremental planning. If 2, then disable incremental planning. The default value is 2.
  • Value that indicates whether to create partial orders from source location that doesn't have enough inventory to meet the entire destination location shortages. Valid values are 1 or 2. If 1, then don't create partial orders. If 2, then create partial orders. The default value is 1.
  • Read Only: true
    Value that indicates whether to include safety stock in shortages computation. Valid values are 1 or 2. If 1, then include safety stock. If 2, then don't include safety stock. The default value is 2.
  • Read Only: true
    Value that indicates whether to move excess inventory to sweep location. Valid values are 1 or 2. If 1, then move excess inventory. If 2, then don't move excess inventory. The default value is 1.
  • This attribute isn't currently used.
  • Items
    Title: Items
    The Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution.
  • Read Only: true
    Maximum Length: 64
    User who performed the most recent update on the plan.
  • Read Only: true
    Date when the user most recently updated the plan.
  • Item lead time that's multiplied by to calculate the lead time window within which all demands are considered.
  • Links
  • Measure catalog that the application uses to archive the plan.
  • Read Only: true
  • Number of planning buckets of the specified type used in the supply planning process.
  • Default Value: 1
    Contains one of the following values: 1 or 2. If 1, then the plan is public. If 2, then the plan is private. Only the plan owner or users that the plan references can view a private plan. A list of accepted values is defined in the lookup type ORA_MSC_ACCESS. The default value is 1.
  • Dimension catalog that the plan references. The dimension catalog determines the dimensions that you can use in each plan.
  • Date when the plan starts planning demand and supply.
  • Value that uniquely identifies the plan.
  • Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan.
  • Title: Name
    Maximum Length: 30
    Name of the plan.
  • Maximum Length: 22
    Supply planning calendar used for aggregate planning. Review the values for this attribute using the Review Planning Calendars task.
  • Planning Demands
    Title: Planning Demands
    The Planning Demands resource manages the demand orders and forecasts that are part of the plan.
  • Planning Supplies
    Title: Planning Supplies
    The Planning Supplies resource manages the supply orders such as work orders and purchase orders that are part of the plan.
  • List of level values in the organization hierarchy included in the scope of the plan. A comma separates each value.
  • Maximum Length: 64
    Name of the user who owns the plan.
  • Status of the plan run that most recently completed. Valid values include 0: completed, 1: processing, 2: error, or 3: warning. A list of accepted values is defined in the lookup type ORA_MSC_PLAN_STATUS_TYPE. This attribute doesn't have a default value.
  • Time level used for aggregate planning. Valid values are Day, Week, Period, or Month. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_TIME_LEVEL.
  • Type of plan. Contains one of the following values. 1: demand plan, 2: supply plan, or 3: demand and supply plan. A list of accepted values is defined in the lookup type ORA_MSC_PLAN_TYPE.
  • Value that uniquely identifies the policy assignment set. Review and update the value for this attribute using the Manage Policy Assignment Sets task. This attribute is mandatory if CalculatePolicyParamFlag is true.
  • Name of the policy assignment set. Review and update the value for this attribute using the Manage Policy Assignment Sets task. This attribute is mandatory if Calculate Policy Parameters is selected.
  • Value that indicates whether to enable a plan for policy comparison. Valid values are 1 or 2. If 1, then enable plan for policy comparison. If 2, then disable plan for policy comparison. The default value is 2.
  • Percent value of the threshold used in policy comparison.
  • Value that indicates whether or not to calculate policy parameters. Valid values are 1 or 2. If 1, then calculate policy parameters. If 2, then don't calculate policy parameters. The default value is 2.
  • List of price lists to consider in the plan. A comma separates each value.
  • Read Only: true
    Maximum Length: 4000
    Contains one of the following values: 1,2 or 3. If 1, then don't use related items. If 2, then maximize the use of related items to minimize new replenishment orders. If 3, then use related items only when necessary to avoid stockouts. The default value is 1.
  • Contains one of the following values: 1 or 2. If 1, then aggregate the planned orders. If 2, then don't aggregate the planned orders. The default value is 1.
  • Value that indicates whether to calculate replenishments. Valid values are 1 or 2. If 1, then calculate replenishments. If 2, then don't calculate replenishments. The default value is 1.
  • Value that indicates whether to perform inventory rebalancing. Valid values are 1 or 2. If 1, then perform inventory rebalancing. If 2, then don't perform inventory rebalancing. The default value is 2.
  • Number of days after the plan end date during which the existing supplies are considered. The default value is 0.
  • Runs
    Title: Runs
    The Runs resource manages the run details of the replenishment plan. You can use this resource to run replenishment plans.
  • Segment group that planning uses when the plan is run. Review and update the value for this attribute using the Manage Segment Groups task.
  • List of segments to consider in the plan. A comma separates each value. Review and update the value for this attribute using the Manage Segment Groups task.
  • Value that uniquely identifies the plan.
  • Simulation set that planning uses when the plan runs. A simulation set is a set of adjustments that you make to inputs that affect the plan. You can use them to test different business scenarios, such as increasing the available resource capacity.
  • Read Only: true
    Maximum Length: 250
    Name of the plan parameter override.
  • Value that indicates the horizon within which the demand is considered. Valid values are 1: item lead time, or 2: none. The default value is 2.
Nested Schema : Items
Type: array
Title: Items
The Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution.
Show Source
Nested Schema : Planning Demands
Type: array
Title: Planning Demands
The Planning Demands resource manages the demand orders and forecasts that are part of the plan.
Show Source
Nested Schema : Planning Supplies
Type: array
Title: Planning Supplies
The Planning Supplies resource manages the supply orders such as work orders and purchase orders that are part of the plan.
Show Source
Nested Schema : Runs
Type: array
Title: Runs
The Runs resource manages the run details of the replenishment plan. You can use this resource to run replenishment plans.
Show Source
Nested Schema : replenishmentPlans-Items-item-response
Type: object
Show Source
  • 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.
  • 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.
  • Read Only: true
    Value that indicates whether common supplies are used in case the project inventory isn't sufficient during the demand and supply netting process. Valid values are: 1 or 2. If 1, then common supplies are used. If 2, then not.
  • Read Only: true
    Maximum Length: 4000
    Indicates whether to allow use of common supplies when the project inventory isn't sufficient during the demand and supply netting process. Valid values are Yes and No.
  • Percent of unit cost that represents the internal cost to stock one unit for one year.
  • Read Only: true
    Maximum Length: 1
    Number of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time.
  • 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.
  • 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.
  • Read Only: true
    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.
  • Average time, expressed in days, between intervals.
  • Number of days specified by the user to override the average interarrival time, where the average interarrival time is the average time, expressed in days, between intervals.
  • Read Only: true
    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.
  • 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.
  • Read Only: true
    Maximum Length: 4000
    Value that uniquely identifies the model to use when creating an assemble-to-order configuration.
  • Read Only: true
    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.
  • 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.
  • Maximum Length: 240
    Name of the buyer associated with the item.
  • 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.
  • 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.
  • Read Only: true
    Maximum Length: 4000
    Description associated with a product category.
  • Read Only: true
    Value that uniquely identifies an item category.
  • 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.
  • Read Only: true
    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.
  • Read Only: true
    Maximum Length: 64
    User who created the item.
  • 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.
  • Date after which supplies can be created. This attribute is editable only when the CreateSupply attribute is set to 1.
  • Read Only: true
    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.
  • Read Only: true
    Date and time when the user created the supplier item.
  • 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.
  • Read Only: true
    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.
  • 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.
  • Read Only: true
    Maximum Length: 30
    Value that indicates the currency associated with the item's price and cost.
  • 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.
  • Number of days of cover for the item. Days of Cover is multiplied by the average demand to calculate the safety stock level.
  • 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.
  • 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.
  • Read Only: true
    Date before which forecast demand is ignored.
  • Time horizon, expressed in number of days, within which forecast demand is ignored.
  • 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.
  • Maximum Length: 240
    Description of the item.
  • Average discount for the item.
  • Read Only: true
    Maximum Length: 4000
    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.
  • 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.
  • Time horizon, expressed in number of days, after which inventory is considered excess.
  • Number of days to use to modify the size and timing of each planned order quantity.
  • Number of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time.
  • Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate.
  • Quantity to use to modify the size of each planned order quantity or each repetitive daily rate.
  • Read Only: true
    Maximum Length: 4000
    Value that indicates how the forecast is exploded and consumed. This attribute isn't currently used.
  • 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.
  • Read Only: true
    Maximum Length: 4000
    Meaning associated with the ForecastErrorType Code attribute.
  • Read Only: true
    Maximum Length: 4000
    Name of the forecast used for safety stock calculation.
  • 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.
  • Read Only: true
    Maximum Length: 4000
    Meaning associated with the HardPeggingLevel attribute.
  • 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.
  • Read Only: true
    Maximum Length: 4000
    Indicates whether the demand has an irregular frequency. Valid values are Yes and No.
  • Value specified by the user to override the Intermittent Demand, where Intermittent Demand indicates whether the demand 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.
  • Read Only: true
    Maximum Length: 4000
    Value specified by the user to determine whether to override intermittent demand, which indicates whether the demand has an irregular frequency or not. Valid values are Yes and No.
  • Value that uniquely identifies the item.
  • Read Only: true
    Maximum Length: 4000
    Unit of measure associated with an item's cost.
  • Maximum Length: 300
    Name of the item.
  • 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.
  • Read Only: true
    Date and time when the user most recently updated the item.
  • Read Only: true
    Maximum Length: 64
    User most recently updated the item.
  • Read Only: true
    Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate.
  • Number of months or periods in which the constrained supply plan offsets the lead time, after converting the number of months or periods to days. Month buckets are used if the supply planning calendar is Gregorian. Value can be null or greater than or equal to zero. This attribute doesn't have a default value.
  • Number of weeks in which the constrained supply plan offsets the lead time, after converting the number of weeks to days. Value can be null or greater than or equal to zero. This attribute doesn't have a default value.
  • Maximum Length: 120
    Name of lifecycle phase of the item.
  • Links
  • 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.
  • 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.
  • 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.
  • 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.
  • Read Only: true
    Value of the mean absolute deviation for the item.
  • Value that's the user override of the mean absolute deviation, where mean absolute deviation is a statistical formula used to measure the quantity deviation between actual and forecasted demand.
  • 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.
  • Read Only: true
    Value of the mean absolute percentage error for the item.
  • Value that's the user override of the mean absolute percentage error, where mean absolute percentage error is a statistical formula used to measure the percentage deviation between actual and forecasted demand.
  • Maximum order quantity of the item.
  • Minimum order quantity of the item.
  • Read Only: true
    Selling price of an item after applying an average discount to the item's list price.
  • Most recent value that uniquely identifies the plan.
  • Read Only: true
    The number of days after the demand date that the demand can be satisfied. This attribute doesn't have a default value.
  • Date when the item is obsolete.
  • Fixed costs that are associated with placing a sales order for the item.
  • 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.
  • 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.
  • Maximum Length: 49
    Abbreviation that identifies the organization associated with the item.
  • Value that uniquely identifies the organization.
  • 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.
  • Read Only: true
    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.
  • Read Only: true
    Maximum Length: 4000
    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.
  • Read Only: true
    Abbreviation that identifies the 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.
  • Maximum Length: 10
    Abbreviation that identifies the planner responsible for the item.
  • Read Only: true
    Maximum Length: 4000
    Description of the planner responsible for the item.
  • 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.
  • 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.
  • 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.
  • Read Only: true
    Date before which orders aren't rescheduled.
  • Time horizon, in number of days, in which supply orders aren't scheduled to be due.
  • 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.
  • Number of days required to make an item available in inventory once the supply is complete.
  • Number of days which must be added to purchasing or manufacturing lead time to place an order.
  • Number of days required to procure or manufacture an item.
  • 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.
  • Read Only: true
    Date before which orders are automatically released as work orders or purchase requisitions.
  • Time horizon, in number of days, in which orders are automatically released as work orders or purchase requisitions.
  • 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.
  • 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.
  • Read Only: true
    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.
  • Read Only: true
    Maximum Length: 255
    Text that identifies whether the row is new or modified. Valid values are yes or null. If yes, then the row is new or modified. If null, then the row isn't new or modified.
  • 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.
  • Read Only: true
    Maximum Length: 4000
    Demand plan that contains the forecast and forecast error measures that the plan uses to calculate safety stock.
  • Maximum Length: 4000
    Meaning associated with the SafetyStockCode attribute.
  • Desired level of safety stock of an item.
  • Numeric value provided by the user to override the standard safety stock quantity of an item.
  • Selling price of the item.
  • 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.
  • Average amount of material you expect to lose when manufacturing or storing the item.
  • Standard cost of an item.
  • 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.
  • Read Only: true
    Volume of one item.
  • Read Only: true
    Weight of one item.
  • Read Only: true
    Maximum Length: 4000
    Planning unit of measure of the item.
  • Read Only: true
    Date when the current on-hand quantity for an item is exhausted based on projected gross requirements.
  • Time to produce one unit of an assembly.
  • Read Only: true
    Maximum Length: 4000
    Unit of measure to use for the item volume.
  • Read Only: true
    Maximum Length: 4000
    Unit of measure to use for the item weight.
Nested Schema : replenishmentPlans-PlanningDemands-item-response
Type: object
Show Source
  • Read Only: true
    Maximum Length: 80
    Value that indicates the type of recommended change made by the planning engine to the supply or demand. Valid values include None, Cancel, Reschedule in, Reschedule out, Release, Release reservation, and Reschedule and release reservation. A list of accepted values is defined in the lookup type ORA_MSC_ACTIONS.
  • Read Only: true
    Code that indicates the type of recommended change made by the planning engine to the supply or demand. Valid values are 1: Cancel, 2: Reschedule in, 3: Reschedule out, 4: Release, 5: Release reservation, 6: None, and 7: Reschedule and release reservation. A list of accepted values is defined in the lookup ORA_MSC_ACTIONS.
  • Title: Bucket Type
    Read Only: true
    Maximum Length: 7
    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.
  • Title: Buyer
    Read Only: true
    Name of the buyer associated with the item.
  • Read Only: true
    Value that uniquely identifies the catalog.
  • Read Only: true
    Value that uniquely identifies the category.
  • Title: Category
    Read Only: true
    Maximum Length: 4000
    Name of the category to which the item is assigned.
  • Read Only: true
    Maximum Length: 4000
    Organization code of an organization that's modeled as a child organization with a modeled subinventory code.
  • Read Only: true
    Value that uniquely identifies the child organization.
  • Title: Completed Quantity
    Read Only: true
    Sales order quantity that has already been completed.
  • Read Only: true
    Maximum Length: 64
    User who created the order.
  • Read Only: true
    Date when the user created the order.
  • Title: Customer
    Maximum Length: 4000
    Name of the customer associated with the sales order or forecast.
  • Value that uniquely identifies the customer.
  • Read Only: true
    Maximum Length: 50
    Value that uniquely identifies the customer's purchase order number.
  • Title: Customer Site
    Maximum Length: 4000
    Code associated with a specific customer ship-to location.
  • Value that uniquely identifies the customer site.
  • 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.
  • 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.
  • Title: Demand Class
    Maximum Length: 400
    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.
  • Title: Destination Time Zone
    Read Only: true
    Maximum Length: 100
    Time zone associated with the entity that's receiving the order. The destination entity can be a customer or an organization.
  • Read Only: true
    Maximum Length: 18
    Abbreviation that identifies the destination organization of an order.
  • Value that uniquely identifies the supply associated with a dependent demand.
  • 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.
  • Title: Firm Date
    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.
  • Title: Firm Status
    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.
  • Title: Firm Quantity
    Fixed quantity of demand. This attribute value can't be changed by planning and is only populated when the firm status is firm.
  • Read Only: true
    Maximum Length: 200
    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.
  • Title: Fulfillment Line
    Read Only: true
    Fulfillment line number associated with a sales order.
  • Title: Implement Date
    Date when the order is implemented.
  • Title: Implement Demand Class
    Maximum Length: 30
    Demand class associated with the order that will be used when the order is released.
  • Title: Implemented Quantity
    Cumulative quantity that has been released to date.
  • Title: Implement Firm
    Value that indicates whether the order is firm or not. Valid values are 1: Firm and 2: Not Firm. A list of accepted values is defined in the lookup type MSC_YES_NO.
  • Read Only: true
    Maximum Length: 200
    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.
  • Title: Implement Quantity
    Order quantity for the released order.
  • Title: Implement Ship Date
    Date when the order is shipped.
  • Maximum Length: 30
    Value that identifies the shipping method used when the order is released. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab.
  • Title: Implement Shipping Method
    Maximum Length: 400
    Value that indicates the shipping method used to ship the order when the order is released, or is a concatenation of carrier name, method of transportation, and service level used when the order is released. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab.
  • Title: Implement Source Organization
    Read Only: true
    Maximum Length: 100
    Source organization for the released order.
  • Value that uniquely identifies the item.
  • Title: Item
    Maximum Length: 300
    Name of the item associated with the demand.
  • Title: Item Description
    Read Only: true
    Maximum Length: 240
    Description of the item associated with the demand.
  • Read Only: true
    Date when the demand was most recently updated.
  • Read Only: true
    Maximum Length: 64
    User who most recently updated the demand.
  • Title: Latest Acceptable Date
    Read Only: true
    Date beyond which the demand line must not be promised.
  • Title: Line Number
    Read Only: true
    Maximum Length: 100
    Line number associated with the demand.
  • Links
  • Title: Lot
    Read Only: true
    Lot number associated with an expired on-hand lot.
  • Read Only: true
    Maximum Length: 200
    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.
  • Value that indicates the release status of the order. Valid values are 1: Marked For Release, 2: Not Marked For Release. When marking or not marking orders for release, the request body must include only the MarkForReleaseOption attribute.
  • Title: Material Available Date
    Read Only: true
    Date when the total quantity is available.
  • Read Only: true
    Text of the error message, if any, encountered when creating or updating a demand.
  • Title: Need-by Date
    Read Only: true
    Date by when the demand quantity is needed.
  • Title: Old Due Date
    Read Only: true
    Date when the demand quantity was originally due. This attribute value is extracted from the source application.
  • Read Only: true
    Number that identifies the execution sequence of the operation.
  • Title: Order Date Type
    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.
  • 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.
  • Title: Order Number
    Read Only: true
    Maximum Length: 4000
    Order number associated with the sales order.
  • Title: Order Quantity
    Read Only: true
    Quantity associated with the demand.
  • Abbreviation that identifies the type of order. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE.
  • Title: Order Type
    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.
  • Title: Organization
    Maximum Length: 49
    Name of the organization associated with the order.
  • Value that uniquely identifies the organization.
  • Title: Organization Time Zone
    Read Only: true
    Maximum Length: 100
    Time zone of the organization associated with the demand.
  • Read Only: true
    Maximum Length: 100
    Abbreviation that identifies the base currency of the organization.
  • Read Only: true
    Value that uniquely identifies the requested item.
  • Title: Original Item Quantity
    Read Only: true
    Demand quantity of the original item, which may be different from the order quantity, if substitution is allowed.
  • Title: Original Need-by Date
    Read Only: true
    Date when the order is needed. This value is extracted from the source application.
  • Value that uniquely identifies the plan.
  • Title: Planned Arrival 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.
  • Title: Planner
    Read Only: true
    Maximum Length: 10
    Abbreviation that identifies the planner responsible for the item.
  • Title: Planner Description
    Read Only: true
    Maximum Length: 100
    Description of the planner responsible for the item.
  • Title: Make or Buy
    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.
  • Value that uniquely identifies the ID of the project group associated with the demand in the exception of an attribute-based plan.
  • Value that uniquely identifies the ID of the project associated with the demand in the exception of an attribute-based plan.
  • Title: Quantity by Due Date
    Read Only: true
    Quantity that can be provided by the due date. For example, the order quantity may be 100 units, but only 50 units may be available by the due date.
  • Read Only: true
    Maximum Length: 400
    Errors that are generated in the release process.
  • Title: Release Status
    Code that indicates the release status of the order. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_RELEASE_STATUS.
  • Read Only: true
    Maximum Length: 80
    Value that indicates the release status of the order. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_RELEASE_STATUS.
  • Title: Requested Item
    Read Only: true
    Maximum Length: 4000
    Name of the item that was originally requested which, due to item substitution, can be different from the item used to fulfill the demand.
  • Title: Requested Item Description
    Read Only: true
    Maximum Length: 4000
    Description of the item that's being requested.
  • Title: Rescheduled
    Value that indicates whether the order has been rescheduled or not. Contains one of the following values: 1 or 2. If 1, then the order has been rescheduled. If 2, then the order hasn't been rescheduled.
  • Read Only: true
    Text that identifies whether the row is new or modified. Valid values are yes or null. If yes, then the row is new or modified. If null, then the row isn't new or modified.
  • Read Only: true
    Value that indicates whether the demand is a constrained planned order demand. Valid values are 1 or null. If 1, then the demand is a constrained planned order demand. If not 1, then the demand isn't a constrained planned order demand.
  • Read Only: true
    Value that indicates whether the demand is part of the total demand. Valid values are 1 or null. If 1, then the demand is part of the total demand. If not 1, then the demand isn't part of the total demand.
  • Title: Scheduled Arrival Date
    Read Only: true
    Date when the demand has been scheduled to arrive at a customer site.
  • Title: Scheduled Ship Date
    Read Only: true
    Date when the demand has been scheduled to be shipped.
  • Title: Schedule Name
    Read Only: true
    Maximum Length: 4000
    Name of the supply or demand schedule associated with an order.
  • Read Only: true
    Value that uniquely identifies the segment.
  • Title: Segment
    Read Only: true
    Maximum Length: 120
    Name of the segment used for a set of items.
  • Read Only: true
    Selling price of an item on the order line.
  • Read Only: true
    Maximum Length: 15
    Shipping calendar associated with the order.
  • 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.
  • Title: Shipping Method
    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.
  • Title: Ship To
    Read Only: true
    Maximum Length: 4000
    Abbreviation that indicates the specific ship-to location.
  • Value that uniquely identifies the simulation set used in the plan, if any.
  • Title: Source Order
    Read Only: true
    Maximum Length: 50
    Value that identifies the order number in the source application against which fulfillment line has been created.
  • Title: Source Order Line
    Read Only: true
    Maximum Length: 50
    Value that identifies the order line number in the source application against which fulfillment line has been created.
  • Title: Source Organization
    Maximum Length: 49
    Organization that will source the order.
  • Value that uniquely identifies the source organization.
  • Maximum Length: 12
    Value that identifies the data table source of the supply.
  • Title: Source Time Zone
    Read Only: true
    Maximum Length: 100
    Time zone associated with the entity that's sourcing the order. The sourcing entity can be a supplier or an organization.
  • Title: Subinventory
    Read Only: true
    Maximum Length: 40
    Subinventory code associated with the demand.
  • Title: Suggested Due Date
    Read Only: true
    Date when the demand is recommended to be completed.
  • Title: Suggested Order Date
    Read Only: true
    Date when the order is recommended to be placed.
  • Title: Suggested Ship Date
    Read Only: true
    Date when the order is recommended to be shipped.
  • Title: Supplier
    Maximum Length: 4000
    Name of the source supplier.
  • Value that uniquely identifies the supplier.
  • Title: Supplier Site
    Maximum Length: 4000
    Abbreviation that indicates the specific supplier ship-from location.
  • Value that uniquely identifies the supplier site.
  • Value that uniquely identifies the ID of the task associated with the demand in the exception of an attribute-based plan.
  • Value that uniquely identifies the demand. This value is internally generated by the application.
  • Title: Transit Lead Time
    Read Only: true
    Number of days that the demand is in transit between two locations.
  • Title: Unit Number
    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.
  • Read Only: true
    Maximum Length: 200
    Name of the unit of measure that's associated with the order quantity.
  • Title: UOM
    Read Only: true
    Abbreviation that identifies the unit of measure associated with the order quantity.
  • Title: Using Assembly
    Maximum Length: 4000
    For component demands, this field refers to the assembly item that uses this item as a component.
  • Title: Zone
    Read Only: true
    Maximum Length: 400
    Region or zone where the demand quantity is being shipped.
Nested Schema : replenishmentPlans-PlanningSupplies-item-response
Type: object
Show Source
  • Read Only: true
    Maximum Length: 80
    Value that indicates the action recommended by planning. A list of accepted values is defined in the lookup type ORA_MSC_ACTIONS.
  • Read Only: true
    Code that indicates the type of recommended change made by the planning engine to the supply or demand. Valid values are 1: Cancel, 2: Reschedule in, 3: Reschedule out, 4: Release, 5: Release reservation, 6: None, and 7: Reschedule and release reservation. A list of accepted values is defined in the lookup ORA_MSC_ACTIONS.
  • Title: Actual Start Date
    Read Only: true
  • Read Only: true
    Maximum Length: 4000
    Indicates whether the planned order uses an alternate facility. Valid values are Yes or No. If Yes, then the planned order uses an alternate facility. If No, then the planned order doesn't use an alternate facility. Only applicable for constrained plans.
  • Read Only: true
    Maximum Length: 4000
    Indicates whether the planned order uses an alternate resource. Valid values are Yes or No. If Yes, then the planned order uses an alternate resource. If No, then the planned order doesn't use an alternate resource. Only applicable for constrained plans.
  • Read Only: true
    Maximum Length: 4000
    Indicates whether the planned order uses an alternate supplier. Valid values are Yes or No. If Yes, then the planned order uses an alternate supplier. If No, then the planned order doesn't use an alternate supplier. Only applicable for constrained plans.
  • Read Only: true
    Maximum Length: 4000
    Indicates whether the planned order uses an alternate work definition. Valid values are Yes or No. If Yes, then the planned order uses an alternate work definition. If No, then the planned order doesn't use an alternate work definition. Only applicable for constrained plans.
  • Title: Asset
    Read Only: true
    Maximum Length: 80
    Number that identifies the asset associated with a maintenance work order.
  • Value that uniquely identifies the sequence in which a component is used within an operation.
  • Title: Buyer-Managed Transportation
    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.
  • Title: Buyer
    Read Only: true
    Name of the buyer associated to the item.
  • Read Only: true
    Maximum Length: 200
    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.
  • 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.
  • Value that uniquely identifies the carrier.
  • Read Only: true
    Value that uniquely identifies the catalog.
  • Read Only: true
    Value that uniquely identifies the category.
  • Title: Category
    Read Only: true
    Maximum Length: 4000
    Name of the category to which the item is assigned.
  • Read Only: true
    Maximum Length: 4000
    Organization code of an organization that's modeled as a child organization with a modeled subinventory code.
  • Read Only: true
    Value that uniquely identifies the child organization.
  • Value that uniquely identifies the cluster.
  • Name of the cluster.
  • Title: Consumption Start Date
    Read Only: true
    Date when a supply starts being consumed by demands.
  • Title: Contributes to Demand Lateness
    Read Only: true
    Indicates whether the supply is on the critical path leading to a demand that's satisfied late. Valid values are 1 or 2. If 1, then the supply is on the critical path leading to a demand that's satisfied late. If 2, then the supply isn't on the critical path leading to a demand that's satisfied late. Only applicable for constrained plans.
  • Title: Contributes to Overload
    Read Only: true
    Indicates whether the supply contributes to a capacity overload. Valid values are 1 or 2. If 1, then the supply contributes to a capacity overload. If 2, then the supply doesn't contribute to a capacity overload. Only applicable for constrained plans.
  • Read Only: true
    Meaning associated with the ContributesDmdLateness attribute. Value values are Yes and No.
  • Read Only: true
    Maximum Length: 4000
    Meaning associated with the ContributesOverload attribute. Value values are Yes and No.
  • Read Only: true
    Maximum Length: 64
    User who created the order.
  • Read Only: true
    Date when the user created the order.
  • Title: Customer
    Maximum Length: 4000
    Name of the customer associated with the drop ship purchase order.
  • Value that uniquely identifies the customer.
  • Title: Customer Site
    Maximum Length: 4000
    Code associated with a specific customer ship-to location.
  • Value that uniquely identifies the customer site.
  • 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.
  • Title: Days Past Due
    Read Only: true
    Number of days that the supply date is in the past.
  • Title: Destination Time Zone
    Read Only: true
    Maximum Length: 100
    Time zone associated with the entity that's receiving the order. The destination entity can be a customer or an organization.
  • Read Only: true
    Maximum Length: 200
    Value that indicates where the supply is destined. A list of accepted values is defined in the lookup type ORA_MSC_DESTINATION_TYPE.
  • Read Only: true
    Maximum Length: 18
    Abbreviation that identifies the destination organization for an order.
  • Value of the transaction ID of the related supply.
  • Title: Destination Type
    Code that identifies where the supply is destined. A list of accepted values is defined in the lookup type ORA_MSC_DESTINATION_TYPE.
  • Title: Earliest Start Date
    Read Only: true
    Earliest date on which a supply can start based on the lead times of all its upstream supplies, or its planning time-fence date, or based on the constrained capacity of a resource or supplier. This date is calculated by constraint-based plans
  • Percentage value by which the inventory excess at the source location is reduced.
  • Read Only: true
    Maximum Length: 100
    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.
  • 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.
  • Title: Expiration Date
    Date when the existing lot associated with the supply expires.
  • Value used by the planning engine to identify the type of order at a more granular level than the OrderType attribute.
  • Title: Firm Date
    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.
  • Title: Firm Status
    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.
  • Title: Firm Quantity
    Fixed quantity of supply. This attribute value can't be changed by planning and is only populated when the firm status is firm.
  • Date when supply begins. This attribute is a fixed value that can't be rescheduled by planning and is only populated when the firm status is firm.
  • Title: Firm Start Quantity
    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.
  • Title: Firm Status
    Maximum Length: 200
    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.
  • Read Only: true
    Contains one of the following values: 1 or 2. If 1, then the make order has an associated firm component. If 2, then the make order doesn't have an associated firm component.
  • Read Only: true
    Contains one of the following values: 1 or 2. If 1, then the make order has an associated firm resource. If 2, then the make order doesn't have an associated firm resource.
  • Title: Hold Date
    Read Only: true
    Date on which the on-hand inventory lot is no longer on hold.
  • Title: Implement Order Type
    Value that indicates the type of order to be implemented. Valid values are 1: None, 2: Purchase requisition, 3: Work order, or 5: Internal requisition. A list of accepted values is defined in the lookup type ORA_MSC_WORKBENCH_IMPLEMENT_AS.
  • Title: Implement Date
    Date when the order is released.
  • Title: Implement Dock Date
    Date when the material should be on the receiving dock when the order is released.
  • Title: Implemented Quantity
    Cumulative quantity that has been released to date.
  • Title: Implement Firm
    Value that indicates whether the order is firm or not. Valid values are 1: Firm and 2: Not Firm. A list of accepted values is defined in the lookup type MSC_YES_NO.
  • Read Only: true
    Maximum Length: 200
    Status to use when the order is released. Valid values include Firm and Not firm. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_FIRM_STATUS.
  • Title: Implement Work Order Number
    Maximum Length: 120
    Job name of the work order to be created when the order is released.
  • Title: Implement Location
    Maximum Length: 400
    Value that identifies the deliver-to location to use when the order is released.
  • Value that uniquely identifies the deliver-to location to use when the order is released.
  • Read Only: true
    Maximum Length: 4000
    Value that indicates the type of order to use when the order is released. A list of accepted values is defined in the lookup type ORA_MSC_WORKBENCH_IMPLEMENT_AS.
  • Title: Implement Quantity
    Quantity of the order that's released.
  • Title: Implement Ship Date
    Date when the order is shipped.
  • Maximum Length: 30
    Value that indicates the shipping method to use when the order is released. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab.
  • Title: Implement Shipping Method
    Maximum Length: 400
    Value that indicates the shipping method to use when the order is released, or is a concatenation of carrier name, method of transportation, and service level to use when the order is released. Review and update the value for this attribute using the Maintain Supply Network Model task, and the Interlocation Shipping Networks tab.
  • Title: Implement Source Organization
    Maximum Length: 100
    Source organization used for the order that's released.
  • Value that uniquely identifies the source organization to use when the order is released.
  • Title: Implement Status
    Read Only: true
    Maximum Length: 200
    Status of the order to use when the order is released. Valid Values are Unreleased or Released.
  • Title: Implement Status
    Abbreviation that identifies the status to use when the order is released. Valid values are 1 or 3. If 1, then the order isn't released. If 3, then the order is released.
  • Title: Implement Supplier
    Maximum Length: 360
    Name of the supplier for the order that's released.
  • Title: Implement Supplier Site
    Maximum Length: 300
    Abbreviation that indicates the specific supplier ship-from location to use when the order is released.
  • Value that uniquely identifies the supplier to use when the order is released.
  • Value that uniquely identifies the specific supplier ship-from location to use when the order is released.
  • Initial excess quantity at the source location before inventory rebalancing.
  • Initial shortage quantity at the destination location before inventory rebalancing.
  • Value that uniquely identifies the item.
  • Title: Item
    Maximum Length: 300
    Name of the item associated with the supply.
  • Title: Item Description
    Read Only: true
    Maximum Length: 240
    Description of the item that's associated with the supply.
  • Read Only: true
    Date when the order was most recently updated.
  • Read Only: true
    Maximum Length: 64
    User who most recently updated the supply.
  • Title: Latest Start Date
    Read Only: true
    Latest date on which a supply can start. This date is computed by offsetting the lead time of the supply from its need-by date. This date is calculated by constraint-based plans.
  • Title: Line Number
    Read Only: true
    Maximum Length: 100
    Number that identifies the order line.
  • Links
  • Title: Lot
    Read Only: true
    Maximum Length: 80
    Number that identifies the lot of the on-hand supply.
  • Read Only: true
    Maximum Length: 100
    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.
  • Value that indicates the release status of the order. Valid values are 1: Marked For Release or 2: Not Marked For Release. When marking or not marking orders for release, the request body must include only the MarkForReleaseOption attribute.
  • Read Only: true
    Text of the error message, if any, encountered when creating or updating a supply.
  • Value that uniquely identifies the mode of transportation that's planned to be used to ship an order from the source organization or supplier. A list of accepted values is defined in the MSC_SR_LOOKUP_VALUES_TL table where LOOKUP_TYPE is WSH_MODE_OF_TRANSPORT.
  • Title: Need-by Date
    Read Only: true
    Date when the supply quantity is needed.
  • Title: Old Dock 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.
  • Title: Old Due Date
    Read Only: true
    Date when the order was originally due. This attribute value is extracted from the source application.
  • Read Only: true
    Number that identifies the execution sequence of the operation.
  • Title: Order Number
    Read Only: true
    Maximum Length: 4000
    Number that identifies the order associated with the supply.
  • Title: Order Quantity
    Read Only: true
    Quantity associated with the supply.
  • 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.
  • Abbreviation that identifies the type of order. A list of accepted values is defined in the lookup type MSC_ORDER_TYPE.
  • Title: Order Type
    Maximum Length: 4000
    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.
  • Title: Organization
    Maximum Length: 49
    Name of the organization associated with the order.
  • Value that uniquely identifies the organization.
  • Title: Organization Time Zone
    Read Only: true
    Maximum Length: 100
    Time zone associated with an organization.
  • Read Only: true
    Abbreviation that identifies the base currency of the organization.
  • Read Only: true
    Value that uniquely identifies the requested item.
  • Title: Requested Item
    Read Only: true
    Maximum Length: 4000
    Name of the requested item associated with the demand.
  • Title: Original Need-by Date
    Read Only: true
    Date when the order was originally needed. This value is extracted from the source application.
  • Title: Pegged to Firm
    Read Only: true
    Indicates whether the supply pegs to a downstream supply that's firm. Valid values are 1 or 2. If 1, then the supply pegs to a downstream supply that's firm. If 2, then it doesn't peg to a downstream supply that's firmed.
  • Read Only: true
    Maximum Length: 4000
    Value that indicates whether the supply pegs to a downstream supply that's firm. Valid values are: Yes or No. If Yes, then supply is pegged to a downstream supply that's firm. If No, then it isn't pegged to a downstream supply that's firmed.
  • Value that uniquely identifies the plan.
  • Title: Planner
    Read Only: true
    Maximum Length: 10
    Abbreviation that identifies the planner responsible for the item.
  • Title: Planner Description
    Read Only: true
    Maximum Length: 100
    Description of the planner responsible for the item.
  • Title: Make or Buy
    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.
  • Value that uniquely identifies the manufacturing process that was used for the make order.
  • Value that uniquely identifies the ID of the project group associated with the demand in the exception of an attribute-based plan.
  • Value that uniquely identifies the ID of the project associated with the demand in the exception of an attribute-based plan.
  • Read Only: true
    Maximum Length: 400
    Errors that are generated in the release process.
  • Title: Release Status
    Code that indicates the release status of the order. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_RELEASE_STATUS.
  • Read Only: true
    Maximum Length: 80
    Value that indicates the release status of the order. A list of accepted values is defined in the lookup type ORA_MSC_ORDER_RELEASE_STATUS.
  • 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.
  • Value that indicates whether to perform inventory rebalancing. Valid values are 1 or 2. If 1, then perform inventory rebalancing. If 2, then don't perform inventory rebalancing. The default value is 2.
  • Title: Requested Item
    Read Only: true
    Maximum Length: 4000
    Name of the item that was originally requested which, due to item substitution, can be different from the item used to fulfill the demand.
  • Title: Requested Item Description
    Read Only: true
    Maximum Length: 4000
    Description of the item that's being requested.
  • Read Only: true
    Maximum Length: 100
    Value that indicates whether the order has been rescheduled. Contains one of the following values: Yes or No. If Yes, then the order has been rescheduled. If No, then the order hasn't been rescheduled.
  • Title: Reschedule Days
    Read Only: true
    Number of days to reschedule for a supply order. The reschedule days is the difference between the original due date and the revised due date. A negative value indicates the order is rescheduled to an earlier date.
  • Title: Rescheduled
    Value that indicates whether the order has been rescheduled or not. Contains one of the following values: 1 or 2. If 1, then the order has been rescheduled. If 2, then the order hasn't been rescheduled.
  • Value that uniquely identifies the routing that was used for the make order.
  • Read Only: true
    Text that identifies whether the row is new or modified. Valid values are yes or null. If yes, then the row is new or modified. If null, then the row isn't new or modified.
  • Title: Scheduled Ship Date
    Read Only: true
    Date when the order is scheduled to be shipped.
  • Title: Schedule Name
    Read Only: true
    Name of the supply schedule associated with an order.
  • Read Only: true
    Value that uniquely identifies the segment.
  • Title: Segment
    Read Only: true
    Maximum Length: 120
    Name of the segment used for a set of items.
  • Read Only: true
    Selling price of an item on the order line.
  • Value that uniquely identifies the service level to use to ship an order from the source organization or supplier. A list of accepted values is defined in the MSC_SR_LOOKUP_VALUES_TL table where LOOKUP_TYPE is WSH_SERVICE_LEVELS.
  • Title: Shared Supply
    Read Only: true
    Indicates whether the supply is shared by more than one demand. Valid values are 1 or 2. If 1, then the supply is shared by more than one demand. If 2, then the supply isn't shared.
  • Read Only: true
    Maximum Length: 4000
    Value that indicates whether the supply is shared by more than one demand. Valid values are: Yes or No. If Yes, then supply is shared by more than one demand. If No, then it isn't shared by more than one demand.
  • Read Only: true
    Maximum Length: 15
    Shipping calendar associated with the order.
  • 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.
  • Title: Shipping Method
    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.
  • Title: Ship To
    Read Only: true
    Maximum Length: 4000
    Abbreviation that identifies the specific ship-to location.
  • Percentage value by which the inventory shortage at the destination location is reduced.
  • Value that uniquely identifies the simulation set used in the plan, if any.
  • Title: Source Organization
    Maximum Length: 49
    Organization that will source the order.
  • Value that uniquely identifies the source organization.
  • Maximum Length: 12
    Value that identifies the data table source of the supply.
  • Title: Source Time Zone
    Read Only: true
    Maximum Length: 100
    Time zone associated with the entity that's sourcing the order. The sourcing entity can be a supplier or an organization.
  • Value that identifies the type of planned order to be created. Valid values are 1, 2, or 3. If 1, then a planned make order is created. If 2, then a planned buy order is created. If 3, then a planned transfer order is created.
  • Title: Subinventory
    Maximum Length: 40
    Subinventory code associated with the supply.
  • Read Only: true
    Maximum Length: 40
    Subinventory code of an organization that's a modeled as a child of a parent organization, and from which supply is recast into a modeled subinventory in its parent organization.
  • Read Only: true
    Value that uniquely identifies the substitute item.
  • Read Only: true
    Maximum Length: 4000
    Meaning associated with the SubstituteComponentUsed attribute. Valid values are Yes and No.
  • Title: Suggested Dock Date
    Read Only: true
    Date when the order is recommended to arrive at the receiving dock.
  • Title: Suggested Due Date
    Read Only: true
    Date when a supply is expected to be completed.
  • Title: Suggested Order Date
    Read Only: true
    Date when an order is recommended to be placed.
  • Title: Suggested Ship Date
    Read Only: true
    Date when the order is recommended to be shipped.
  • Title: Suggested Start Date
    Read Only: true
    Date when work on the order is recommended to begin.
  • Title: Supplied Item
    Read Only: true
    Maximum Length: 4000
    Name of the supplied item.
  • Title: Supplied Item Description
    Read Only: true
    Maximum Length: 4000
    Description of the supplied item.
  • Title: Supplier
    Maximum Length: 4000
    Name of the source supplier.
  • Value that uniquely identifies the supplier.
  • Title: Supplier Site
    Maximum Length: 4000
    Abbreviation that indicates the specific supplier location from where the item is being sourced.
  • Value that uniquely identifies the supplier site.
  • Value that uniquely identifies the ID of the task associated with the demand in the exception of an attribute-based plan.
  • Value that uniquely identifies the supply transaction. This value is internally generated by the application.
  • Title: Transit Lead Time
    Read Only: true
    Number of days that the supply is in transit between two locations.
  • Read Only: true
    Maximum Length: 200
    Name of the unit of measure associated with the order quantity.
  • Title: UOM
    Read Only: true
    Abbreviation that identifies the unit of measure associated with the order quantity.
  • Title: Uses Order Modifier
    Read Only: true
    Meaning associated with the UsesOrderModifierIndicator attribute. Valid values are Yes and No.
  • Read Only: true
    Maximum Length: 4000
    Value that indicates whether the supply quantity has been determined by applying an order modifier. Valid values are: Yes or No. If Yes, then an order modifier was applied to the supply quantity. If No, then it hasn't.
  • Title: Zone
    Read Only: true
    Maximum Length: 400
    Region or zone where the demand quantity is being shipped.
Nested Schema : replenishmentPlans-Runs-item-response
Type: object
Show Source
  • Contains one of the following values: true or false. If true, then archive the plan before the next plan is run. If false, then don't archive. You can archive a plan only if you enable it for archiving. The default value is false.
  • Contains one of the following values: true or false. If true, then the Prepare for Buyer Planning scheduled process is executed after the run plan scheduled process completes. If false, then the Prepare for Buyer Planning scheduled process isn't executed. The default value is false.
  • Contains one of the following values: true or false. If true, then calculate policy parameters. If false, then don't calculate policy parameters. The default value is false.
  • Contains one of the following values: true or false. If true, then calculate replenishments. If false, then don't calculate replenishments. The default value is true.
  • Contains one of the following values: true or false. If true, then consider the supply plan specified in the plan option. If false, then don't consider the supply plan specified in the plan option. The default value is false.
  • Date and time when the plan run completed.
  • Value that uniquely identifies the process.
  • Maximum Length: 64
    Login that the user used when launching the process.
  • Contains one of the following values: true or false. If true, then run the plan regardless of the current plan status. If false, then run the plan only if the plan is ready to run. The default value is false.
  • List of forecast profiles that the plan run uses. A comma separates each forecast profile name.
  • Contains one of the following values: true or false. If true, then generate a forecast. If false, then don't generate a forecast. The default value is false.
  • Value that uniquely identifies the scheduled process.
  • Links
  • Text of the error messages, if any, that occurred when running the scheduled process.
  • Specifies whether data is to be refreshed or not. Valid values are 1 or 3. If 1, then all data is refreshed. If 3, then data isn't refreshed. The default value is 1.
  • Value that uniquely identifies the plan.
  • Contains one of the following values: 1 or 2. If 1, then perform inventory rebalancing. If 2, then don't perform inventory rebalancing. The default value is 2.
  • Date and time to start the scheduled process.
  • Status of the plan run. Contains one of the following values. 0: completed, 1: processing, 2: error, or 3: warning. A list of accepted values is defined in the lookup type ORA_MSC_PLAN_STATUS_TYPE.
  • Notes provided by the user while submitting the plan from the Run Plan page.
Back to Top

Examples

This example describes how to get all plans.

Example cURL Command

Use the following cURL command to submit a request on the REST resource:

curl -u username:password "https://servername/fscmRestApi/resources/version/replenishmentPlans"

Example Response Body

The following shows an example of the response body in JSON format.


"items": [
{
	"AggregateNonkeyCustomerData": null,
	"ArchiveTimeHierarchy": null,
	"ArchiveTimeLevel": null,
	"ArchivePlan": null,
	"MeasureCatalogForArchival": 1934,
	"ArchiveVersionDays": null,
	"PlanName": "REPL-MG2",
	"CreatedBy": "REPL_USER",
	"CreationDate": "2019-10-29T08:06:40.001+00:00",
	"CutoffDate": "2030-02-03",
	"CalendarCode": "10002",
	"DeleteArchive": 4,
	"Description": "REPL-MG2",
	"DemandPlanStartDate": null,
	"DemandPlanCompletionDate": null,
	"EnableArchive": 2,
	"ExceptionSet": null,
	"PlanningCalendar": "10002",
	"ForecastingTimeLevel": 1,
	"HasRun": 1,
	"IncludeTransferOrders": 1,
	"ItemListPrice": 1,
	"LastUpdatedDate": "2019-11-07T10:45:42.561+00:00",
	"LastUpdatedBy": "APS_ALL",
	"PlanDimensionCatalog": 104,
	"NumberOfBuckets": 31,
	"PlanId": 300100181500814,
	"PlanMeasureCatalog": 1933,
	"PlanOwner": "300100176248504",
	"PlanHorizonStartDate": "2030-01-04",
	"PlanType": 5,
	"PolicyAssignmentSetId": 300100181500739,
	"PlanAccess": 1,
	"SimulationSet": null,
	"PlanStatus": 0,
	"ShortPlanId": 168425,
	"AutoRelease": 2,
	"ForecastOption": 1,
	"PolicyParametersOption": 1,
	"ReplenishmentsOption": 1,
	"IncrementalPlanningOption": 2,
	"LeadTimeMultiplier": null,
	"PolicyComparisonOption": 2,
	"PolicyComparisonThreshold": null,
	"TimeHorizonForDemand": 2,
	"PlanTimeLevel": 1,
	"SegmentGroup": 300100181500544,
	"Segments": "Seg5,Seg2,Seg1,Seg6,Seg3,Seg4",
	"PlanOrganizationLevelMembers": "M1,D1,M3,M2",
	"PriceLists": "",
	"ForecastProfiles": "(Forecast Shipments,Final Shipments History,Shipments Forecast,,730,2027-09-06,2030-01-03,26,0,2030-02-02) ",
	"AssignmentSetName": "YM-ASSGN-REPL1",
	"PolicyAssignmentSetName": "MG-AUTO",
	"ReplSupplyCutoffDays": null,
	"links": [
	{
		"rel": "self",
		"href": "https://servername/fscmRestApi/resources/version/replenishmentPlans/300100181500814",
		"name": "replenishmentPlans",
		"kind": "item",
		"properties": {
			"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78"
		}
	},
	{
		"rel": "canonical",
		"href": "https://servername/fscmRestApi/resources/version/replenishmentPlans/300100181500814",
		"name": "replenishmentPlans",
		"kind": "item"
	},
	{
		"rel": "lov",
		"href": "https://servername/fscmRestApi/resources/version/replenishmentPlans/300100181500814/lov/PolicyAssignmentSetVO",
		"name": "PolicyAssignmentSetVO",
		"kind": "collection"
	},
	{
		"rel": "child",
		"href": "https://servername/fscmRestApi/resources/version/replenishmentPlans/300100181500814/child/Runs",
		"name": "Runs",
		"kind": "collection"
	}

	
Back to Top