Get one plan
get
/fscmRestApi/resources/11.13.18.05/inventoryPlans/{PlanId}
Request
Path Parameters
-
PlanId(required): integer
The value of this parameter could be a hash of the key that is used to uniquely identify the resource item. The client should not generate the hash key value. Instead, the client should query on the collection resource with a filter to navigate to a specific resource item. For example: products?q=InventoryItemId=
Query Parameters
-
dependency: string
This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
Format: <attr1>=<val1>,<attr2>=<value2> -
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : inventoryPlans-item-response
Type:
Show Source
object-
AppliesToOrderTypes: string
Maximum Length:
255List of demand order types to which the number of days for the demand cutoff attribute applies. Each value is separated by a comma. Valid values are: 1029 - Forecast, 1030 - Sales order, and 1008 - Manual demand. If the value is null, no order types are considered for the demand cutoff. The default value is null. This is only used if the number of days for the demand cutoff attribute is populated. -
ArchivePlan: integer
Contains one of the following values: 1 or 2. If set to 1, the plan will be archived before the next run starts. Note that you can archive the plan only if archiving is enabled. If set to 2, the plan won't be archived.
-
ArchiveTimeHierarchy: integer
(int64)
Time hierarchy used by the application to archive the plan.
-
ArchiveTimeLevel: integer
(int64)
Time hierarchy level used by the application to archive the plan. The Archive Time Hierarchy attribute determines the available values for this attribute.
-
ArchiveVersionDays: integer
Version used by the application to archive the plan.
-
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 available values for this attribute.
-
CalendarCode: string
Maximum Length:
22Abbreviation used to identify the inventory planning calendar. -
CalSsQuantEndItems: integer
(int32)
Calculation of safety stock for the end items.
-
ComponentItems: array
Component Items
Title:
Component ItemsItem structure components that are part of a supply plan. -
CreatedBy: string
Read Only:
trueMaximum Length:64Person who created the inventory plan. -
CreationDate: string
(date-time)
Read Only:
trueDate the inventory plan was created. -
CutoffDate: string
(date)
Final date of the planning period when demand and supply are no longer considered.
-
DeleteArchive: integer
(int32)
Contains one of the following values: 1 or 2. If set to 1, the plan deletes archived attributes. If set to 2, the plan doesn't delete archived attributes. The default value is 2.
-
DemandSchedules: string
A compilation of demand schedules included in the plan's scope. Each value is separated by a comma. The values consist of Demand Schedule Name, Description, Demand Schedule Type, Demand Plan Output Measure, and Ship to Consumption Level. Each group of demand schedules is enclosed in parentheses.
-
Description: string
Maximum Length:
100Description of the plan. -
EnableForArchiving: integer
(int32)
Contains one of the following values: 1 or 2. If set to 1, the plan measures are archived through the archive plan option. If set to 2, the plan measures aren't archived.
-
EnableMultiThreading: integer
(int32)
Contains one of the following values: 1 or 2. If set to 1, the plan will use substitute items when required. If set to 2, substitute items won't be used. The default value is 2.
-
ExceptionSet: integer
(int64)
Exception set that the plan references. The exception set determines the types of exceptions the plan creates.
-
ExplodeModelForecasts: integer
(int32)
Contains one of the following values: 1 or 2. If set to 1, the plan explodes the forecast of a model to its option level. If set to 2, the plan doesn't explode the forecast of a model to its option level. The default value is 2.
-
ExposeToAnalytic: integer
(int32)
Plan output is available to the analytic module.
-
FirstPlanningBucketCode: integer
(int32)
Indicates the type of time bucket for the initial inventory planning buckets. The valid values depend on the inventory planning calendar type. For a calendar type of 5 (manufacturing), accepted values are listed in the lookup type ORA_MSC_TIME_LEVELS_MFG. For a calendar type of 1 (Gregorian), accepted values are found in ORA_MSC_TIME_LEVELS_GREGORIAN. For a calendar type of 3 (fiscal), refer to ORA_MSC_TIME_LEVELS_FISCAL for the accepted values.
-
FirstPlanningBucketName: string
Read Only:
trueMaximum Length:40Meaning associated with the FirstPlanningBucketCode attribute. -
FirstPlanningBucketNumber: number
Number of inventory planning buckets to create for the first set of inventory planning time buckets. For example, if the FirstPlanningBucketName attribute is Day, this defines the number of daily inventory planning buckets that are created when the plan is run.
-
ForecastError: integer
Forecast accuracy measure used by the plan to calculate safety stock. Contains one of the following values: 1 - Mean Absolute Deviation, 2 - Mean Absolute Percentage Error, or 3 - Intermittent. A list of accepted values is defined in the lookup type ORA_MSC_FORECAST_ERROR_TYPE.
-
GlobalFcstCalendarName: string
Maximum Length:
255Calendar used for spreading the global forecast. This field is enabled when the plan option Forecast Spreading is set to Spread forecast evenly. -
GlobalFcstDistrSetName: string
Maximum Length:
255Assignment set used to distribute the global forecast to the respective ship-from organizations. -
HasRun: integer
Contains one of the following values: 1 - The most recent plan run finished successfully, 0 - The most recent plan run failed, or Empty - The application hasn't run the plan.
-
HorizonForAverageDemand: number
Number of days used by planning to calculate the average daily demand.
-
IncludeProdMonitoringAlrts: integer
(int32)
Contains one of the following values: 1 or 2. If set to 1, the plan is enabled for production monitoring alerts. If set to 2, the plan doesn't provide production monitoring alerts.
-
InventoryParameterOverrides: string
Read Only:
trueMaximum Length:250List of parameters used to override the inventory engine's default behavior. -
InventoryPlannedItems: number
Read Only:
trueContains one of the following values: 1 - all items, 2 - demand-planned items and sales orders, 5 - demand-planned items and work-in-process components, 6 - demand-planned items, or 7 - demand-planned items, work-in-process components, and sales orders. A list of accepted values is defined in the lookup type ORA_MSC_PLANNED_ITEMS. -
InventoryPlanningCalendar: string
Read Only:
trueMaximum Length:4000Name associated with the inventory planning calendar. -
ItemListPrice: integer
(int32)
Item list price used by the inventory plan.
-
Items: array
Items
Title:
ItemsThe Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the plan. -
LastUpdatedDate: string
(date-time)
Read Only:
trueDate when the user most recently updated the plan. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MaximumVarSafetyStockValue: number
Maximum percent difference allowed between the safety stock quantity in one interval and the next.
-
MeasureCatalogForArchival: string
Measure catalog used by the application to archive the plan.
-
MinimumVarSafetyStockValue: number
Minimum percent difference allowed between the safety stock quantity in one interval and the next.
-
Organizations: string
Collection of organization names and descriptions included in the scope of the plan. Each organization name is separated from its description by a comma, and each pair is enclosed in parentheses.
-
PastDueForecastBucket: integer
Number of time buckets (e.g., three weeks or two months). This attribute determines the time period before the plan start date to use as a threshold for copying past-due forecasts into the plan.
-
PlanAndSegmentExceptions: array
Plan and Segment Exceptions
Title:
Plan and Segment ExceptionsException details for the inventory plan. This can be used to capture any exceptions related to the inventory plan. -
PlanCompletionDate: string
(date-time)
Date when the planning process was completed.
-
PlanDimensionCatalog: integer
(int64)
Dimension catalog used by the inventory plan.
-
PlanHorizonDays: integer
This attribute isn't used.
-
PlanHorizonStartDate: string
(date)
Date when the plan starts planning demand and inventory.
-
PlanId: integer
(int64)
Value that uniquely identifies the plan.
-
PlanItemLevelMembers: string
List of level values in the item hierarchy to include in the scope of the plan. Each value is separated by a comma.
-
PlanMeasureCatalog: string
Measure catalog used by the inventory plan.
-
PlanName: string
Title:
NameMaximum Length:30Name of the plan. -
PlanningBucketType: integer
Type of planning buckets: Week, Period, or Month.
-
PlanOrganizationLevelMembers: string
List of level values in the organization hierarchy included in the scope of the plan. Each value is separated by a comma.
-
PlanOwner: string
Maximum Length:
64Owner of the plan. -
PlanStartDate: string
(date-time)
Date that represents the start date of the planning process.
-
PlanStatus: integer
Status of the plan run that was most recently completed. 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.
-
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.
-
PriceLists: string
List of price lists to consider in the plan. Each value is separated by a comma.
-
PrivatePlan: integer
Default Value:
1If the plan is private, it can only be used by the owner. -
Runs: array
Run Plan
Title:
Run PlanDetails about the inventory plan that can be used to run inventory plans. -
SafetyStockForecastPlan: string
Demand plan that includes the forecast and measures of forecast error used to determine safety stock.
-
SafetyStockServiceLevel: number
Percentage of service level used by the plan to calculate safety stock.
-
SecondPlanningBucketCode: integer
(int32)
Value that uniquely identifies the second planning bucket.
-
SecondPlanningBucketName: string
Read Only:
trueMaximum Length:40Name of the second planning bucket. -
SecondPlanningBucketNumber: number
Number that uniquely identifies the second planning bucket.
-
ShortPlanId: integer
Abbreviated value that uniquely identifies the inventory plan.
-
SimulationSet: integer
(int64)
Simulation set used by planning when the plan runs. A simulation set consists of adjustments made to inputs that affect the plan. You can use them to test different business scenarios, such as increasing available resource capacity.
-
SmMethodToCalSsInterval: integer
This attribute isn't used.
-
SsChngeIntervalDays: number
Number of days that uniquely specifies the safety stock change interval. The change interval is used to minimize fluctuations in safety stock, as daily changes can be cumbersome to manage.
Nested Schema : Component Items
Type:
arrayTitle:
Component ItemsItem structure components that are part of a supply plan.
Show Source
Nested Schema : Items
Type:
arrayTitle:
ItemsThe Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Plan and Segment Exceptions
Type:
arrayTitle:
Plan and Segment ExceptionsException details for the inventory plan. This can be used to capture any exceptions related to the inventory plan.
Show Source
Nested Schema : Run Plan
Type:
arrayTitle:
Run PlanDetails about the inventory plan that can be used to run inventory plans.
Show Source
Nested Schema : inventoryPlans-ComponentItems-item-response
Type:
Show Source
object-
AssemblyItem: string
Title:
Assembly ItemMaximum Length:250Name of the assembly item. -
AssemblyItemDescription: string
Title:
Assembly Item DescriptionMaximum Length:240Description of the assembly item. -
AssemblyItemId: integer
Unique identifier of the assembly item.
-
AssemblyItemUOM: string
Title:
Assembly Item UOMMaximum Length:400Unit of measure of the assembly item. -
AssemblyItemUOMCode: string
Title:
Assembly Item UOMMaximum Length:3Unit of measure code of the assembly item. -
AssemblyQuantity: number
Title:
Assembly QuantityQuantity of the assembly item. -
Basis: string
Title:
BasisRead Only:trueMaximum Length:80Identifies whether component item usage is based on the quantity of an item produced or for the entire lot. -
BillSequenceId: integer
Value that uniquely identifies the sequence in which a component is used within an operation.
-
BillSequenceIdSecondary: integer
Value that uniquely identifies the sequence in which a component is used within an operation.
-
ChangeIndicatorFlag: boolean
Read Only:
trueValue that identifies whether the component item has been modified. Valid values are true or false. If true, then the row is new or modified. If false, then the row isn't new or modified. -
ComponentItem: string
Title:
Component ItemMaximum Length:250Name of the component item being consumed. -
ComponentItemDescription: string
Title:
Component DescriptionMaximum Length:240Description of the component item being consumed. -
ComponentItemEffectiveEndDate: string
(date)
Title:
Component Item Effective End DateStart date of effectivity for this component. -
ComponentItemEffectiveStartDate: string
(date)
Title:
Component Item Effective Start DateEnd date of effectivity for this component. -
ComponentItemId: integer
Unique identifier of the component item.
-
ComponentItemUOM: string
Title:
Component UOMMaximum Length:400Unit of measure of the component item. -
ComponentItemUOMCode: string
Maximum Length:
3Unit of measure code of the component item. -
ComponentSequenceId: integer
Value that uniquely identifies the component on the source application instance.
-
ComponentUsageQuantity: number
Title:
Usage QuantityQuantity of the component to build one unit of item based on the component's primary UOM. -
ComponentYield: number
Title:
Component YieldFactor used to multiply component quantity with to obtain the total quantity used of a component that actually becomes part of an assembly. -
ContributeToYield: integer
(int32)
Title:
Contribute to YieldValue that represents whether the components is enabled for contributing to the yield. The values can be Yes or No. The default value is No. -
ContributeToYieldString: string
Title:
Contribute to YieldMaximum Length:40Value that represents whether the components is enabled for contributing to the yield. The values can be Yes or No. The default value is No. -
DataSecurityEditAllowed: string
Read Only:
trueMaximum Length:255Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
EnforceIntegerRequirement: string
Title:
Enforce Integer RequirementRead Only:trueMaximum Length:80Specifies whether the result of a component's calculated quantity or inverse quantity is required to be an integer. Valid values for this option are None, Round up, and Round down. -
FindNumber: integer
Title:
Find NumberNumber used to locate a specific instance of an item in a structure. This number enables users to define multiple occurrences of the same component for an assembly in its item structure. -
ItemSequence: integer
Title:
Material SequenceNumber that indicates the sequence for a component item for a work order operation. -
ItemStructureName: string
Title:
Item Structure NameMaximum Length:80Name for the categorization of an item structure, such as a design structure or manufacturing bill of material, that controls the usage and behavior of the structure. -
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueDate when the component item was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64Name of the user who last updated the component item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NewPlanId: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
NewPlanIdSecondary: integer
(int64)
Value that uniquely identifies the new plan that the duplication process creates.
-
NotesCount: integer
Title:
NotesRead Only:trueNumber of notes associated with this component item. -
OperationSequenceNumber: integer
Title:
Operation Sequence NumberRead Only:trueOrder in which the operation occurs. -
Organization: string
Read Only:
trueMaximum Length:255Name of the organization. -
OrganizationCode: string
Title:
OrganizationMaximum Length:49Organization code for the assembly item. -
OrganizationId: integer
Unique identifier of the organization.
-
OrganizationIdSecondary: integer
Unique identifier of the organization.
-
PlanId: integer
Value that uniquely identifies the supply plan associated with the component item
-
PlanIdSecondary: integer
Value that uniquely identifies the supply plan associated with the component item
-
PlanningPercentage: number
Title:
Planning PercentagePlanning factor for this component as a percentage. -
Primary: string
Title:
PrimaryRead Only:trueMaximum Length:80Indicates if the component item is the primary item structure. -
ProducedItemType: number
Title:
Structure Item TypeRead Only:trueStructure type of the produced item. Values can be Formula, Model, Option Class, or Standard. -
ProducedItemTypeStr: string
Title:
Structure Item TypeMaximum Length:40Structure type of the produced item. Values can be Formula, Model, Option Class, or Standard. -
SimulationSetId: integer
(int64)
Value that uniquely identifies the simulation set.
-
SimulationSetIdSecondary: integer
(int64)
Value that uniquely identifies the simulation set.
-
SupplyType: string
Title:
Supply TypeMaximum Length:4000Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE. -
WorkDefinitionName: string
Title:
Work DefinitionMaximum Length:300Name of the work definition associated with this item structure. -
WorkDefUsageQuantity: number
Title:
Work Definition QuantityNumber that represents the component requirement in the work definition.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : inventoryPlans-Items-item-response
Type:
Show Source
object-
ABCClass: string
Maximum Length:
40Code assigned to the item for classification purposes. Items are divided into categories called ABC classes, such as A, B, and C, according to a criterion such as revenue generation, turnover, or value. -
AcceptableEarlyDays: integer
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.
-
AllowUseOfCommonSupplies: integer
Read Only:
trueValue 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. -
AllowUseOfCommonSuppliesMeaning: string
Read Only:
trueMaximum Length:4000Indicates 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. -
AlternateUOM: string
Read Only:
trueMaximum Length:4000Secondary unit of measure for the item, represented as an alternate unit of measure in planning. -
AnnualCarryingCostPercentage: number
Percent of unit cost that represents the internal cost to stock one unit for one year.
-
ATPComponents: string
Read Only:
trueMaximum Length:1Number of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time. -
ATPComponentsMeaning: string
Read Only:
trueMaximum Length:4000Indicates whether to include additional components in the item structure for assemble-to-order and pick-to-order items when performing available-to-promise checking. Valid values are Yes and No. -
Attribute1: string
Read Only:
trueMaximum Length:20Value that identifies planning attribute number 1 for the descriptive flexfield. -
Attribute2: string
Read Only:
trueMaximum Length:20Value that identifies planning attribute number 2 for the descriptive flexfield. -
Attribute3: string
Read Only:
trueMaximum Length:20Value that identifies planning attribute number 3 for the descriptive flexfield. -
Attribute4: string
Read Only:
trueMaximum Length:20Value that identifies planning attribute number 4 for the descriptive flexfield. -
Attribute5: string
Read Only:
trueMaximum Length:20Value that identifies planning attribute number 5 for the descriptive flexfield. -
AttributeChar1: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 1 of type character for the demand in a backlog management plan. -
AttributeChar10: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 10 of type character for the demand in a backlog management plan. -
AttributeChar11: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 11 of type character for the demand in a backlog management plan. -
AttributeChar12: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 12 of type character for the demand in a backlog management plan. -
AttributeChar13: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 13 of type character for the demand in a backlog management plan. -
AttributeChar14: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 14 of type character for the demand in a backlog management plan. -
AttributeChar15: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 15 of type character for the demand in a backlog management plan. -
AttributeChar16: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 16 of type character for the demand in a backlog management plan. -
AttributeChar17: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 17 of type character for the demand in a backlog management plan. -
AttributeChar18: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 18 of type character for the demand in a backlog management plan. -
AttributeChar19: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 19 of type character for the demand in a backlog management plan. -
AttributeChar2: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 2 of type character for the demand in a backlog management plan. -
AttributeChar20: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 20 of type character for the demand in a backlog management plan. -
AttributeChar3: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 3 of type character for the demand in a backlog management plan. -
AttributeChar4: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 4 of type character for the demand in a backlog management plan. -
AttributeChar5: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 5 of type character for the demand in a backlog management plan. -
AttributeChar6: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 6 of type character for the demand in a backlog management plan. -
AttributeChar7: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 7 of type character for the demand in a backlog management plan. -
AttributeChar8: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 8 of type character for the demand in a backlog management plan. -
AttributeChar9: string
Read Only:
trueMaximum Length:150Value for the descriptive flexfield attribute number 9 of type character for the demand in a backlog management plan. -
AttributeDate1: string
(date)
Read Only:
trueValue for the descriptive flexfield attribute number 1 of type date for the demand in a backlog management plan. -
AttributeDate2: string
(date)
Read Only:
trueValue for the descriptive flexfield attribute number 2 of type date for the demand in a backlog management plan. -
AttributeDate3: string
(date)
Read Only:
trueValue for the descriptive flexfield attribute number 3 of type date for the demand in a backlog management plan. -
AttributeDate4: string
(date)
Read Only:
trueValue for the descriptive flexfield attribute number 4 of type date for the demand in a backlog management plan. -
AttributeDate5: string
(date)
Read Only:
trueValue for the descriptive flexfield attribute number 5 of type date for the demand in a backlog management plan. -
AttributeNumber1: number
Read Only:
trueValue for the descriptive flexfield attribute number 1 of type number for the demand in a backlog management plan. -
AttributeNumber2: number
Read Only:
trueValue for the descriptive flexfield attribute number 2 of type number for the demand in a backlog management plan. -
AttributeNumber3: number
Read Only:
trueValue for the descriptive flexfield attribute number 3 of type number for the demand in a backlog management plan. -
AttributeNumber4: number
Read Only:
trueValue for the descriptive flexfield attribute number 4 of type number for the demand in a backlog management plan. -
AttributeNumber5: number
Read Only:
trueValue for the descriptive flexfield attribute number 5 of type number for the demand in a backlog management plan. -
AutocreatedConfiguration: integer
Read Only:
trueValue that indicates whether the item is a configured item or not. Valid values are: 1 or 2. If 1, then item is a configured item. If 2, then not. -
AutocreatedConfigurationMeaning: string
Read Only:
trueMaximum Length:4000Value that indicates whether the item is configured or not. Valid values are: Yes or No. If Yes, then the item is configured. If No, then the item isn't configured. -
AverageInterarrivalTime: number
Average time, expressed in days, between intervals.
-
AverageInterarrivalTimeOvrride: number
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.
-
BackToBack: string
Read Only:
trueMaximum Length:4000Value that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: Yes or No. If Yes, then the item is enabled for back-to-back ordering. If No, then the item isn't enabled for back-to-back ordering. -
BackToBackEnabled: integer
Read Only:
trueValue that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: 1 or 2. If 1, then item is enabled for back-to-back ordering. If 2, then not. -
BaseModel: string
Read Only:
trueMaximum Length:4000Value that uniquely identifies the model to use when creating an assemble-to-order configuration. -
BuildInWIP: string
Read Only:
trueMaximum Length:4000Value that indicates whether work orders can be created or not. Valid values are Yes or No. If Yes, then work orders can be created. If No, then work orders can't be created. -
BuildInWIPOption: integer
Read Only:
trueContains one of the following values: 1 or 2. If 1, then work orders can be created. If No, then work orders can't be created. -
Buyer: string
Maximum Length:
240Name of the buyer associated with the item. -
CalculateATPIndicator: integer
Value that indicates whether to enable available-to-promise functionality in Oracle Fusion Cloud Global Order Promising when planning for this item. Valid values are 1 and 2. If 1, then available-to-promise functionality is enabled. If 2, then available-to-promise functionality isn't enabled.
-
CalculateATPMeaning: string
Read Only:
trueMaximum Length:4000Value that indicates whether to enable the available-to-promise rule in Oracle Fusion Cloud Global Order Promising. Valid values are Yes or No. If Yes, then the available-to-promise rule is enabled. If No, then the available-to-promise rule isn't enabled. -
CatalogId: integer
Read Only:
trueValue that uniquely identifies the catalog. -
Category: string
Title:
CategoryRead Only:trueMaximum Length:4000Category of the item in the exception. the category is derived from the default product hierarchy or any product hierarchy of the item associated in the plan's dimension catalog. -
CategoryDescription: string
Read Only:
trueMaximum Length:4000Description associated with a product category. -
CategoryId: integer
Read Only:
trueValue that uniquely identifies an item category. -
ConsiderInClearToBuild: string
Maximum Length:
1Value that indicates whether to include this component item when calculating clear-to-build for an assembly item. Valid values are 1 or 2. If 1, then this component item is included. If 2, then it's not. -
ConsiderInClearToBuildMeaning: string
Read Only:
trueMaximum Length:4000Value that indicates whether to include this component item when calculating clear to build for an assembly item. Valid values are Yes or No. If Yes, then this component item is included. If No, then this component item isn't included. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the item. -
CreateSupply: integer
Value that indicates whether planning creates planned orders for this item. Valid values are 1 or 2. If 1, then planned orders are created. If 2, then planned orders aren't created.
-
CreateSupplyAfter: string
(date)
Date after which supplies can be created. This attribute is editable only when the CreateSupply attribute is set to 1.
-
CreateSupplyMeaning: string
Read Only:
trueMaximum Length:4000Value that indicates whether planning creates planned orders for this item. Valid values are Yes or No. If Yes, then planned orders are created. If No, then planned orders aren't created. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the user created the supplier item. -
CriticalComponent: integer
Value that indicates whether the item is a critical component or not. Valid values are 1 or 2. If 1, then the item is a critical component. If 2, then the item isn't a critical component.
-
CriticalComponentMeaning: string
Read Only:
trueMaximum Length:4000Value that indicates whether the item is a critical component or not. Valid values are Yes or No. If Yes, then the item is a critical component. If No, then the item isn't a critical component. -
CumulativeManufacturingLt: number
Read Only:
trueNumber of days required to manufacture the item, including the adjusted, cumulative, and total lead time for the component that requires the longest time to assemble. -
Currency: string
Read Only:
trueMaximum Length:30Value that indicates the currency associated with the item's price and cost. -
DataSecurityEditAllowed: string
Read Only:
trueMaximum Length:255Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
DaysOfCover: number
Number of days of cover for the item. Days of Cover is multiplied by the average demand to calculate the safety stock level.
-
DaysOfCoverDemandPeriod: integer
Period of time, specified as a number of days, used to determine the average gross demand when using the Days of Cover method to calculate safety stock.
-
DemandTimeFenceCode: integer
Abbreviation that identifies the point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.
-
DemandTimeFenceDate: string
(date)
Read Only:
trueDate before which forecast demand is ignored. -
DemandTimeFenceDays: integer
Time horizon, expressed in number of days, within which forecast demand is ignored.
-
DemandTimeFenceType: string
Read Only:
trueMaximum Length:4000Value that identifies the point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
Description: string
Maximum Length:
240Description of the item. -
DiscountPercentage: number
Average discount for the item.
-
EnforcePurchaseLtMeaning: string
Read Only:
trueMaximum Length:4000Value 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. -
EnforcePurchasingLeadTime: integer
(int32)
Value that indicates whether purchasing lead times are imposed as a hard constraint during constraint-based planning. Valid values are: Yes or No. If Yes, then purchasing lead times are enforced. If No, then purchasing lead times aren't enforced.
-
ExcessHorizon: number
Time horizon, expressed in number of days, after which inventory is considered excess.
-
FixedDaysOfSupply: number
Number of days to use to modify the size and timing of each planned order quantity.
-
FixedDaysSupply: number
Read Only:
trueNumber of days to use to modify the size and timing of each planned order quantity. -
FixedLeadTime: number
Number of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time.
-
FixedLotMultiplier: number
Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate.
-
FixedOrderQuantity: number
Quantity to use to modify the size of each planned order quantity or each repetitive daily rate.
-
ForecastControl: string
Read Only:
trueMaximum Length:4000Value that indicates how the forecast is exploded and consumed. This attribute isn't currently used. -
ForecastErrorType: string
Maximum Length:
30Value that indicates how the quality of a forecast is measured. A list of accepted values is defined in the lookup type MSC_FORECAST_ERROR_TYPES. -
ForecastErrorTypeStr: string
Read Only:
trueMaximum Length:4000Meaning associated with the ForecastErrorType Code attribute. -
ForecastName: string
Read Only:
trueMaximum Length:4000Name of the forecast used for safety stock calculation. -
GlobalAttributeChar1: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 1 of type character in the descriptive flexfield. -
GlobalAttributeChar10: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 10 of type character in the descriptive flexfield. -
GlobalAttributeChar11: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 11 of type character in the descriptive flexfield. -
GlobalAttributeChar12: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 12 of type character in the descriptive flexfield. -
GlobalAttributeChar13: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 13 of type character in the descriptive flexfield. -
GlobalAttributeChar14: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 14 of type character in the descriptive flexfield. -
GlobalAttributeChar15: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 15 of type character in the descriptive flexfield. -
GlobalAttributeChar16: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 16 of type character in the descriptive flexfield. -
GlobalAttributeChar17: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 17 of type character in the descriptive flexfield. -
GlobalAttributeChar18: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 18 of type character in the descriptive flexfield. -
GlobalAttributeChar19: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 19 of type character in the descriptive flexfield. -
GlobalAttributeChar2: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 2 of type character in the descriptive flexfield. -
GlobalAttributeChar20: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 20 of type character in the descriptive flexfield. -
GlobalAttributeChar3: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 3 of type character in the descriptive flexfield. -
GlobalAttributeChar4: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 4 of type character in the descriptive flexfield. -
GlobalAttributeChar5: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 5 of type character in the descriptive flexfield. -
GlobalAttributeChar6: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 6 of type character in the descriptive flexfield. -
GlobalAttributeChar7: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 7 of type character in the descriptive flexfield. -
GlobalAttributeChar8: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 8 of type character in the descriptive flexfield. -
GlobalAttributeChar9: string
Read Only:
trueMaximum Length:150Value that identifies planning global attribute number 9 of type character in the descriptive flexfield. -
GlobalAttributeDate1: string
(date)
Read Only:
trueValue that identifies planning global attribute number 1 of type date in the descriptive flexfield. -
GlobalAttributeDate2: string
(date)
Read Only:
trueValue that identifies planning global attribute number 2 of type date in the descriptive flexfield. -
GlobalAttributeDate3: string
(date)
Read Only:
trueValue that identifies planning global attribute number 3 of type date in the descriptive flexfield. -
GlobalAttributeDate4: string
(date)
Read Only:
trueValue that identifies planning global attribute number 4 of type date in the descriptive flexfield. -
GlobalAttributeDate5: string
(date)
Read Only:
trueValue that identifies planning global attribute number 5 of type date in the descriptive flexfield. -
GlobalAttributeNumber1: number
Read Only:
trueValue that identifies planning global attribute number 1 in the descriptive flexfield. -
GlobalAttributeNumber2: number
Read Only:
trueValue that identifies planning global attribute number 2 in the descriptive flexfield. -
GlobalAttributeNumber3: number
Read Only:
trueValue that identifies planning global attribute number 3 in the descriptive flexfield. -
GlobalAttributeNumber4: number
Read Only:
trueValue that identifies planning global attribute number 4 in the descriptive flexfield. -
GlobalAttributeNumber5: number
Read Only:
trueValue that identifies planning global attribute number 5 in the descriptive flexfield. -
HardPeggingLevel: string
Read Only:
trueMaximum Length:25Value that identifies the type of pegging considered by the planning engine during the supply and demand netting process. A list of accepted values is defined in the lookup type ORA_MSC_HARD_PEGGING_LEVEL. -
HardPeggingLevelStr: string
Read Only:
trueMaximum Length:4000Meaning associated with the HardPeggingLevel attribute. -
IntermittentDemand: number
Value that indicates whether the demand for the item has an irregular frequency or not. Valid values are: 1 or 2. If 1, then demand for the item has an irregular frequency . If 2, then not.
-
IntermittentDemandMeaning: string
Read Only:
trueMaximum Length:4000Indicates whether the demand has an irregular frequency. Valid values are Yes and No. -
IntermittentDemandOverride: string
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.
-
IntermittentDemandOverrideStr: string
Read Only:
trueMaximum Length:4000Value 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. -
InventoryItemId: integer
(int64)
Value that uniquely identifies the item.
-
ItemCostUOM: string
Read Only:
trueMaximum Length:4000Unit of measure associated with an item's cost. -
ItemName: string
Maximum Length:
300Name of the item. -
ItemStructureType: string
Read Only:
trueMaximum Length:4000Value that indicates the type of bill of material. A list of accepted values is defined in the lookup type ORA_MSC_BOM_ITEM_TYPE. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the item. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User most recently updated the item. -
LeadTimeLotSize: number
Read Only:
trueMultiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate. -
LeadTimeOffsetPeriodBkts: number
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.
-
LeadTimeOffsetWeekBkts: number
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.
-
LifeCyclePhase: string
Maximum Length:
120Name of lifecycle phase of the item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LotControl: string
Read Only:
trueMaximum Length:4000Meaning associated with the LotControlCode attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE. -
LotControlCode: integer
Read Only:
trueValue that identifies whether the item is lot controlled. Valid values are 1 and 2. If 1, then lot control isn't established for the item. If 2, then lot control is used to track inventory balances by the lot number. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE. -
LotExpirationControl: string
Read Only:
trueMaximum Length:4000Meaning associated with the LotsExpiration attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL. -
LotsExpiration: integer
Read Only:
trueValue that identifies how lot expiration dates are calculated. Valid values are 1 and 2. If 1, then lots don't expire. If 2, then lot expiration is based on the number of shelf life days for the item. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL. -
MAD: number
Read Only:
trueValue of the mean absolute deviation for the item. -
MADOverride: number
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.
-
MakeOrBuy: string
Read Only:
trueMaximum Length:4000Value that indicates whether the item is manufactured or purchased. Valid values are Make or Buy. If Make, then the item is manufactured. If Buy, then the item is purchased. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MAKE_BUY. -
MAPE: number
Read Only:
trueValue of the mean absolute percentage error for the item. -
MAPEOverride: number
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.
-
MaximumOrderQuantity: number
Maximum order quantity of the item.
-
MinimumOrderQuantity: number
Minimum order quantity of the item.
-
NetSellingPrice: number
Read Only:
trueSelling price of an item after applying an average discount to the item's list price. -
NewPlanId: integer
Most recent value that uniquely identifies the plan.
-
NotesIndicator: integer
Read Only:
trueIndicates whether an associated note exists. Valid values are 0 or 1. If 0, then there are no associated notes. If 1, then there's at least one associated note. -
NumberOfDaysForDemandCutoff: integer
Read Only:
trueThe number of days after the demand date that the demand can be satisfied. This attribute doesn't have a default value. -
ObsolescenceDate: string
(date)
Date when the item is obsolete.
-
OrderCost: number
Fixed costs that are associated with placing a sales order for the item.
-
OrderModifierToStartQuantity: integer
Value that indicates whether order modifiers are applied to start quantity or not. Valid values are: 1 or 2. If 1, then order modifiers are applied to start quantity. If 2, then not.
-
OrderModifierToStartQuantityMeaning: string
Read Only:
trueMaximum Length:4000Value that determines whether the order modifier for the item should be applied to the start quantity of the supply for the item. Valid values are Yes or No. -
Organization: string
Maximum Length:
49Abbreviation that identifies the organization associated with the item. -
OrganizationId: integer
(int64)
Value that uniquely identifies the organization.
-
PickComponents: integer
Read Only:
trueValue that indicates whether the item can be picked from finished goods inventory. Valid values are: 1 or 2. If 1, then the item can be picked from finished goods inventory. If 2, then not. -
PickComponentsMeaning: string
Read Only:
trueMaximum Length:4000Value that indicates whether the item can be picked from the finished goods inventory. Valid values are: Yes or No. If Yes, then the item can be picked from the finished goods inventory. If No, then the item can't be picked from the finished goods inventory. -
PlannedSafetyStockType: string
Read Only:
trueMaximum Length:4000Type 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. -
PlannedSafetyStockTypeIndicator: integer
(int32)
Read Only:
trueAbbreviation 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. -
Planner: string
Maximum Length:
10Abbreviation that identifies the planner responsible for the item. -
PlannerDescription: string
Read Only:
trueMaximum Length:4000Description of the planner responsible for the item. -
PlanningMethod: string
Read Only:
trueMaximum Length:4000Value that indicates the type of planning used for the item. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_CODE. -
PlanningMethodCode: integer
Abbreviation that indicates the type of planning used for the item. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_CODE.
-
PlanningTimeFenceCode: integer
Abbreviation that identifies the point in time inside which the planning process won't schedule a supply order to be due. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.
-
PlanningTimeFenceDate: string
(date)
Read Only:
trueDate before which orders aren't rescheduled. -
PlanningTimeFenceDays: integer
Time horizon, in number of days, in which supply orders aren't scheduled to be due.
-
PlanningTimeFenceType: string
Read Only:
trueMaximum Length:4000Value that identifies the point in time inside which the planning process won't schedule a supply order to be due. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
PostprocessingLeadTime: number
Number of days required to make an item available in inventory once the supply is complete.
-
PreprocessingLeadTime: number
Number of days which must be added to purchasing or manufacturing lead time to place an order.
-
ProcessingLeadTime: number
Number of days required to procure or manufacture an item.
-
ReleaseTimeFenceCode: integer
Abbreviation that identifies the point in time inside which planned orders with certain criteria are automatically released as work orders or purchase orders. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.
-
ReleaseTimeFenceDate: string
(date)
Read Only:
trueDate before which orders are automatically released as work orders or purchase requisitions. -
ReleaseTimeFenceDays: integer
Time horizon, in number of days, in which orders are automatically released as work orders or purchase requisitions.
-
ReleaseTimeFenceType: string
Read Only:
trueMaximum Length:4000Value that identifies the point in time inside which planned orders with certain criteria are automatically released as work orders or purchase orders. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES. -
Rounding: integer
Value that indicates whether planned order quantity is rounded to a whole number or not. Valid values are: 1 or 2. If 1, then planned order quantity is rounded. If 2, then not.
-
RoundingMeaning: string
Read Only:
trueMaximum Length:4000Value that indicates whether the planned order quantity is rounded to a whole number or not. Valid values are: Yes or No. If Yes, then the planned order quantity is rounded. If No, then the planned order quantity isn't rounded. -
RowModified: string
Read Only:
trueMaximum Length:255Text 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. -
SafetyStockCode: integer
Value that identifies the method that planning uses to calculate safety stock levels for the item. A list of accepted values is defined in the lookup type ORA_MSC_SS_PLANNING_METHD.
-
SafetyStockForecastPlan: string
Read Only:
trueMaximum Length:4000Demand plan that contains the forecast and forecast error measures that the plan uses to calculate safety stock. -
SafetyStockPlanningMethod: string
Maximum Length:
4000Meaning associated with the SafetyStockCode attribute. -
SafetyStockQuantity: number
Desired level of safety stock of an item.
-
SafetyStockQuantityOverride: number
Numeric value provided by the user to override the standard safety stock quantity of an item.
-
Segment: string
Read Only:
trueValue that uniquely identifies segment of items in inventory plan. -
SegmentDescription: string
Read Only:
trueDescription of segment associated with exception. -
SegmentId: integer
(int64)
Read Only:
trueValue that uniquely identifies segment of items in inventory plan. -
SellingPrice: number
Selling price of the item.
-
ServiceLevelPercent: number
Desired level of customer service, expressed as a percentage, in satisfying product demand. This represents the probability that an order can be filled from available inventory.
-
ShrinkageRate: number
Average amount of material you expect to lose when manufacturing or storing the item.
-
StandardCost: number
Standard cost of an item.
-
SupplyType: string
Read Only:
trueMaximum Length:4000Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE. -
UnitVolume: number
Read Only:
trueVolume of one item. -
UnitWeight: number
Read Only:
trueWeight of one item. -
UOM: string
Read Only:
trueMaximum Length:4000Planning unit of measure of the item. -
UOMCode: string
Read Only:
trueMaximum Length:3Abbreviation that identifies the unit of measure associated with the order quantity. -
UseUpDate: string
(date)
Read Only:
trueDate when the current on-hand quantity for an item is exhausted based on projected gross requirements. -
VariableLeadTime: number
Time to produce one unit of an assembly.
-
VolumeUOMName: string
Read Only:
trueMaximum Length:4000Unit of measure to use for the item volume. -
WeightUOMName: string
Read Only:
trueMaximum Length:4000Unit of measure to use for the item weight.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryPlans-PlanAndSegmentExceptions-item-response
Type:
Show Source
object-
AchievedServiceLevelPercentage: number
Read Only:
trueService level achieved at the segment level. -
ActionTaken: integer
(int64)
Title:
Action TakenContains one of the following values: 1 or 2. If 1, then action was taken to resolve the issue. If 2, then action wasn't taken to resolve the issue. The default value is 2. -
Currency: string
Read Only:
trueMaximum Length:80Currency used for segment budget as well as inventory budget . -
DataSecurityEditAllowed: string
Read Only:
trueContains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges. -
Exception: string
Read Only:
trueMaximum Length:120Value that uniquely identifies the plan and segment exception. -
ExceptionDetailId: integer
Read Only:
trueValue that uniquely identifies the plan and segment exception detail. -
ExceptionId: integer
Read Only:
trueValue that uniquely identifies the plan and segment exception. -
ExceptionStoreId: integer
(int64)
Read Only:
trueValue that uniquely identifies the stored plan and segment exception. -
ExceptionValue: number
Read Only:
trueValue of plan and segment exception. -
FromDate: string
(date)
Read Only:
trueStarting date for the exception in the planning horizon. -
InventoryBudgetValue: number
Read Only:
trueDescription of segment associated with exception. -
InventoryValue: number
Read Only:
trueDescription of segment associated with exception. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate when the user last updated the exception. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who last updated the exception. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Notes: integer
(int64)
Title:
NotesNotes attached by the user while reviewing exceptions. -
PlanId: integer
Read Only:
trueValue that uniquely identifies inventory plan. -
RowModified: string
Read Only:
trueText that identifies whether the row is new or modified contains valid values, yes or null. If the value is yes, the row is new or modified. If the value is null, the row is neither new nor modified. -
Segment: string
Read Only:
trueValue that uniquely identifies segment of items in inventory plan. -
SegmentDescription: string
Read Only:
trueDescription of segment associated with exception. -
SegmentGroupId: integer
Read Only:
trueValue that uniquely identifies segment of items in inventory plan. -
SegmentId: integer
Read Only:
trueValue that uniquely identifies segment of items in inventory plan. -
StoreKey: string
Read Only:
trueMaximum Length:240Name of store key in the plan and segment exception. -
TargetServiceLevelPercentage: number
Read Only:
trueTarget service level is the user-specified service level percentage that the planning process aims to achieve. -
ToDate: string
(date)
Read Only:
trueEnding date for the exception in the planning horizon.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryPlans-Runs-item-response
Type:
Show Source
object-
ActionParams: string
List of entities to be refreshed. Each value is separated by a comma. Valid values are: 3 - Forecasts, 4 - Sales orders, and 6 - Supplies. There is no default value. This attribute is ignored unless Mode is set to 2.
-
ArchivePlanFlag: boolean
Contains one of the following values: true or false. If true, the plan is archived before the next plan run. If false, the plan isn't archived. The default value is false. Note that you can archive a plan only if it's enabled for archiving. Use the Enable for Archiving attribute in one of the work areas for supply chain planning to enable it.
-
EndDate: string
(date-time)
Date and time when the plan run is completed.
-
ExecutionId: integer
(int64)
Value that uniquely identifies the process.
-
ExecutionUser: string
Maximum Length:
64Login used by the user when launching the process. -
ForceRunFlag: boolean
Contains one of the following values: true or false. If true, the plan is run regardless of the current plan status. If false, the plan is only run if it's ready to run. The default value is false.
-
JobId: integer
(int64)
Value that uniquely identifies the scheduled process.
-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Message: string
Text of any error messages that occurred when running the scheduled process.
-
Mode: string
Specifies whether data is to be refreshed. Contains one of the following values: 1 - all data is refreshed, 2 - only selected entities are refreshed, or 3 - data isn't refreshed.
-
PlanId: integer
Value that uniquely identifies the inventory plan.
-
RecalculateSafetyStockFlag: boolean
Contains one of the following values: true or false. If true, then the safety stock is recalculated when running a plan. If false, then the safety stock isn't recalculated. This value is applicable only when the safety stock planning method plan option isn't 1: Don't plan safety stock or 4: User-specified values for all items.
-
SavePlanToDb: string
This attribute isn't currently used. Save the plan to database for future use such as plan simulation.
-
StartDate: string
(date-time)
Date and time when the scheduled process is set to start.
-
Status: integer
(int32)
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.
-
SubmissionNotes: string
Notes provided by the user when submitting the plan from the Run Plan page.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Links
- ComponentItems
-
Parameters:
- PlanId:
$request.path.PlanId
Item structure components that are part of a supply plan. - PlanId:
- Items
-
Parameters:
- PlanId:
$request.path.PlanId
The Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution. - PlanId:
- PlanAndSegmentExceptions
-
Operation: /fscmRestApi/resources/11.13.18.05/inventoryPlans/{PlanId}/child/PlanAndSegmentExceptionsParameters:
- PlanId:
$request.path.PlanId
Exception details for the inventory plan. This can be used to capture any exceptions related to the inventory plan. - PlanId:
- Runs
-
Parameters:
- PlanId:
$request.path.PlanId
Details about the inventory plan that can be used to run inventory plans. - PlanId: