Get details of one plan
get
/fscmRestApi/resources/11.13.18.05/plans/{PlanId}
Request
Path Parameters
-
PlanId(required): integer(int64)
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 : plans-item-response
Type:
Show Source
object
-
Approved: integer
(int32)
Contains one of the following values: 1 or null. If 1, then the plan is approved. If null, then the plan isn't approved. The default value is null.
-
AutoReleaseRp: 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.
-
BaseCompileDesignator: string
Title:
Copied From
Maximum Length:30
Name of the base plan that this plan was copied from. -
BasePlanId: integer
(int64)
ID of the base plan that this plan was copied from.
-
CalSsQuantEndItems: integer
(int32)
Contains one of the following values: 1 or 2. If 1, then calculate a new safety stock level for each end item when running the plan. If 2, then don't do this calculation.
-
CompileDesignator: string
Title:
Name
Maximum Length:255
Name of the plan. -
CreatedBy: string
Maximum Length:
64
User who created the plan. -
CreationDate: string
(date-time)
Date when the user created the plan.
-
DailyCutoffBucket: integer
Date when the day buckets ends in a planning horizon.
-
DataCompletionDate: string
(date-time)
Date on which the snapshot process in the plan run completed.
-
DemandPlanCompletionDate: string
(date-time)
Title:
Last Run Date
Date and time when demand planning finished running the plan. -
DemandPlanStartDate: string
(date-time)
Read Only:
true
Date and time when demand planning started running the plan. -
Description: string
Title:
Description
Maximum Length:100
Description of the plan. -
EnableArchive: integer
(int32)
Title:
Enable for archiving
Read Only:true
Contains one of the following values: 1 or 2. If 1, then archive measure values in the plan. If 2, then don't archive these values. The default value is 2. -
EnableWelcomePage: integer
(int32)
Read Only:
true
Indicates whether plan is enabled for the welcome page. Valid Values: 1:True and 2:False. -
ForecastingCalendar: string
Title:
Forecasting Calendar
Read Only:true
Maximum Length:22
Calendar used in the plan for forecasting. -
ForecastTimeLevel: integer
Title:
Forecasting Time Level
Read Only:true
Forecasting time level code used in the plan. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_TIME_LEVEL. Valid values are 1, 2, 3, or 4. This attribute doesn't have a default value. -
ForecastTimeLevelMeaning: string
Title:
Forecasting Time Level
Read Only:true
Maximum Length:80
Forecasting time level name used in the plan. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_TIME_LEVEL. Valid values are 1 - Days, 2 - Weeks, 3 - Periods, or 4 - Months. This attribute doesn't have a default value. -
HasRun: integer
Contains one of the following values:1,0,or Empty. If 1, then the most recent plan run finished successfully. If 0, then the most recent plan run failed. If Empty, then the application hasn't run the plan. This attribute has no default value.
-
LastApprovedBy: string
Title:
Last Approved By
Maximum Length:64
User who performed the most recent approval on the plan. -
LastApprovedDate: string
(date-time)
Title:
Last Approved Date
Date the user most recently approved the plan. -
LastRunDate: string
(date-time)
Title:
Last Run Date
Date the plan ran successfully most recently. -
LastUpdateDate: string
(date-time)
Title:
Last Updated Date
Date the user most recently updated the plan. -
LastUpdatedBy: string
Title:
Last Updated By
Maximum Length:64
User who performed the most recent plan update. -
LastUpdateLogin: string
Maximum Length:
32
Date the user most recently updated the plan. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
Loaded: integer
Title:
Loaded
Read Only:true
Contains one of the following values: 1, 2 or 3. If 1, then the plan is loaded in memory. If 2, then the plan isn't loaded in memory for demand plans. If 3, then the plan isn't loaded in memory for replenishment plans. This attribute doesn't have a default value. -
LoadedMeaning: string
Title:
Loaded
Read Only:true
Maximum Length:255
Contains one of the following values: Yes, No, or NA. If Yes, then the plan is loaded in memory. If No, then the plan isn't loaded in memory for demand plans. If NA, then the plan isn't loaded in memory for replenishment plans. This attribute doesn't have a default value. -
MeasureCatalog: string
Title:
Measure Catalog
Read Only:true
Maximum Length:250
Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan. -
MeasureCatalogBicc: integer
(int64)
Name of the measure catalog used in BICC integration.
-
MeasureCatalogId: integer
(int64)
Read Only:
true
Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan. -
NotesCount: integer
Title:
Notes
Read Only:true
Value that represents the number of notes created for a plan. -
ObjectVersionNumber: integer
(int32)
Implements optimistic locking by incrementing this number each time the row is updated. At the start and end of a transaction, the number is compared to detect if another session has updated the row since it was last queried.
-
OSNObjectPublished: integer
Title:
Social
Read Only:true
Contains one of the following values: 1 or 2. If 1, then the plan is published in Oracle Social Network. If 2, then the plan isn't published in Oracle Social Network. The default value is 2. -
PlanApprovalStatusMeaning: string
Title:
Approval Status
Maximum Length:80
Contains one of the following values: Approved or null. If Approved, then the plan is approved. If null, then the plan isn't approved. The default value is null. -
PlanCompletionDate: string
(date-time)
Title:
Last Run Date
Date and time the plan run was completed. -
PlanId: integer
(int64)
Value that uniquely identifies the plan.
-
PlanningMode: integer
Title:
Supply Planning Mode
Mode used for supply planning. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MODE. Valid values are 1, 2, and 3. If 1, then the supply planning mode is constrained. If 2, then supply planning mode is unconstrained. If 3, then supply planning mode is aggregated. This attribute doesn't have a default value. -
PlanOwner: string
Title:
Owner
Maximum Length:64
Name of the user who owns the plan. -
PlanOwnerName: string
Title:
Owner
Maximum Length:100
Name of the user who owns the plan. -
PlanPrivilegeMeaning: string
Title:
Access
Maximum Length:80
Access type of the plan. If it's public, then all users can access the plan. If it's private, only the plan owner or users that the plan references can access the plan. -
PlanStartDate: string
(date-time)
Start date of the plan.
-
PlanTimeLevel: integer
Title:
Planning Time Level
Read Only:true
Planning time level code used in the plan. A list of accepted values is defined in the lookup types ORA_MSC_TIME_LEVELS_MFG, ORA_MSC_TIME_LEVELS_FISCAL, and ORA_MSC_TIME_LEVELS_WTM. Valid values are 1, 2, 3, 4, 5, 6, and 7. This attribute doesn't have a default value. -
PlanTimeLevelMeaning: string
Title:
Planning Time Level
Read Only:true
Maximum Length:80
Planning time level name used in the plan. A list of accepted values is defined in the lookup types ORA_MSC_TIME_LEVELS_MFG, ORA_MSC_TIME_LEVELS_FISCAL, and ORA_MSC_TIME_LEVELS_WTM. Valid values are Day, Week, Period Month, Quarter, Year, and Hybrid Time Level. This attribute doesn't have a default value. -
PlanType: integer
Type of plan. A list of accepted values is defined in the lookup type ORA_MSC_PLAN_TYPE. Valid values include 1, 2, 3, 4, and 5. This attribute doesn't have a default value.
-
PlanTypeMeaning: string
Title:
Type
Maximum Length:80
Type of plan. A list of accepted values is defined in the lookup type ORA_MSC_PLAN_TYPE. Valid values include 1 - Demand Plan, 2 - Supply Plan, 3 - Demand and Supply Plan, 4 - Sales and Operations Plan, and 5 - Replenishment Plan. This attribute doesn't have a default value. -
PrivatePlan: integer
Title:
Access
Contains one of the following values: 1 or 2. If 1, then the access type of the plan is public. If 2, then the access type of the plan is private. Only the plan owner or users that the plan references can view a private plan. The default value is 1. A list of accepted values is defined in the lookup type ORA_MSC_ACCESS. -
RecalculateSafetyStock: integer
Contains one of the following values: 1 or 2. If 1, then recalculate safety stock quantity the next time the plan runs. If 2, then don't recalculate.
-
ReferencePlanForExecution: integer
(int32)
Title:
Reference Plan for Fulfillment
Read Only:true
Indicates whether the current plan is used as a reference plan for execution systems. -
Release: integer
Contains one of the following values: 1 or null. If 1, then plan recommendations are released from the plan. If null, then plan recommendations aren't released from plan.
-
Saved: integer
Contains one of the following values : 0 and 3. If 0, then plan is run with interactive mode and saved to the database. If 3 , plan is run with batch mode and saved to the database.
-
SaveToDb: integer
Contains one of the following values: 2, 3 and null. If 2, then plan is saved without calculating totals, 3 indicates plan is saved calculating totals. Null will be plans where calculating totals during save isn't applicable. Note - this is default flushed as 2 currently, and not used in any process. However, this is still updated and retained since there can be customers who would be using this for custom flows.
-
SopLoadFromDemandPlan: integer
(int32)
Loads measure values from demand plan to shipments forecast.
-
SrInstanceCode: string
Title:
Source System
Read Only:true
Maximum Length:255
Reference code of the source application instance for an organization included in the plan scope. -
SrInstanceId: integer
Title:
Source System
Read Only:true
Value identifier of the source application instance of an organization included in plan scope. -
Status: integer
Title:
Status
Status of most recently completed 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. This attribute doesn't have a default value. -
StatusMeaning: string
Maximum Length:
80
Status of most recently completed 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. This attribute doesn't have a default value. -
SupplyPlanningModeMeaning: string
Title:
Supply Planning Mode
Maximum Length:80
Mode used for supply planning. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MODE. Valid values are 1, 2, or 3. If 1, then the supply planning mode is constrained. If 2, then supply planning mode is unconstrained. If 3, then the supply planning mode is aggregated. This attribute doesn't have a default value. -
WorkAreaType: integer
(int32)
Read Only:
true
Value that identifies the associated work area type.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]
The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.