Jump to

• Request
• Response

Get details of all plans

get

/fscmRestApi/resources/11.13.18.05/plans

Request

Query Parameters

• expand: string
  When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
• fields: string
  This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
  
  Format: ?fields=Attribute1,Attribute2
  
  Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
• finder: string
  Used as a predefined finder to search the collection.
  
  Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
  
  The following are the available finder names and corresponding finder variables
  
  

  • PrimaryKey Finds a plan based on the unique identifier of the plan.
    Finder Variables
    • PlanId; integer; Value that uniquely identifies the plan.
• limit: integer
  This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
• links: string
  This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
  
  Example:
  self,canonical
  
• offset: integer
  Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
• onlyData: boolean
  The resource item payload will be filtered in order to contain only data (no links section, for example).
• orderBy: string
  This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
• q: string
  This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
  
  Format: ?q=expression1;expression2
  
  You can use these queryable attributes to filter this collection resource using the q query parameter:
  

  • Approved; integer; 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; Name of the base plan that this plan was copied from.
  • BasePlanId; integer; ID of the base plan that this plan was copied from.
  • CalSsQuantEndItems; integer; 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; Name of the plan.
  • CreatedBy; string; User who created the plan.
  • CreationDate; string; Date when the user created the plan.
  • DailyCutoffBucket; integer; Date when the day buckets ends in a planning horizon.
  • DataCompletionDate; string; Date on which the snapshot process in the plan run completed.
  • 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 measure values in the plan. If 2, then don't archive these values. The default value is 2.
  • EnableWelcomePage; integer; Indicates whether plan is enabled for the welcome page. Valid Values: 1:True and 2:False.
  • ForecastTimeLevel; integer; 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; 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.
  • ForecastingCalendar; string; Calendar used in the plan for forecasting.
  • 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; User who performed the most recent approval on the plan.
  • LastApprovedDate; string; Date the user most recently approved the plan.
  • LastRunDate; string; Date the plan ran successfully most recently.
  • LastUpdateDate; string; Date the user most recently updated the plan.
  • LastUpdateLogin; string; Date the user most recently updated the plan.
  • LastUpdatedBy; string; User who performed the most recent plan update.
  • Loaded; integer; 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; 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; Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan.
  • MeasureCatalogBicc; integer; Name of the measure catalog used in BICC integration.
  • MeasureCatalogId; integer; Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan.
  • NotesCount; integer; Value that represents the number of notes created for a plan.
  • OSNObjectPublished; integer; 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.
  • ObjectVersionNumber; integer; 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.
  • PlanApprovalStatusMeaning; string; 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 and time the plan run was completed.
  • PlanId; integer; Value that uniquely identifies the plan.
  • PlanOwner; string; Name of the user who owns the plan.
  • PlanOwnerName; string; Name of the user who owns the plan.
  • PlanPrivilegeMeaning; string; 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; Start date of the plan.
  • PlanTimeLevel; integer; 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; 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; 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.
  • PlanningMode; integer; 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.
  • PrivatePlan; integer; 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; 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.
  • 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.
  • 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.
  • SopLoadFromDemandPlan; integer; Loads measure values from demand plan to shipments forecast.
  • SrInstanceCode; string; Reference code of the source application instance for an organization included in the plan scope.
  • SrInstanceId; integer; Value identifier of the source application instance of an organization included in plan scope.
  • Status; integer; 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; 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; 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; Value that identifies the associated work area type.
• totalResults: boolean
  The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".

Header Parameters

• Metadata-Context: string
  If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
• REST-Framework-Version: string
  The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

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.

Body ()

Root Schema : plans

Type: object

Show Source

• count(required): integer
  The number of resource instances returned in the current range.
• hasMore(required): boolean
  Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
• items: array Items
  Title: Items

  The items in the collection.
• limit(required): integer
  The actual paging size used by the server.
• links(required): array Links
  Title: Links

  The link relations associated with the resource instance.
• offset(required): integer
  The offset value used in the current page.
• totalResults: integer
  The estimated row count when "?totalResults=true", otherwise the count is not included.

{
    "required":[
        "count",
        "hasMore",
        "limit",
        "links",
        "offset"
    ],
    "type":"object",
    "properties":{
        "count":{
            "type":"integer",
            "description":"The number of resource instances returned in the current range."
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false."
        },
        "items":{
            "title":"Items",
            "type":"array",
            "description":"The items in the collection.",
            "items":{
                "$ref":"#/components/schemas/plans-item-response"
            }
        },
        "limit":{
            "type":"integer",
            "description":"The actual paging size used by the server."
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "offset":{
            "type":"integer",
            "description":"The offset value used in the current page."
        },
        "totalResults":{
            "type":"integer",
            "description":"The estimated row count when \"?totalResults=true\", otherwise the count is not included."
        }
    },
    "x-hints":{
        "subgroup":"SupplyChainPlanning",
        "usage":"BusinessObject",
        "group":"SCM"
    }
}

Nested Schema : Items

Type: array

Title: Items

The items in the collection.

Show Source

• Array of: object plans-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The items in the collection.",
    "items":{
        "$ref":"#/components/schemas/plans-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : plans-item-response

Type: object

Show Source

• 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.

{
    "type":"object",
    "properties":{
        "Approved":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":1
            },
            "x-queryable":true
        },
        "AutoReleaseRp":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "BaseCompileDesignator":{
            "title":"Copied From",
            "maxLength":30,
            "type":"string",
            "description":"Name of the base plan that this plan was copied from.",
            "nullable":true,
            "x-queryable":true
        },
        "BasePlanId":{
            "type":"integer",
            "description":"ID of the base plan that this plan was copied from.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18
            },
            "x-queryable":true
        },
        "CalSsQuantEndItems":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":1
            },
            "x-queryable":true
        },
        "CompileDesignator":{
            "title":"Name",
            "maxLength":255,
            "type":"string",
            "description":"Name of the plan.",
            "nullable":false,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the plan.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Date when the user created the plan.",
            "format":"date-time",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "DailyCutoffBucket":{
            "type":"integer",
            "description":"Date when the day buckets ends in a planning horizon.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "DataCompletionDate":{
            "type":"string",
            "description":"Date on which the snapshot process in the plan run completed.",
            "format":"date-time",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "DemandPlanCompletionDate":{
            "title":"Last Run Date",
            "type":"string",
            "description":"Date and time when demand planning finished running the plan.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "DemandPlanStartDate":{
            "type":"string",
            "description":"Date and time when demand planning started running the plan.",
            "format":"date-time",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "Description":{
            "title":"Description",
            "maxLength":100,
            "type":"string",
            "description":"Description of the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "EnableArchive":{
            "title":"Enable for archiving",
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":1
            },
            "x-queryable":true
        },
        "EnableWelcomePage":{
            "type":"integer",
            "description":"Indicates whether plan is enabled for the welcome page. Valid Values: 1:True and 2:False.",
            "format":"int32",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":1
            },
            "x-queryable":true
        },
        "ForecastTimeLevel":{
            "title":"Forecasting Time Level",
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ForecastTimeLevelMeaning":{
            "title":"Forecasting Time Level",
            "maxLength":80,
            "type":"string",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ForecastingCalendar":{
            "title":"Forecasting Calendar",
            "maxLength":22,
            "type":"string",
            "description":"Calendar used in the plan for forecasting.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "HasRun":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "LastApprovedBy":{
            "title":"Last Approved By",
            "maxLength":64,
            "type":"string",
            "description":"User who performed the most recent approval on the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "LastApprovedDate":{
            "title":"Last Approved Date",
            "type":"string",
            "description":"Date the user most recently approved the plan.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "LastRunDate":{
            "title":"Last Run Date",
            "type":"string",
            "description":"Date the plan ran successfully most recently.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "title":"Last Updated Date",
            "type":"string",
            "description":"Date the user most recently updated the plan.",
            "format":"date-time",
            "nullable":false,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Date the user most recently updated the plan.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "title":"Last Updated By",
            "maxLength":64,
            "type":"string",
            "description":"User who performed the most recent plan update.",
            "nullable":false,
            "x-queryable":true
        },
        "Loaded":{
            "title":"Loaded",
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LoadedMeaning":{
            "title":"Loaded",
            "maxLength":255,
            "type":"string",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "MeasureCatalog":{
            "title":"Measure Catalog",
            "maxLength":250,
            "type":"string",
            "description":"Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "MeasureCatalogBicc":{
            "type":"integer",
            "description":"Name of the measure catalog used in BICC integration.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18
            },
            "x-queryable":true
        },
        "MeasureCatalogId":{
            "type":"integer",
            "description":"Measure catalog that the plan references. The measure catalog determines the measures that you can use in each plan.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "NotesCount":{
            "title":"Notes",
            "type":"integer",
            "description":"Value that represents the number of notes created for a plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "OSNObjectPublished":{
            "title":"Social",
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ObjectVersionNumber":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":9
            },
            "x-queryable":true
        },
        "PlanApprovalStatusMeaning":{
            "title":"Approval Status",
            "maxLength":80,
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanCompletionDate":{
            "title":"Last Run Date",
            "type":"string",
            "description":"Date and time the plan run was completed.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the plan.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18
            },
            "x-queryable":true
        },
        "PlanOwner":{
            "title":"Owner",
            "maxLength":64,
            "type":"string",
            "description":"Name of the user who owns the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanOwnerName":{
            "title":"Owner",
            "maxLength":100,
            "type":"string",
            "description":"Name of the user who owns the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanPrivilegeMeaning":{
            "title":"Access",
            "maxLength":80,
            "type":"string",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "PlanStartDate":{
            "type":"string",
            "description":"Start date of the plan.",
            "format":"date-time",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "PlanTimeLevel":{
            "title":"Planning Time Level",
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlanTimeLevelMeaning":{
            "title":"Planning Time Level",
            "maxLength":80,
            "type":"string",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlanType":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "PlanTypeMeaning":{
            "title":"Type",
            "maxLength":80,
            "type":"string",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "PlanningMode":{
            "title":"Supply Planning Mode",
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PrivatePlan":{
            "title":"Access",
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "RecalculateSafetyStock":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ReferencePlanForExecution":{
            "title":"Reference Plan for Fulfillment",
            "type":"integer",
            "description":"Indicates whether the current plan is used as a reference plan for execution systems.",
            "format":"int32",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":1
            },
            "x-queryable":true
        },
        "Release":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "SaveToDb":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "Saved":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "SopLoadFromDemandPlan":{
            "type":"integer",
            "description":"Loads measure values from demand plan to shipments forecast.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":1
            },
            "x-queryable":true
        },
        "SrInstanceCode":{
            "title":"Source System",
            "maxLength":255,
            "type":"string",
            "description":"Reference code of the source application instance for an organization included in the plan scope.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SrInstanceId":{
            "title":"Source System",
            "type":"integer",
            "description":"Value identifier of the source application instance of an organization included in plan scope.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "Status":{
            "title":"Status",
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "StatusMeaning":{
            "maxLength":80,
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "SupplyPlanningModeMeaning":{
            "title":"Supply Planning Mode",
            "maxLength":80,
            "type":"string",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "WorkAreaType":{
            "type":"integer",
            "description":"Value that identifies the associated work area type.",
            "format":"int32",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":2
            },
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : link

Type: object

Show Source

• 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.

{
    "type":"object",
    "properties":{
        "kind":{
            "title":"kind",
            "type":"string",
            "description":"The kind of the related resource.",
            "enum":[
                "collection",
                "item",
                "describe",
                "other"
            ]
        },
        "rel":{
            "title":"relation",
            "type":"string",
            "description":"The name of the relation to the resource instance.  Example: self.",
            "enum":[
                "self",
                "lov",
                "parent",
                "canonical",
                "child",
                "enclosure",
                "action",
                "custom"
            ]
        },
        "name":{
            "title":"name",
            "type":"string",
            "description":"The name of the link to the related resource."
        },
        "href":{
            "title":"hyperlink reference",
            "type":"string",
            "description":"The URI to the related resource."
        },
        "properties":{
            "type":"object",
            "properties":{
                "changeIndicator":{
                    "type":"string",
                    "description":"Change indicator or the ETag value of the resource instance."
                }
            }
        }
    }
}

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{
    "type":"object",
    "properties":{
        "changeIndicator":{
            "type":"string",
            "description":"Change indicator or the ETag value of the resource instance."
        }
    }
}

Back to Top