Jump to

• Request
• Response

Get all plans

get

/fscmRestApi/resources/11.13.18.05/inventoryPlans

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 the inventory plan according to the value that identifies 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:
  

  • AppliesToOrderTypes; string; List 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; Time hierarchy used by the application to archive the plan.
  • ArchiveTimeLevel; integer; 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.
  • CalSsQuantEndItems; integer; Calculation of safety stock for the end items.
  • CalendarCode; string; Abbreviation used to identify the inventory planning calendar.
  • CreatedBy; string; Person who created the inventory plan.
  • CreationDate; string; Date the inventory plan was created.
  • CutoffDate; string; Final date of the planning period when demand and supply are no longer considered.
  • DeleteArchive; integer; 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; Description of the plan.
  • EnableForArchiving; integer; 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; 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; Exception set that the plan references. The exception set determines the types of exceptions the plan creates.
  • ExplodeModelForecasts; integer; 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; Plan output is available to the analytic module.
  • FirstPlanningBucketCode; integer; 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; Meaning 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.
  • 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; 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; List of parameters used to override the inventory engine's default behavior.
  • InventoryPlannedItems; number; Contains 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; Name associated with the inventory planning calendar.
  • ItemListPrice; integer; Item list price used by the inventory plan.
  • LastUpdatedBy; string; User who most recently updated the plan.
  • LastUpdatedDate; string; Date when the user most recently updated the plan.
  • 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.
  • PlanCompletionDate; string; Date when the planning process was completed.
  • PlanDimensionCatalog; integer; Dimension catalog used by the inventory plan.
  • PlanHorizonDays; integer; This attribute isn't used.
  • PlanHorizonStartDate; string; Date when the plan starts planning demand and inventory.
  • PlanId; integer; 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; Name of the plan.
  • 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; Owner of the plan.
  • PlanStartDate; string; 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.
  • PlanningBucketType; integer; Type of planning buckets: Week, Period, or Month.
  • PriceLists; string; List of price lists to consider in the plan. Each value is separated by a comma.
  • PrivatePlan; integer; If the plan is private, it can only be used by the owner.
  • 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; Value that uniquely identifies the second planning bucket.
  • SecondPlanningBucketName; string; Name 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; 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.
• 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 : inventoryPlans

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/inventoryPlans-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 inventoryPlans-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The items in the collection.",
    "items":{
        "$ref":"#/components/schemas/inventoryPlans-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 : inventoryPlans-item-response

Type: object

Show Source

• AppliesToOrderTypes: string
  Maximum Length: 255

  List 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: 22

  Abbreviation used to identify the inventory planning calendar.
• CalSsQuantEndItems: integer (int32)
  Calculation of safety stock for the end items.
• ComponentItems: array Component Items
  Title: Component Items

  Item structure components that are part of a supply plan.
• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  Person who created the inventory plan.
• CreationDate: string (date-time)
  Read Only: true

  Date 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: 100

  Description 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: true

  Maximum Length: 40

  Meaning 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: 255

  Calendar 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: 255

  Assignment 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: true

  Maximum Length: 250

  List of parameters used to override the inventory engine's default behavior.
• InventoryPlannedItems: number
  Read Only: true

  Contains 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: true

  Maximum Length: 4000

  Name associated with the inventory planning calendar.
• ItemListPrice: integer (int32)
  Item list price used by the inventory plan.
• Items: array Items
  Title: Items

  The Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who most recently updated the plan.
• LastUpdatedDate: string (date-time)
  Read Only: true

  Date when the user most recently updated the plan.
• links: array Links
  Title: Links

  The 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 Exceptions

  Exception 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: Name

  Maximum Length: 30

  Name 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: 64

  Owner 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: 1

  If the plan is private, it can only be used by the owner.
• Runs: array Run Plan
  Title: Run Plan

  Details 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: true

  Maximum Length: 40

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

{
    "type":"object",
    "properties":{
        "AppliesToOrderTypes":{
            "maxLength":255,
            "type":"string",
            "description":"List 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.",
            "nullable":true,
            "x-queryable":true
        },
        "ArchivePlan":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "ArchiveTimeHierarchy":{
            "type":"integer",
            "description":"Time hierarchy used by the application to archive the plan.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ArchiveTimeLevel":{
            "type":"integer",
            "description":"Time hierarchy level used by the application to archive the plan. The Archive Time Hierarchy attribute determines the available values for this attribute.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ArchiveVersionDays":{
            "type":"integer",
            "description":"Version used by the application to archive the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "AssignmentSetName":{
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-queryable":false
        },
        "CalSsQuantEndItems":{
            "type":"integer",
            "description":"Calculation of safety stock for the end items.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "CalendarCode":{
            "maxLength":22,
            "type":"string",
            "description":"Abbreviation used to identify the inventory planning calendar.",
            "nullable":true,
            "x-queryable":true
        },
        "ComponentItems":{
            "title":"Component Items",
            "type":"array",
            "description":"Item structure components that are part of a supply plan.",
            "items":{
                "$ref":"#/components/schemas/inventoryPlans-ComponentItems-item-response"
            }
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"Person who created the inventory plan.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Date the inventory plan was created.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CutoffDate":{
            "type":"string",
            "description":"Final date of the planning period when demand and supply are no longer considered.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "DeleteArchive":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "DemandSchedules":{
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "Description":{
            "maxLength":100,
            "type":"string",
            "description":"Description of the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "EnableForArchiving":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "EnableMultiThreading":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "ExceptionSet":{
            "type":"integer",
            "description":"Exception set that the plan references. The exception set determines the types of exceptions the plan creates.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ExplodeModelForecasts":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "ExposeToAnalytic":{
            "type":"integer",
            "description":"Plan output is available to the analytic module.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "FirstPlanningBucketCode":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "FirstPlanningBucketName":{
            "maxLength":40,
            "type":"string",
            "description":"Meaning associated with the FirstPlanningBucketCode attribute.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "FirstPlanningBucketNumber":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "ForecastError":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "GlobalFcstCalendarName":{
            "maxLength":255,
            "type":"string",
            "description":"Calendar used for spreading the global forecast. This field is enabled when the plan option Forecast Spreading is set to Spread forecast evenly.",
            "nullable":true,
            "x-queryable":false
        },
        "GlobalFcstDistrSetName":{
            "maxLength":255,
            "type":"string",
            "description":"Assignment set used to distribute the global forecast to the respective ship-from organizations.",
            "nullable":true,
            "x-queryable":false
        },
        "HasRun":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "HorizonForAverageDemand":{
            "type":"number",
            "description":"Number of days used by planning to calculate the average daily demand.",
            "nullable":true,
            "x-queryable":true
        },
        "IncludeProdMonitoringAlrts":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "InventoryParameterOverrides":{
            "maxLength":250,
            "type":"string",
            "description":"List of parameters used to override the inventory engine's default behavior.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "InventoryPlannedItems":{
            "type":"number",
            "description":"Contains 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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "InventoryPlanningCalendar":{
            "maxLength":4000,
            "type":"string",
            "description":"Name associated with the inventory planning calendar.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ItemListPrice":{
            "type":"integer",
            "description":"Item list price used by the inventory plan.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "Items":{
            "title":"Items",
            "type":"array",
            "description":"The Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution.",
            "items":{
                "$ref":"#/components/schemas/inventoryPlans-Items-item-response"
            }
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who most recently updated the plan.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdatedDate":{
            "type":"string",
            "description":"Date when the user most recently updated the plan.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "MaximumVarSafetyStockValue":{
            "type":"number",
            "description":"Maximum percent difference allowed between the safety stock quantity in one interval and the next.",
            "nullable":true,
            "x-queryable":true
        },
        "MeasureCatalogForArchival":{
            "type":"string",
            "description":"Measure catalog used by the application to archive the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "MinimumVarSafetyStockValue":{
            "type":"number",
            "description":"Minimum percent difference allowed between the safety stock quantity in one interval and the next.",
            "nullable":true,
            "x-queryable":true
        },
        "Organizations":{
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PastDueForecastBucket":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanAndSegmentExceptions":{
            "title":"Plan and Segment Exceptions",
            "type":"array",
            "description":"Exception details for the inventory plan. This can be used to capture any exceptions related to the inventory plan.",
            "items":{
                "$ref":"#/components/schemas/inventoryPlans-PlanAndSegmentExceptions-item-response"
            }
        },
        "PlanCompletionDate":{
            "type":"string",
            "description":"Date when the planning process was completed.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "PlanDimensionCatalog":{
            "type":"integer",
            "description":"Dimension catalog used by the inventory plan.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "PlanHorizonDays":{
            "type":"integer",
            "description":"This attribute isn't used.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanHorizonStartDate":{
            "type":"string",
            "description":"Date when the plan starts planning demand and inventory.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the plan.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "PlanItemLevelMembers":{
            "type":"string",
            "description":"List of level values in the item hierarchy to include in the scope of the plan. Each value is separated by a comma.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanMeasureCatalog":{
            "type":"string",
            "description":"Measure catalog used by the inventory plan.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanName":{
            "title":"Name",
            "maxLength":30,
            "type":"string",
            "description":"Name of the plan.",
            "nullable":false,
            "x-queryable":true
        },
        "PlanOrganizationLevelMembers":{
            "type":"string",
            "description":"List of level values in the organization hierarchy included in the scope of the plan. Each value is separated by a comma.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanOwner":{
            "maxLength":64,
            "type":"string",
            "description":"Owner of the plan.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanStartDate":{
            "type":"string",
            "description":"Date that represents the start date of the planning process.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "PlanStatus":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanType":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanningBucketType":{
            "type":"integer",
            "description":"Type of planning buckets: Week, Period, or Month.",
            "nullable":true,
            "x-queryable":true
        },
        "PriceLists":{
            "type":"string",
            "description":"List of price lists to consider in the plan. Each value is separated by a comma.",
            "nullable":true,
            "x-queryable":true
        },
        "PrivatePlan":{
            "type":"integer",
            "description":"If the plan is private, it can only be used by the owner.",
            "nullable":false,
            "default":1,
            "x-queryable":true
        },
        "Runs":{
            "title":"Run Plan",
            "type":"array",
            "description":"Details about the inventory plan that can be used to run inventory plans.",
            "items":{
                "$ref":"#/components/schemas/inventoryPlans-Runs-item-response"
            }
        },
        "SafetyStockForecastPlan":{
            "type":"string",
            "description":"Demand plan that includes the forecast and measures of forecast error used to determine safety stock.",
            "nullable":true,
            "x-queryable":true
        },
        "SafetyStockServiceLevel":{
            "type":"number",
            "description":"Percentage of service level used by the plan to calculate safety stock.",
            "nullable":true,
            "x-queryable":true
        },
        "SecondPlanningBucketCode":{
            "type":"integer",
            "description":"Value that uniquely identifies the second planning bucket.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "SecondPlanningBucketName":{
            "maxLength":40,
            "type":"string",
            "description":"Name of the second planning bucket.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SecondPlanningBucketNumber":{
            "type":"number",
            "description":"Number that uniquely identifies the second planning bucket.",
            "nullable":true,
            "x-queryable":true
        },
        "ShortPlanId":{
            "type":"integer",
            "description":"Abbreviated value that uniquely identifies the inventory plan.",
            "nullable":true,
            "x-queryable":true
        },
        "SimulationSet":{
            "type":"integer",
            "description":"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.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "SmMethodToCalSsInterval":{
            "type":"integer",
            "description":"This attribute isn't used.",
            "nullable":true,
            "x-queryable":true
        },
        "SsChngeIntervalDays":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        }
    }
}

Nested Schema : Component Items

Type: array

Title: Component Items

Item structure components that are part of a supply plan.

Show Source

• Array of: object inventoryPlans-ComponentItems-item-response

{
    "title":"Component Items",
    "type":"array",
    "description":"Item structure components that are part of a supply plan.",
    "items":{
        "$ref":"#/components/schemas/inventoryPlans-ComponentItems-item-response"
    }
}

Nested Schema : Items

Type: array

Title: Items

The Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution.

Show Source

• Array of: object inventoryPlans-Items-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The Items resource manages the items within a simulation set used as input for the Oracle Supply Chain Planning Cloud solution.",
    "items":{
        "$ref":"#/components/schemas/inventoryPlans-Items-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 : Plan and Segment Exceptions

Type: array

Title: Plan and Segment Exceptions

Exception details for the inventory plan. This can be used to capture any exceptions related to the inventory plan.

Show Source

• Array of: object inventoryPlans-PlanAndSegmentExceptions-item-response

{
    "title":"Plan and Segment Exceptions",
    "type":"array",
    "description":"Exception details for the inventory plan. This can be used to capture any exceptions related to the inventory plan.",
    "items":{
        "$ref":"#/components/schemas/inventoryPlans-PlanAndSegmentExceptions-item-response"
    }
}

Nested Schema : Run Plan

Type: array

Title: Run Plan

Details about the inventory plan that can be used to run inventory plans.

Show Source

• Array of: object inventoryPlans-Runs-item-response

{
    "title":"Run Plan",
    "type":"array",
    "description":"Details about the inventory plan that can be used to run inventory plans.",
    "items":{
        "$ref":"#/components/schemas/inventoryPlans-Runs-item-response"
    }
}

Nested Schema : inventoryPlans-ComponentItems-item-response

Type: object

Show Source

• AssemblyItem: string
  Title: Assembly Item

  Maximum Length: 250

  Name of the assembly item.
• AssemblyItemDescription: string
  Title: Assembly Item Description

  Maximum Length: 240

  Description of the assembly item.
• AssemblyItemId: integer
  Unique identifier of the assembly item.
• AssemblyItemUOM: string
  Title: Assembly Item UOM

  Maximum Length: 400

  Unit of measure of the assembly item.
• AssemblyItemUOMCode: string
  Title: Assembly Item UOM

  Maximum Length: 3

  Unit of measure code of the assembly item.
• AssemblyQuantity: number
  Title: Assembly Quantity

  Quantity of the assembly item.
• Basis: string
  Title: Basis

  Read Only: true

  Maximum Length: 80

  Identifies whether component item usage is based on the quantity of an item produced or for the entire lot.
• BillSequenceId: integer
  Value that uniquely identifies the sequence in which a component is used within an operation.
• BillSequenceIdSecondary: integer
  Value that uniquely identifies the sequence in which a component is used within an operation.
• ChangeIndicatorFlag: boolean
  Read Only: true

  Value that identifies whether the component item has been modified. Valid values are true or false. If true, then the row is new or modified. If false, then the row isn't new or modified.
• ComponentItem: string
  Title: Component Item

  Maximum Length: 250

  Name of the component item being consumed.
• ComponentItemDescription: string
  Title: Component Description

  Maximum Length: 240

  Description of the component item being consumed.
• ComponentItemEffectiveEndDate: string (date)
  Title: Component Item Effective End Date

  Start date of effectivity for this component.
• ComponentItemEffectiveStartDate: string (date)
  Title: Component Item Effective Start Date

  End date of effectivity for this component.
• ComponentItemId: integer
  Unique identifier of the component item.
• ComponentItemUOM: string
  Title: Component UOM

  Maximum Length: 400

  Unit of measure of the component item.
• ComponentItemUOMCode: string
  Maximum Length: 3

  Unit of measure code of the component item.
• ComponentSequenceId: integer
  Value that uniquely identifies the component on the source application instance.
• ComponentUsageQuantity: number
  Title: Usage Quantity

  Quantity of the component to build one unit of item based on the component's primary UOM.
• ComponentYield: number
  Title: Component Yield

  Factor used to multiply component quantity with to obtain the total quantity used of a component that actually becomes part of an assembly.
• ContributeToYield: integer (int32)
  Title: Contribute to Yield

  Value 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 Yield

  Maximum Length: 40

  Value 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: true

  Maximum Length: 255

  Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges.
• EnforceIntegerRequirement: string
  Title: Enforce Integer Requirement

  Read Only: true

  Maximum Length: 80

  Specifies whether the result of a component's calculated quantity or inverse quantity is required to be an integer. Valid values for this option are None, Round up, and Round down.
• FindNumber: integer
  Title: Find Number

  Number used to locate a specific instance of an item in a structure. This number enables users to define multiple occurrences of the same component for an assembly in its item structure.
• ItemSequence: integer
  Title: Material Sequence

  Number that indicates the sequence for a component item for a work order operation.
• ItemStructureName: string
  Title: Item Structure Name

  Maximum Length: 80

  Name for the categorization of an item structure, such as a design structure or manufacturing bill of material, that controls the usage and behavior of the structure.
• LastUpdateDate: string (date-time)
  Title: Last Updated Date

  Read Only: true

  Date when the component item was last updated.
• LastUpdatedBy: string
  Title: Last Updated By

  Read Only: true

  Maximum Length: 64

  Name of the user who last updated the component item.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• NewPlanId: integer (int64)
  Value that uniquely identifies the new plan that the duplication process creates.
• NewPlanIdSecondary: integer (int64)
  Value that uniquely identifies the new plan that the duplication process creates.
• NotesCount: integer
  Title: Notes

  Read Only: true

  Number of notes associated with this component item.
• OperationSequenceNumber: integer
  Title: Operation Sequence Number

  Read Only: true

  Order in which the operation occurs.
• Organization: string
  Read Only: true

  Maximum Length: 255

  Name of the organization.
• OrganizationCode: string
  Title: Organization

  Maximum Length: 49

  Organization code for the assembly item.
• OrganizationId: integer
  Unique identifier of the organization.
• OrganizationIdSecondary: integer
  Unique identifier of the organization.
• PlanId: integer
  Value that uniquely identifies the supply plan associated with the component item
• PlanIdSecondary: integer
  Value that uniquely identifies the supply plan associated with the component item
• PlanningPercentage: number
  Title: Planning Percentage

  Planning factor for this component as a percentage.
• Primary: string
  Title: Primary

  Read Only: true

  Maximum Length: 80

  Indicates if the component item is the primary item structure.
• ProducedItemType: number
  Title: Structure Item Type

  Read Only: true

  Structure type of the produced item. Values can be Formula, Model, Option Class, or Standard.
• ProducedItemTypeStr: string
  Title: Structure Item Type

  Maximum Length: 40

  Structure 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 Type

  Maximum Length: 4000

  Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE.
• WorkDefinitionName: string
  Title: Work Definition

  Maximum Length: 300

  Name of the work definition associated with this item structure.
• WorkDefUsageQuantity: number
  Title: Work Definition Quantity

  Number that represents the component requirement in the work definition.

{
    "type":"object",
    "properties":{
        "AssemblyItem":{
            "title":"Assembly Item",
            "maxLength":250,
            "type":"string",
            "description":"Name of the assembly item.",
            "nullable":true,
            "x-hints":{
                "controlType":"combo_lov",
                "operators":[
                    "STARTSWITH",
                    "ENDSWITH",
                    "=",
                    "<>",
                    "<",
                    "<=",
                    ">",
                    ">=",
                    "BETWEEN",
                    "NOTBETWEEN",
                    "CONTAINS",
                    "DOESNOTCONTAIN"
                ]
            },
            "x-queryable":true
        },
        "AssemblyItemDescription":{
            "title":"Assembly Item Description",
            "maxLength":240,
            "type":"string",
            "description":"Description of the assembly item.",
            "nullable":true,
            "x-queryable":true
        },
        "AssemblyItemId":{
            "type":"integer",
            "description":"Unique identifier of the assembly item.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "AssemblyItemUOM":{
            "title":"Assembly Item UOM",
            "maxLength":400,
            "type":"string",
            "description":"Unit of measure of the assembly item.",
            "nullable":true,
            "x-queryable":true
        },
        "AssemblyItemUOMCode":{
            "title":"Assembly Item UOM",
            "maxLength":3,
            "type":"string",
            "description":"Unit of measure code of the assembly item.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "AssemblyQuantity":{
            "title":"Assembly Quantity",
            "type":"number",
            "description":"Quantity of the assembly item.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "Basis":{
            "title":"Basis",
            "maxLength":80,
            "type":"string",
            "description":"Identifies whether component item usage is based on the quantity of an item produced or for the entire lot.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "BillSequenceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the sequence in which a component is used within an operation.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "BillSequenceIdSecondary":{
            "type":"integer",
            "description":"Value that uniquely identifies the sequence in which a component is used within an operation.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "ChangeIndicatorFlag":{
            "type":"boolean",
            "description":"Value that identifies whether the component item has been modified. Valid values are true or false. If true, then the row is new or modified. If false, then the row isn't new or modified.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ComponentItem":{
            "title":"Component Item",
            "maxLength":250,
            "type":"string",
            "description":"Name of the component item being consumed.",
            "nullable":true,
            "x-hints":{
                "controlType":"combo_lov",
                "operators":[
                    "STARTSWITH",
                    "ENDSWITH",
                    "=",
                    "<>",
                    "<",
                    "<=",
                    ">",
                    ">=",
                    "BETWEEN",
                    "NOTBETWEEN",
                    "CONTAINS",
                    "DOESNOTCONTAIN"
                ]
            },
            "x-queryable":true
        },
        "ComponentItemDescription":{
            "title":"Component Description",
            "maxLength":240,
            "type":"string",
            "description":"Description of the component item being consumed.",
            "nullable":true,
            "x-queryable":true
        },
        "ComponentItemEffectiveEndDate":{
            "title":"Component Item Effective End Date",
            "type":"string",
            "description":"Start date of effectivity for this component.",
            "format":"date",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ComponentItemEffectiveStartDate":{
            "title":"Component Item Effective Start Date",
            "type":"string",
            "description":"End date of effectivity for this component.",
            "format":"date",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ComponentItemId":{
            "type":"integer",
            "description":"Unique identifier of the component item.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ComponentItemUOM":{
            "title":"Component UOM",
            "maxLength":400,
            "type":"string",
            "description":"Unit of measure of the component item.",
            "nullable":true,
            "x-queryable":true
        },
        "ComponentItemUOMCode":{
            "maxLength":3,
            "type":"string",
            "description":"Unit of measure code of the component item.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ComponentSequenceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the component on the source application instance.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "ComponentUsageQuantity":{
            "title":"Usage Quantity",
            "type":"number",
            "description":"Quantity of the component to build one unit of item based on the component's primary UOM.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ComponentYield":{
            "title":"Component Yield",
            "type":"number",
            "description":"Factor used to multiply component quantity with to obtain the total quantity used of a component that actually becomes part of an assembly.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ContributeToYield":{
            "title":"Contribute to Yield",
            "type":"integer",
            "description":"Value that represents whether the components is enabled for contributing to the yield. The values can be Yes or No. The default value is No.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "ContributeToYieldString":{
            "title":"Contribute to Yield",
            "maxLength":40,
            "type":"string",
            "description":"Value that represents whether the components is enabled for contributing to the yield. The values can be Yes or No. The default value is No.",
            "nullable":true,
            "x-queryable":true
        },
        "DataSecurityEditAllowed":{
            "maxLength":255,
            "type":"string",
            "description":"Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "EnforceIntegerRequirement":{
            "title":"Enforce Integer Requirement",
            "maxLength":80,
            "type":"string",
            "description":"Specifies whether the result of a component's calculated quantity or inverse quantity is required to be an integer. Valid values for this option are None, Round up, and Round down.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "FindNumber":{
            "title":"Find Number",
            "type":"integer",
            "description":"Number used to locate a specific instance of an item in a structure. This number enables users to define multiple occurrences of the same component for an assembly in its item structure.",
            "nullable":true,
            "x-queryable":true
        },
        "ItemSequence":{
            "title":"Material Sequence",
            "type":"integer",
            "description":"Number that indicates the sequence for a component item for a work order operation.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "ItemStructureName":{
            "title":"Item Structure Name",
            "maxLength":80,
            "type":"string",
            "description":"Name for the categorization of an item structure, such as a design structure or manufacturing bill of material, that controls the usage and behavior of the structure.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "LastUpdateDate":{
            "title":"Last Updated Date",
            "type":"string",
            "description":"Date when the component item was last updated.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "title":"Last Updated By",
            "maxLength":64,
            "type":"string",
            "description":"Name of the user who last updated the component item.",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "controlType":"combo_lov"
            },
            "x-queryable":true
        },
        "NewPlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the new plan that the duplication process creates.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18
            },
            "x-queryable":true
        },
        "NewPlanIdSecondary":{
            "type":"integer",
            "description":"Value that uniquely identifies the new plan that the duplication process creates.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18
            },
            "x-queryable":true
        },
        "NotesCount":{
            "title":"Notes",
            "type":"integer",
            "description":"Number of notes associated with this component item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "OperationSequenceNumber":{
            "title":"Operation Sequence Number",
            "type":"integer",
            "description":"Order in which the operation occurs.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "Organization":{
            "maxLength":255,
            "type":"string",
            "description":"Name of the organization.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "OrganizationCode":{
            "title":"Organization",
            "maxLength":49,
            "type":"string",
            "description":"Organization code for the assembly item.",
            "nullable":true,
            "x-hints":{
                "controlType":"combo_lov",
                "operators":[
                    "STARTSWITH",
                    "ENDSWITH",
                    "=",
                    "<>",
                    "CONTAINS",
                    "DOESNOTCONTAIN"
                ]
            },
            "x-queryable":true
        },
        "OrganizationId":{
            "type":"integer",
            "description":"Unique identifier of the organization.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "OrganizationIdSecondary":{
            "type":"integer",
            "description":"Unique identifier of the organization.",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the supply plan associated with the component item",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "PlanIdSecondary":{
            "type":"integer",
            "description":"Value that uniquely identifies the supply plan associated with the component item",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true
            },
            "x-queryable":true
        },
        "PlanningPercentage":{
            "title":"Planning Percentage",
            "type":"number",
            "description":"Planning factor for this component as a percentage.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "Primary":{
            "title":"Primary",
            "maxLength":80,
            "type":"string",
            "description":"Indicates if the component item is the primary item structure.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ProducedItemType":{
            "title":"Structure Item Type",
            "type":"number",
            "description":"Structure type of the produced item. Values can be Formula, Model, Option Class, or Standard.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ProducedItemTypeStr":{
            "title":"Structure Item Type",
            "maxLength":40,
            "type":"string",
            "description":"Structure type of the produced item. Values can be Formula, Model, Option Class, or Standard.",
            "nullable":true,
            "x-queryable":true
        },
        "SimulationSetId":{
            "type":"integer",
            "description":"Value that uniquely identifies the simulation set.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18
            },
            "x-queryable":true
        },
        "SimulationSetIdSecondary":{
            "type":"integer",
            "description":"Value that uniquely identifies the simulation set.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18
            },
            "x-queryable":true
        },
        "SupplyType":{
            "title":"Supply Type",
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice",
                "operators":[
                    "="
                ]
            },
            "x-queryable":true
        },
        "WorkDefUsageQuantity":{
            "title":"Work Definition Quantity",
            "type":"number",
            "description":"Number that represents the component requirement in the work definition.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkDefinitionName":{
            "title":"Work Definition",
            "maxLength":300,
            "type":"string",
            "description":"Name of the work definition associated with this item structure.",
            "nullable":true,
            "x-hints":{
                "controlType":"combo_lov"
            },
            "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."
        }
    }
}

Nested Schema : inventoryPlans-Items-item-response

Type: object

Show Source

• ABCClass: string
  Maximum Length: 40

  Code assigned to the item for classification purposes. Items are divided into categories called ABC classes, such as A, B, and C, according to a criterion such as revenue generation, turnover, or value.
• AcceptableEarlyDays: integer
  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: true

  Value that indicates whether common supplies are used in case the project inventory isn't sufficient during the demand and supply netting process. Valid values are: 1 or 2. If 1, then common supplies are used. If 2, then not.
• AllowUseOfCommonSuppliesMeaning: string
  Read Only: true

  Maximum Length: 4000

  Indicates whether to allow use of common supplies when the project inventory isn't sufficient during the demand and supply netting process. Valid values are Yes and No.
• AlternateUOM: string
  Read Only: true

  Maximum Length: 4000

  Secondary 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: true

  Maximum Length: 1

  Number of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time.
• ATPComponentsMeaning: string
  Read Only: true

  Maximum Length: 4000

  Indicates whether to include additional components in the item structure for assemble-to-order and pick-to-order items when performing available-to-promise checking. Valid values are Yes and No.
• Attribute1: string
  Read Only: true

  Maximum Length: 20

  Value that identifies planning attribute number 1 for the descriptive flexfield.
• Attribute2: string
  Read Only: true

  Maximum Length: 20

  Value that identifies planning attribute number 2 for the descriptive flexfield.
• Attribute3: string
  Read Only: true

  Maximum Length: 20

  Value that identifies planning attribute number 3 for the descriptive flexfield.
• Attribute4: string
  Read Only: true

  Maximum Length: 20

  Value that identifies planning attribute number 4 for the descriptive flexfield.
• Attribute5: string
  Read Only: true

  Maximum Length: 20

  Value that identifies planning attribute number 5 for the descriptive flexfield.
• AttributeChar1: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 1 of type character for the demand in a backlog management plan.
• AttributeChar10: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 10 of type character for the demand in a backlog management plan.
• AttributeChar11: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 11 of type character for the demand in a backlog management plan.
• AttributeChar12: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 12 of type character for the demand in a backlog management plan.
• AttributeChar13: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 13 of type character for the demand in a backlog management plan.
• AttributeChar14: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 14 of type character for the demand in a backlog management plan.
• AttributeChar15: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 15 of type character for the demand in a backlog management plan.
• AttributeChar16: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 16 of type character for the demand in a backlog management plan.
• AttributeChar17: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 17 of type character for the demand in a backlog management plan.
• AttributeChar18: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 18 of type character for the demand in a backlog management plan.
• AttributeChar19: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 19 of type character for the demand in a backlog management plan.
• AttributeChar2: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 2 of type character for the demand in a backlog management plan.
• AttributeChar20: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 20 of type character for the demand in a backlog management plan.
• AttributeChar3: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 3 of type character for the demand in a backlog management plan.
• AttributeChar4: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 4 of type character for the demand in a backlog management plan.
• AttributeChar5: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 5 of type character for the demand in a backlog management plan.
• AttributeChar6: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 6 of type character for the demand in a backlog management plan.
• AttributeChar7: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 7 of type character for the demand in a backlog management plan.
• AttributeChar8: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 8 of type character for the demand in a backlog management plan.
• AttributeChar9: string
  Read Only: true

  Maximum Length: 150

  Value for the descriptive flexfield attribute number 9 of type character for the demand in a backlog management plan.
• AttributeDate1: string (date)
  Read Only: true

  Value for the descriptive flexfield attribute number 1 of type date for the demand in a backlog management plan.
• AttributeDate2: string (date)
  Read Only: true

  Value for the descriptive flexfield attribute number 2 of type date for the demand in a backlog management plan.
• AttributeDate3: string (date)
  Read Only: true

  Value for the descriptive flexfield attribute number 3 of type date for the demand in a backlog management plan.
• AttributeDate4: string (date)
  Read Only: true

  Value for the descriptive flexfield attribute number 4 of type date for the demand in a backlog management plan.
• AttributeDate5: string (date)
  Read Only: true

  Value for the descriptive flexfield attribute number 5 of type date for the demand in a backlog management plan.
• AttributeNumber1: number
  Read Only: true

  Value for the descriptive flexfield attribute number 1 of type number for the demand in a backlog management plan.
• AttributeNumber2: number
  Read Only: true

  Value for the descriptive flexfield attribute number 2 of type number for the demand in a backlog management plan.
• AttributeNumber3: number
  Read Only: true

  Value for the descriptive flexfield attribute number 3 of type number for the demand in a backlog management plan.
• AttributeNumber4: number
  Read Only: true

  Value for the descriptive flexfield attribute number 4 of type number for the demand in a backlog management plan.
• AttributeNumber5: number
  Read Only: true

  Value for the descriptive flexfield attribute number 5 of type number for the demand in a backlog management plan.
• AutocreatedConfiguration: integer
  Read Only: true

  Value that indicates whether the item is a configured item or not. Valid values are: 1 or 2. If 1, then item is a configured item. If 2, then not.
• AutocreatedConfigurationMeaning: string
  Read Only: true

  Maximum Length: 4000

  Value that indicates whether the item is configured or not. Valid values are: Yes or No. If Yes, then the item is configured. If No, then the item isn't configured.
• 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: true

  Maximum Length: 4000

  Value that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: Yes or No. If Yes, then the item is enabled for back-to-back ordering. If No, then the item isn't enabled for back-to-back ordering.
• BackToBackEnabled: integer
  Read Only: true

  Value that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: 1 or 2. If 1, then item is enabled for back-to-back ordering. If 2, then not.
• BaseModel: string
  Read Only: true

  Maximum Length: 4000

  Value that uniquely identifies the model to use when creating an assemble-to-order configuration.
• BuildInWIP: string
  Read Only: true

  Maximum Length: 4000

  Value that indicates whether work orders can be created or not. Valid values are Yes or No. If Yes, then work orders can be created. If No, then work orders can't be created.
• BuildInWIPOption: integer
  Read Only: true

  Contains one of the following values: 1 or 2. If 1, then work orders can be created. If No, then work orders can't be created.
• Buyer: string
  Maximum Length: 240

  Name 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: true

  Maximum Length: 4000

  Value that indicates whether to enable the available-to-promise rule in Oracle Fusion Cloud Global Order Promising. Valid values are Yes or No. If Yes, then the available-to-promise rule is enabled. If No, then the available-to-promise rule isn't enabled.
• CatalogId: integer
  Read Only: true

  Value that uniquely identifies the catalog.
• Category: string
  Title: Category

  Read Only: true

  Maximum Length: 4000

  Category of the item in the exception. the category is derived from the default product hierarchy or any product hierarchy of the item associated in the plan's dimension catalog.
• CategoryDescription: string
  Read Only: true

  Maximum Length: 4000

  Description associated with a product category.
• CategoryId: integer
  Read Only: true

  Value that uniquely identifies an item category.
• ConsiderInClearToBuild: string
  Maximum Length: 1

  Value that indicates whether to include this component item when calculating clear-to-build for an assembly item. Valid values are 1 or 2. If 1, then this component item is included. If 2, then it's not.
• ConsiderInClearToBuildMeaning: string
  Read Only: true

  Maximum Length: 4000

  Value that indicates whether to include this component item when calculating clear to build for an assembly item. Valid values are Yes or No. If Yes, then this component item is included. If No, then this component item isn't included.
• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User 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: true

  Maximum Length: 4000

  Value that indicates whether planning creates planned orders for this item. Valid values are Yes or No. If Yes, then planned orders are created. If No, then planned orders aren't created.
• CreationDate: string (date-time)
  Read Only: true

  Date 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: true

  Maximum Length: 4000

  Value that indicates whether the item is a critical component or not. Valid values are Yes or No. If Yes, then the item is a critical component. If No, then the item isn't a critical component.
• CumulativeManufacturingLt: number
  Read Only: true

  Number of days required to manufacture the item, including the adjusted, cumulative, and total lead time for the component that requires the longest time to assemble.
• Currency: string
  Read Only: true

  Maximum Length: 30

  Value that indicates the currency associated with the item's price and cost.
• DataSecurityEditAllowed: string
  Read Only: true

  Maximum Length: 255

  Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges.
• DaysOfCover: number
  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: true

  Date 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: true

  Maximum Length: 4000

  Value that identifies the point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.
• Description: string
  Maximum Length: 240

  Description of the item.
• DiscountPercentage: number
  Average discount for the item.
• EnforcePurchaseLtMeaning: string
  Read Only: true

  Maximum Length: 4000

  Value that indicates whether purchasing lead times are imposed as a hard constraint during constraint-based planning. Valid values are: 1 or 2. If 1, then purchasing lead times are enforced. If 2, then not.
• 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: true

  Number 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: true

  Maximum Length: 4000

  Value that indicates how the forecast is exploded and consumed. This attribute isn't currently used.
• ForecastErrorType: string
  Maximum Length: 30

  Value that indicates how the quality of a forecast is measured. A list of accepted values is defined in the lookup type MSC_FORECAST_ERROR_TYPES.
• ForecastErrorTypeStr: string
  Read Only: true

  Maximum Length: 4000

  Meaning associated with the ForecastErrorType Code attribute.
• ForecastName: string
  Read Only: true

  Maximum Length: 4000

  Name of the forecast used for safety stock calculation.
• GlobalAttributeChar1: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 1 of type character in the descriptive flexfield.
• GlobalAttributeChar10: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 10 of type character in the descriptive flexfield.
• GlobalAttributeChar11: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 11 of type character in the descriptive flexfield.
• GlobalAttributeChar12: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 12 of type character in the descriptive flexfield.
• GlobalAttributeChar13: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 13 of type character in the descriptive flexfield.
• GlobalAttributeChar14: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 14 of type character in the descriptive flexfield.
• GlobalAttributeChar15: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 15 of type character in the descriptive flexfield.
• GlobalAttributeChar16: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 16 of type character in the descriptive flexfield.
• GlobalAttributeChar17: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 17 of type character in the descriptive flexfield.
• GlobalAttributeChar18: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 18 of type character in the descriptive flexfield.
• GlobalAttributeChar19: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 19 of type character in the descriptive flexfield.
• GlobalAttributeChar2: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 2 of type character in the descriptive flexfield.
• GlobalAttributeChar20: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 20 of type character in the descriptive flexfield.
• GlobalAttributeChar3: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 3 of type character in the descriptive flexfield.
• GlobalAttributeChar4: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 4 of type character in the descriptive flexfield.
• GlobalAttributeChar5: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 5 of type character in the descriptive flexfield.
• GlobalAttributeChar6: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 6 of type character in the descriptive flexfield.
• GlobalAttributeChar7: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 7 of type character in the descriptive flexfield.
• GlobalAttributeChar8: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 8 of type character in the descriptive flexfield.
• GlobalAttributeChar9: string
  Read Only: true

  Maximum Length: 150

  Value that identifies planning global attribute number 9 of type character in the descriptive flexfield.
• GlobalAttributeDate1: string (date)
  Read Only: true

  Value that identifies planning global attribute number 1 of type date in the descriptive flexfield.
• GlobalAttributeDate2: string (date)
  Read Only: true

  Value that identifies planning global attribute number 2 of type date in the descriptive flexfield.
• GlobalAttributeDate3: string (date)
  Read Only: true

  Value that identifies planning global attribute number 3 of type date in the descriptive flexfield.
• GlobalAttributeDate4: string (date)
  Read Only: true

  Value that identifies planning global attribute number 4 of type date in the descriptive flexfield.
• GlobalAttributeDate5: string (date)
  Read Only: true

  Value that identifies planning global attribute number 5 of type date in the descriptive flexfield.
• GlobalAttributeNumber1: number
  Read Only: true

  Value that identifies planning global attribute number 1 in the descriptive flexfield.
• GlobalAttributeNumber2: number
  Read Only: true

  Value that identifies planning global attribute number 2 in the descriptive flexfield.
• GlobalAttributeNumber3: number
  Read Only: true

  Value that identifies planning global attribute number 3 in the descriptive flexfield.
• GlobalAttributeNumber4: number
  Read Only: true

  Value that identifies planning global attribute number 4 in the descriptive flexfield.
• GlobalAttributeNumber5: number
  Read Only: true

  Value that identifies planning global attribute number 5 in the descriptive flexfield.
• HardPeggingLevel: string
  Read Only: true

  Maximum Length: 25

  Value that identifies the type of pegging considered by the planning engine during the supply and demand netting process. A list of accepted values is defined in the lookup type ORA_MSC_HARD_PEGGING_LEVEL.
• HardPeggingLevelStr: string
  Read Only: true

  Maximum Length: 4000

  Meaning associated with the HardPeggingLevel attribute.
• IntermittentDemand: number
  Value that indicates whether the demand for the item has an irregular frequency or not. Valid values are: 1 or 2. If 1, then demand for the item has an irregular frequency . If 2, then not.
• IntermittentDemandMeaning: string
  Read Only: true

  Maximum Length: 4000

  Indicates whether the demand has an irregular frequency. Valid values are Yes and No.
• 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: true

  Maximum Length: 4000

  Value specified by the user to determine whether to override intermittent demand, which indicates whether the demand has an irregular frequency or not. Valid values are Yes and No.
• InventoryItemId: integer (int64)
  Value that uniquely identifies the item.
• ItemCostUOM: string
  Read Only: true

  Maximum Length: 4000

  Unit of measure associated with an item's cost.
• ItemName: string
  Maximum Length: 300

  Name of the item.
• ItemStructureType: string
  Read Only: true

  Maximum Length: 4000

  Value that indicates the type of bill of material. A list of accepted values is defined in the lookup type ORA_MSC_BOM_ITEM_TYPE.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the user most recently updated the item.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User most recently updated the item.
• LeadTimeLotSize: number
  Read Only: true

  Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate.
• 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: 120

  Name of lifecycle phase of the item.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LotControl: string
  Read Only: true

  Maximum Length: 4000

  Meaning associated with the LotControlCode attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE.
• LotControlCode: integer
  Read Only: true

  Value that identifies whether the item is lot controlled. Valid values are 1 and 2. If 1, then lot control isn't established for the item. If 2, then lot control is used to track inventory balances by the lot number. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE.
• LotExpirationControl: string
  Read Only: true

  Maximum Length: 4000

  Meaning associated with the LotsExpiration attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL.
• LotsExpiration: integer
  Read Only: true

  Value that identifies how lot expiration dates are calculated. Valid values are 1 and 2. If 1, then lots don't expire. If 2, then lot expiration is based on the number of shelf life days for the item. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL.
• MAD: number
  Read Only: true

  Value 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: true

  Maximum Length: 4000

  Value that indicates whether the item is manufactured or purchased. Valid values are Make or Buy. If Make, then the item is manufactured. If Buy, then the item is purchased. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MAKE_BUY.
• MAPE: number
  Read Only: true

  Value 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: true

  Selling 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: true

  Indicates 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: true

  The 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: true

  Maximum Length: 4000

  Value that determines whether the order modifier for the item should be applied to the start quantity of the supply for the item. Valid values are Yes or No.
• Organization: string
  Maximum Length: 49

  Abbreviation that identifies the organization associated with the item.
• OrganizationId: integer (int64)
  Value that uniquely identifies the organization.
• PickComponents: integer
  Read Only: true

  Value that indicates whether the item can be picked from finished goods inventory. Valid values are: 1 or 2. If 1, then the item can be picked from finished goods inventory. If 2, then not.
• PickComponentsMeaning: string
  Read Only: true

  Maximum Length: 4000

  Value that indicates whether the item can be picked from the finished goods inventory. Valid values are: Yes or No. If Yes, then the item can be picked from the finished goods inventory. If No, then the item can't be picked from the finished goods inventory.
• PlannedSafetyStockType: string
  Read Only: true

  Maximum Length: 4000

  Type of safety stock planning used to calculate safety stock for the item and organization combination. A list of accepted values is defined in the lookup type ORA_MSC_PLANNED_SS_TYPE.
• PlannedSafetyStockTypeIndicator: integer (int32)
  Read Only: true

  Abbreviation that identifies the type of safety stock planning used to calculate safety stock for the item and organization combination. A list of accepted values is defined in the lookup type ORA_MSC_PLANNED_SS_TYPE.
• Planner: string
  Maximum Length: 10

  Abbreviation that identifies the planner responsible for the item.
• PlannerDescription: string
  Read Only: true

  Maximum Length: 4000

  Description of the planner responsible for the item.
• PlanningMethod: string
  Read Only: true

  Maximum Length: 4000

  Value that indicates the type of planning used for the item. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_CODE.
• PlanningMethodCode: integer
  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: true

  Date 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: true

  Maximum Length: 4000

  Value that identifies the point in time inside which the planning process won't schedule a supply order to be due. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.
• PostprocessingLeadTime: number
  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: true

  Date 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: true

  Maximum Length: 4000

  Value that identifies the point in time inside which planned orders with certain criteria are automatically released as work orders or purchase orders. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.
• Rounding: integer
  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: true

  Maximum Length: 4000

  Value that indicates whether the planned order quantity is rounded to a whole number or not. Valid values are: Yes or No. If Yes, then the planned order quantity is rounded. If No, then the planned order quantity isn't rounded.
• RowModified: string
  Read Only: true

  Maximum Length: 255

  Text that identifies whether the row is new or modified. Valid values are yes or null. If yes, then the row is new or modified. If null, then the row isn't new or modified.
• 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: true

  Maximum Length: 4000

  Demand plan that contains the forecast and forecast error measures that the plan uses to calculate safety stock.
• SafetyStockPlanningMethod: string
  Maximum Length: 4000

  Meaning 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: true

  Value that uniquely identifies segment of items in inventory plan.
• SegmentDescription: string
  Read Only: true

  Description of segment associated with exception.
• SegmentId: integer (int64)
  Read Only: true

  Value 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: true

  Maximum Length: 4000

  Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE.
• UnitVolume: number
  Read Only: true

  Volume of one item.
• UnitWeight: number
  Read Only: true

  Weight of one item.
• UOM: string
  Read Only: true

  Maximum Length: 4000

  Planning unit of measure of the item.
• UOMCode: string
  Read Only: true

  Maximum Length: 3

  Abbreviation that identifies the unit of measure associated with the order quantity.
• UseUpDate: string (date)
  Read Only: true

  Date when the current on-hand quantity for an item is exhausted based on projected gross requirements.
• VariableLeadTime: number
  Time to produce one unit of an assembly.
• VolumeUOMName: string
  Read Only: true

  Maximum Length: 4000

  Unit of measure to use for the item volume.
• WeightUOMName: string
  Read Only: true

  Maximum Length: 4000

  Unit of measure to use for the item weight.

{
    "type":"object",
    "properties":{
        "ABCClass":{
            "maxLength":40,
            "type":"string",
            "description":"Code assigned to the item for classification purposes. Items are divided into categories called ABC classes, such as A, B, and C, according to a criterion such as revenue generation, turnover, or value.",
            "nullable":true,
            "x-queryable":true
        },
        "ATPComponents":{
            "maxLength":1,
            "type":"string",
            "description":"Number of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ATPComponentsMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Indicates whether to include additional components in the item structure for assemble-to-order and pick-to-order items when performing available-to-promise checking. Valid values are Yes and No.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AcceptableEarlyDays":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "AllowUseOfCommonSupplies":{
            "type":"integer",
            "description":"Value that indicates whether common supplies are used in case the project inventory isn't sufficient during the demand and supply netting process. Valid values are: 1 or 2. If 1, then common supplies are used. If 2, then not.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AllowUseOfCommonSuppliesMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Indicates whether to allow use of common supplies when the project inventory isn't sufficient during the demand and supply netting process. Valid values are Yes and No.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AlternateUOM":{
            "maxLength":4000,
            "type":"string",
            "description":"Secondary unit of measure for the item, represented as an alternate unit of measure in planning.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AnnualCarryingCostPercentage":{
            "type":"number",
            "description":"Percent of unit cost that represents the internal cost to stock one unit for one year.",
            "nullable":true,
            "x-queryable":true
        },
        "Attribute1":{
            "maxLength":20,
            "type":"string",
            "description":"Value that identifies planning attribute number 1 for the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Attribute2":{
            "maxLength":20,
            "type":"string",
            "description":"Value that identifies planning attribute number 2 for the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Attribute3":{
            "maxLength":20,
            "type":"string",
            "description":"Value that identifies planning attribute number 3 for the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Attribute4":{
            "maxLength":20,
            "type":"string",
            "description":"Value that identifies planning attribute number 4 for the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Attribute5":{
            "maxLength":20,
            "type":"string",
            "description":"Value that identifies planning attribute number 5 for the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar1":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 1 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar10":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 10 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar11":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 11 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar12":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 12 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar13":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 13 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar14":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 14 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar15":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 15 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar16":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 16 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar17":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 17 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar18":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 18 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar19":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 19 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar2":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 2 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar20":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 20 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar3":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 3 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar4":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 4 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar5":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 5 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar6":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 6 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar7":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 7 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar8":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 8 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeChar9":{
            "maxLength":150,
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 9 of type character for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeDate1":{
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 1 of type date for the demand in a backlog management plan.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeDate2":{
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 2 of type date for the demand in a backlog management plan.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeDate3":{
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 3 of type date for the demand in a backlog management plan.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeDate4":{
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 4 of type date for the demand in a backlog management plan.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeDate5":{
            "type":"string",
            "description":"Value for the descriptive flexfield attribute number 5 of type date for the demand in a backlog management plan.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeNumber1":{
            "type":"number",
            "description":"Value for the descriptive flexfield attribute number 1 of type number for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeNumber2":{
            "type":"number",
            "description":"Value for the descriptive flexfield attribute number 2 of type number for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeNumber3":{
            "type":"number",
            "description":"Value for the descriptive flexfield attribute number 3 of type number for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeNumber4":{
            "type":"number",
            "description":"Value for the descriptive flexfield attribute number 4 of type number for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AttributeNumber5":{
            "type":"number",
            "description":"Value for the descriptive flexfield attribute number 5 of type number for the demand in a backlog management plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AutocreatedConfiguration":{
            "type":"integer",
            "description":"Value that indicates whether the item is a configured item or not. Valid values are: 1 or 2. If 1, then item is a configured item. If 2, then not.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AutocreatedConfigurationMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether the item is configured or not. Valid values are: Yes or No. If Yes, then the item is configured. If No, then the item isn't configured.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AverageInterarrivalTime":{
            "type":"number",
            "description":"Average time, expressed in days, between intervals.",
            "nullable":true,
            "x-queryable":true
        },
        "AverageInterarrivalTimeOvrride":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "BackToBack":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: Yes or No. If Yes, then the item is enabled for back-to-back ordering. If No, then the item isn't enabled for back-to-back ordering.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "BackToBackEnabled":{
            "type":"integer",
            "description":"Value that indicates whether the item is enabled for back-to-back ordering or not. Valid values are: 1 or 2. If 1, then item is enabled for back-to-back ordering. If 2, then not.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "BaseModel":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that uniquely identifies the model to use when creating an assemble-to-order configuration.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "BuildInWIP":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether work orders can be created or not. Valid values are Yes or No. If Yes, then work orders can be created. If No, then work orders can't be created.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "BuildInWIPOption":{
            "type":"integer",
            "description":"Contains one of the following values: 1 or 2. If 1, then work orders can be created. If No, then work orders can't be created.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Buyer":{
            "maxLength":240,
            "type":"string",
            "description":"Name of the buyer associated with the item.",
            "nullable":true,
            "x-queryable":true
        },
        "CalculateATPIndicator":{
            "type":"integer",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "CalculateATPMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether to enable the available-to-promise rule in Oracle Fusion Cloud Global Order Promising. Valid values are Yes or No. If Yes, then the available-to-promise rule is enabled. If No, then the available-to-promise rule isn't enabled.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CatalogId":{
            "type":"integer",
            "description":"Value that uniquely identifies the catalog.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Category":{
            "title":"Category",
            "maxLength":4000,
            "type":"string",
            "description":"Category of the item in the exception. the category is derived from the default product hierarchy or any product hierarchy of the item associated in the plan's dimension catalog.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CategoryDescription":{
            "maxLength":4000,
            "type":"string",
            "description":"Description associated with a product category.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CategoryId":{
            "type":"integer",
            "description":"Value that uniquely identifies an item category.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ConsiderInClearToBuild":{
            "maxLength":1,
            "type":"string",
            "description":"Value that indicates whether to include this component item when calculating clear-to-build for an assembly item. Valid values are 1 or 2. If 1, then this component item is included. If 2, then it's not.",
            "nullable":true,
            "x-queryable":true
        },
        "ConsiderInClearToBuildMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether to include this component item when calculating clear to build for an assembly item. Valid values are Yes or No. If Yes, then this component item is included. If No, then this component item isn't included.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CreateSupply":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "CreateSupplyAfter":{
            "type":"string",
            "description":"Date after which supplies can be created. This attribute is editable only when the CreateSupply attribute is set to 1.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "CreateSupplyMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether planning creates planned orders for this item. Valid values are Yes or No. If Yes, then planned orders are created. If No, then planned orders aren't created.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the item.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the user created the supplier item.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CriticalComponent":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "CriticalComponentMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether the item is a critical component or not. Valid values are Yes or No. If Yes, then the item is a critical component. If No, then the item isn't a critical component.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CumulativeManufacturingLt":{
            "type":"number",
            "description":"Number of days required to manufacture the item, including the adjusted, cumulative, and total lead time for the component that requires the longest time to assemble.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Currency":{
            "maxLength":30,
            "type":"string",
            "description":"Value that indicates the currency associated with the item's price and cost.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "DataSecurityEditAllowed":{
            "maxLength":255,
            "type":"string",
            "description":"Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "DaysOfCover":{
            "type":"number",
            "description":"Number of days of cover for the item. Days of Cover is multiplied by the average demand to calculate the safety stock level.",
            "nullable":true,
            "x-queryable":true
        },
        "DaysOfCoverDemandPeriod":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "DemandTimeFenceCode":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "DemandTimeFenceDate":{
            "type":"string",
            "description":"Date before which forecast demand is ignored.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "DemandTimeFenceDays":{
            "type":"integer",
            "description":"Time horizon, expressed in number of days, within which forecast demand is ignored.",
            "nullable":true,
            "x-queryable":true
        },
        "DemandTimeFenceType":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that identifies the point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Description":{
            "maxLength":240,
            "type":"string",
            "description":"Description of the item.",
            "nullable":true,
            "x-queryable":true
        },
        "DiscountPercentage":{
            "type":"number",
            "description":"Average discount for the item.",
            "nullable":true,
            "x-queryable":true
        },
        "EnforcePurchaseLtMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether purchasing lead times are imposed as a hard constraint during constraint-based planning. Valid values are: 1 or 2. If 1, then purchasing lead times are enforced. If 2, then not.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "EnforcePurchasingLeadTime":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "ExcessHorizon":{
            "type":"number",
            "description":"Time horizon, expressed in number of days, after which inventory is considered excess.",
            "nullable":true,
            "x-queryable":true
        },
        "FixedDaysOfSupply":{
            "type":"number",
            "description":"Number of days to use to modify the size and timing of each planned order quantity.",
            "nullable":true,
            "x-queryable":true
        },
        "FixedDaysSupply":{
            "type":"number",
            "description":"Number of days to use to modify the size and timing of each planned order quantity.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "FixedLeadTime":{
            "type":"number",
            "description":"Number of days required to assemble an item independent of the sales order quantity, such as setup time or tear down time.",
            "nullable":true,
            "x-queryable":true
        },
        "FixedLotMultiplier":{
            "type":"number",
            "description":"Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate.",
            "nullable":true,
            "x-queryable":true
        },
        "FixedOrderQuantity":{
            "type":"number",
            "description":"Quantity to use to modify the size of each planned order quantity or each repetitive daily rate.",
            "nullable":true,
            "x-queryable":true
        },
        "ForecastControl":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates how the forecast is exploded and consumed. This attribute isn't currently used.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ForecastErrorType":{
            "maxLength":30,
            "type":"string",
            "description":"Value that indicates how the quality of a forecast is measured. A list of accepted values is defined in the lookup type MSC_FORECAST_ERROR_TYPES.",
            "nullable":true,
            "x-queryable":true
        },
        "ForecastErrorTypeStr":{
            "maxLength":4000,
            "type":"string",
            "description":"Meaning associated with the ForecastErrorType Code attribute.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ForecastName":{
            "maxLength":4000,
            "type":"string",
            "description":"Name of the forecast used for safety stock calculation.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar1":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 1 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar10":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 10 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar11":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 11 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar12":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 12 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar13":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 13 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar14":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 14 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar15":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 15 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar16":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 16 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar17":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 17 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar18":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 18 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar19":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 19 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar2":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 2 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar20":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 20 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar3":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 3 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar4":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 4 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar5":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 5 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar6":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 6 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar7":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 7 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar8":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 8 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeChar9":{
            "maxLength":150,
            "type":"string",
            "description":"Value that identifies planning global attribute number 9 of type character in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeDate1":{
            "type":"string",
            "description":"Value that identifies planning global attribute number 1 of type date in the descriptive flexfield.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeDate2":{
            "type":"string",
            "description":"Value that identifies planning global attribute number 2 of type date in the descriptive flexfield.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeDate3":{
            "type":"string",
            "description":"Value that identifies planning global attribute number 3 of type date in the descriptive flexfield.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeDate4":{
            "type":"string",
            "description":"Value that identifies planning global attribute number 4 of type date in the descriptive flexfield.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeDate5":{
            "type":"string",
            "description":"Value that identifies planning global attribute number 5 of type date in the descriptive flexfield.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeNumber1":{
            "type":"number",
            "description":"Value that identifies planning global attribute number 1 in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeNumber2":{
            "type":"number",
            "description":"Value that identifies planning global attribute number 2 in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeNumber3":{
            "type":"number",
            "description":"Value that identifies planning global attribute number 3 in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeNumber4":{
            "type":"number",
            "description":"Value that identifies planning global attribute number 4 in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "GlobalAttributeNumber5":{
            "type":"number",
            "description":"Value that identifies planning global attribute number 5 in the descriptive flexfield.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "HardPeggingLevel":{
            "maxLength":25,
            "type":"string",
            "description":"Value that identifies the type of pegging considered by the planning engine during the supply and demand netting process. A list of accepted values is defined in the lookup type ORA_MSC_HARD_PEGGING_LEVEL.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "HardPeggingLevelStr":{
            "maxLength":4000,
            "type":"string",
            "description":"Meaning associated with the HardPeggingLevel attribute.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "IntermittentDemand":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "IntermittentDemandMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Indicates whether the demand has an irregular frequency. Valid values are Yes and No.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "IntermittentDemandOverride":{
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "IntermittentDemandOverrideStr":{
            "maxLength":4000,
            "type":"string",
            "description":"Value specified by the user to determine whether to override intermittent demand, which indicates whether the demand has an irregular frequency or not. Valid values are Yes and No.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "InventoryItemId":{
            "type":"integer",
            "description":"Value that uniquely identifies the item.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ItemCostUOM":{
            "maxLength":4000,
            "type":"string",
            "description":"Unit of measure associated with an item's cost.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ItemName":{
            "maxLength":300,
            "type":"string",
            "description":"Name of the item.",
            "nullable":true,
            "x-queryable":true
        },
        "ItemStructureType":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates the type of bill of material. A list of accepted values is defined in the lookup type ORA_MSC_BOM_ITEM_TYPE.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the user most recently updated the item.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User most recently updated the item.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LeadTimeLotSize":{
            "type":"number",
            "description":"Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LeadTimeOffsetPeriodBkts":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "LeadTimeOffsetWeekBkts":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "LifeCyclePhase":{
            "maxLength":120,
            "type":"string",
            "description":"Name of lifecycle phase of the item.",
            "nullable":true,
            "x-queryable":true
        },
        "LotControl":{
            "maxLength":4000,
            "type":"string",
            "description":"Meaning associated with the LotControlCode attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LotControlCode":{
            "type":"integer",
            "description":"Value that identifies whether the item is lot controlled. Valid values are 1 and 2. If 1, then lot control isn't established for the item. If 2, then lot control is used to track inventory balances by the lot number. A list of accepted values is defined in the lookup type ORA_MSC_LOT_CONTROL_CODE.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LotExpirationControl":{
            "maxLength":4000,
            "type":"string",
            "description":"Meaning associated with the LotsExpiration attribute. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LotsExpiration":{
            "type":"integer",
            "description":"Value that identifies how lot expiration dates are calculated. Valid values are 1 and 2. If 1, then lots don't expire. If 2, then lot expiration is based on the number of shelf life days for the item. A list of accepted values is defined in the lookup type ORA_MSC_LOT_EXPIRATION_CONTROL.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "MAD":{
            "type":"number",
            "description":"Value of the mean absolute deviation for the item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "MADOverride":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "MAPE":{
            "type":"number",
            "description":"Value of the mean absolute percentage error for the item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "MAPEOverride":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "MakeOrBuy":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether the item is manufactured or purchased. Valid values are Make or Buy. If Make, then the item is manufactured. If Buy, then the item is purchased. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_MAKE_BUY.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "MaximumOrderQuantity":{
            "type":"number",
            "description":"Maximum order quantity of the item.",
            "nullable":true,
            "x-queryable":true
        },
        "MinimumOrderQuantity":{
            "type":"number",
            "description":"Minimum order quantity of the item.",
            "nullable":true,
            "x-queryable":true
        },
        "NetSellingPrice":{
            "type":"number",
            "description":"Selling price of an item after applying an average discount to the item's list price.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "dependencies":[
                    "DiscountPercentage",
                    "SellingPrice"
                ]
            },
            "x-queryable":true
        },
        "NewPlanId":{
            "type":"integer",
            "description":"Most recent value that uniquely identifies the plan.",
            "nullable":false,
            "x-hints":{
                "PAYLOADHINT":"Show"
            },
            "x-queryable":true
        },
        "NotesIndicator":{
            "type":"integer",
            "description":"Indicates 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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "NumberOfDaysForDemandCutoff":{
            "type":"integer",
            "description":"The number of days after the demand date that the demand can be satisfied. This attribute doesn't have a default value.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ObsolescenceDate":{
            "type":"string",
            "description":"Date when the item is obsolete.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "OrderCost":{
            "type":"number",
            "description":"Fixed costs that are associated with placing a sales order for the item.",
            "nullable":true,
            "x-queryable":true
        },
        "OrderModifierToStartQuantity":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "OrderModifierToStartQuantityMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that determines whether the order modifier for the item should be applied to the start quantity of the supply for the item. Valid values are Yes or No.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Organization":{
            "maxLength":49,
            "type":"string",
            "description":"Abbreviation that identifies the organization associated with the item.",
            "nullable":true,
            "x-queryable":true
        },
        "OrganizationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the organization.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "PickComponents":{
            "type":"integer",
            "description":"Value that indicates whether the item can be picked from finished goods inventory. Valid values are: 1 or 2. If 1, then the item can be picked from finished goods inventory. If 2, then not.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PickComponentsMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether the item can be picked from the finished goods inventory. Valid values are: Yes or No. If Yes, then the item can be picked from the finished goods inventory. If No, then the item can't be picked from the finished goods inventory.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlannedSafetyStockType":{
            "maxLength":4000,
            "type":"string",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlannedSafetyStockTypeIndicator":{
            "type":"integer",
            "description":"Abbreviation that identifies the type of safety stock planning used to calculate safety stock for the item and organization combination. A list of accepted values is defined in the lookup type ORA_MSC_PLANNED_SS_TYPE.",
            "format":"int32",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":1
            },
            "x-queryable":true
        },
        "Planner":{
            "maxLength":10,
            "type":"string",
            "description":"Abbreviation that identifies the planner responsible for the item.",
            "nullable":true,
            "x-queryable":true
        },
        "PlannerDescription":{
            "maxLength":4000,
            "type":"string",
            "description":"Description of the planner responsible for the item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlanningMethod":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates the type of planning used for the item. A list of accepted values is defined in the lookup type ORA_MSC_PLANNING_CODE.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlanningMethodCode":{
            "type":"integer",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "PlanningTimeFenceCode":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanningTimeFenceDate":{
            "type":"string",
            "description":"Date before which orders aren't rescheduled.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlanningTimeFenceDays":{
            "type":"integer",
            "description":"Time horizon, in number of days, in which supply orders aren't scheduled to be due.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanningTimeFenceType":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that identifies the point in time inside which the planning process won't schedule a supply order to be due. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PostprocessingLeadTime":{
            "type":"number",
            "description":"Number of days required to make an item available in inventory once the supply is complete.",
            "nullable":true,
            "x-queryable":true
        },
        "PreprocessingLeadTime":{
            "type":"number",
            "description":"Number of days which must be added to purchasing or manufacturing lead time to place an order.",
            "nullable":true,
            "x-queryable":true
        },
        "ProcessingLeadTime":{
            "type":"number",
            "description":"Number of days required to procure or manufacture an item.",
            "nullable":true,
            "x-queryable":true
        },
        "ReleaseTimeFenceCode":{
            "type":"integer",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "ReleaseTimeFenceDate":{
            "type":"string",
            "description":"Date before which orders are automatically released as work orders or purchase requisitions.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ReleaseTimeFenceDays":{
            "type":"integer",
            "description":"Time horizon, in number of days, in which orders are automatically released as work orders or purchase requisitions.",
            "nullable":true,
            "x-queryable":true
        },
        "ReleaseTimeFenceType":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that identifies the point in time inside which planned orders with certain criteria are automatically released as work orders or purchase orders. A list of accepted values is defined in the lookup type ORA_MSC_TIME_FENCE_TYPES.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Rounding":{
            "type":"integer",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "RoundingMeaning":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates whether the planned order quantity is rounded to a whole number or not. Valid values are: Yes or No. If Yes, then the planned order quantity is rounded. If No, then the planned order quantity isn't rounded.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "RowModified":{
            "maxLength":255,
            "type":"string",
            "description":"Text that identifies whether the row is new or modified. Valid values are yes or null. If yes, then the row is new or modified. If null, then the row isn't new or modified.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SafetyStockCode":{
            "type":"integer",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "SafetyStockForecastPlan":{
            "maxLength":4000,
            "type":"string",
            "description":"Demand plan that contains the forecast and forecast error measures that the plan uses to calculate safety stock.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SafetyStockPlanningMethod":{
            "maxLength":4000,
            "type":"string",
            "description":"Meaning associated with the SafetyStockCode attribute.",
            "nullable":true,
            "x-queryable":true
        },
        "SafetyStockQuantity":{
            "type":"number",
            "description":"Desired level of safety stock of an item.",
            "nullable":true,
            "x-queryable":true
        },
        "SafetyStockQuantityOverride":{
            "type":"number",
            "description":"Numeric value provided by the user to override the standard safety stock quantity of an item.",
            "nullable":true,
            "x-hints":{
                "precision":20
            },
            "x-queryable":true
        },
        "Segment":{
            "type":"string",
            "description":"Value that uniquely identifies segment of items in inventory plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SegmentDescription":{
            "type":"string",
            "description":"Description of segment associated with exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SegmentId":{
            "type":"integer",
            "description":"Value that uniquely identifies segment of items in inventory plan.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "SellingPrice":{
            "type":"number",
            "description":"Selling price of the item.",
            "nullable":true,
            "x-queryable":true
        },
        "ServiceLevelPercent":{
            "type":"number",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "ShrinkageRate":{
            "type":"number",
            "description":"Average amount of material you expect to lose when manufacturing or storing the item.",
            "nullable":true,
            "x-queryable":true
        },
        "StandardCost":{
            "type":"number",
            "description":"Standard cost of an item.",
            "nullable":true,
            "x-queryable":true
        },
        "SupplyType":{
            "maxLength":4000,
            "type":"string",
            "description":"Value that indicates the supply type for components. A list of accepted values is defined in the lookup type ORA_MSC_WIP_SUP_TYPE.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "UOM":{
            "maxLength":4000,
            "type":"string",
            "description":"Planning unit of measure of the item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "UOMCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the unit of measure associated with the order quantity.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "UnitVolume":{
            "type":"number",
            "description":"Volume of one item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "UnitWeight":{
            "type":"number",
            "description":"Weight of one item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "UseUpDate":{
            "type":"string",
            "description":"Date when the current on-hand quantity for an item is exhausted based on projected gross requirements.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "VariableLeadTime":{
            "type":"number",
            "description":"Time to produce one unit of an assembly.",
            "nullable":true,
            "x-queryable":true
        },
        "VolumeUOMName":{
            "maxLength":4000,
            "type":"string",
            "description":"Unit of measure to use for the item volume.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "WeightUOMName":{
            "maxLength":4000,
            "type":"string",
            "description":"Unit of measure to use for the item weight.",
            "nullable":true,
            "readOnly":true,
            "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 : inventoryPlans-PlanAndSegmentExceptions-item-response

Type: object

Show Source

• AchievedServiceLevelPercentage: number
  Read Only: true

  Service level achieved at the segment level.
• ActionTaken: integer (int64)
  Title: Action Taken

  Contains 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: true

  Maximum Length: 80

  Currency used for segment budget as well as inventory budget .
• DataSecurityEditAllowed: string
  Read Only: true

  Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges.
• Exception: string
  Read Only: true

  Maximum Length: 120

  Value that uniquely identifies the plan and segment exception.
• ExceptionDetailId: integer
  Read Only: true

  Value that uniquely identifies the plan and segment exception detail.
• ExceptionId: integer
  Read Only: true

  Value that uniquely identifies the plan and segment exception.
• ExceptionStoreId: integer (int64)
  Read Only: true

  Value that uniquely identifies the stored plan and segment exception.
• ExceptionValue: number
  Read Only: true

  Value of plan and segment exception.
• FromDate: string (date)
  Read Only: true

  Starting date for the exception in the planning horizon.
• InventoryBudgetValue: number
  Read Only: true

  Description of segment associated with exception.
• InventoryValue: number
  Read Only: true

  Description of segment associated with exception.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date when the user last updated the exception.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who last updated the exception.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• Notes: integer (int64)
  Title: Notes

  Notes attached by the user while reviewing exceptions.
• PlanId: integer
  Read Only: true

  Value that uniquely identifies inventory plan.
• RowModified: string
  Read Only: true

  Text 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: true

  Value that uniquely identifies segment of items in inventory plan.
• SegmentDescription: string
  Read Only: true

  Description of segment associated with exception.
• SegmentGroupId: integer
  Read Only: true

  Value that uniquely identifies segment of items in inventory plan.
• SegmentId: integer
  Read Only: true

  Value that uniquely identifies segment of items in inventory plan.
• StoreKey: string
  Read Only: true

  Maximum Length: 240

  Name of store key in the plan and segment exception.
• TargetServiceLevelPercentage: number
  Read Only: true

  Target service level is the user-specified service level percentage that the planning process aims to achieve.
• ToDate: string (date)
  Read Only: true

  Ending date for the exception in the planning horizon.

{
    "type":"object",
    "properties":{
        "AchievedServiceLevelPercentage":{
            "type":"number",
            "description":"Service level achieved at the segment level.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ActionTaken":{
            "title":"Action Taken",
            "type":"integer",
            "description":"Contains 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.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "Currency":{
            "maxLength":80,
            "type":"string",
            "description":"Currency used for segment budget as well as inventory budget .",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "DataSecurityEditAllowed":{
            "type":"string",
            "description":"Contains one of the following: yes or null. If yes, then the user has data security edit privileges. If null, then the user doesn't have data security edit privileges.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Exception":{
            "maxLength":120,
            "type":"string",
            "description":"Value that uniquely identifies the plan and segment exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ExceptionDetailId":{
            "type":"integer",
            "description":"Value that uniquely identifies the plan and segment exception detail.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ExceptionId":{
            "type":"integer",
            "description":"Value that uniquely identifies the plan and segment exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ExceptionStoreId":{
            "type":"integer",
            "description":"Value that uniquely identifies the stored plan and segment exception.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ExceptionValue":{
            "type":"number",
            "description":"Value of plan and segment exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "FromDate":{
            "type":"string",
            "description":"Starting date for the exception in the planning horizon.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "InventoryBudgetValue":{
            "type":"number",
            "description":"Description of segment associated with exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "InventoryValue":{
            "type":"number",
            "description":"Description of segment associated with exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date when the user last updated the exception.",
            "format":"date-time",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who last updated the exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Notes":{
            "title":"Notes",
            "type":"integer",
            "description":"Notes attached by the user while reviewing exceptions.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies inventory plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "RowModified":{
            "type":"string",
            "description":"Text 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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "Segment":{
            "type":"string",
            "description":"Value that uniquely identifies segment of items in inventory plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SegmentDescription":{
            "type":"string",
            "description":"Description of segment associated with exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SegmentGroupId":{
            "type":"integer",
            "description":"Value that uniquely identifies segment of items in inventory plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "SegmentId":{
            "type":"integer",
            "description":"Value that uniquely identifies segment of items in inventory plan.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "StoreKey":{
            "maxLength":240,
            "type":"string",
            "description":"Name of store key in the plan and segment exception.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "TargetServiceLevelPercentage":{
            "type":"number",
            "description":"Target service level is the user-specified service level percentage that the planning process aims to achieve.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ToDate":{
            "type":"string",
            "description":"Ending date for the exception in the planning horizon.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "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 : inventoryPlans-Runs-item-response

Type: object

Show Source

• 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: 64

  Login 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: Links

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

{
    "type":"object",
    "properties":{
        "ActionParams":{
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "ArchivePlanFlag":{
            "type":"boolean",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "EndDate":{
            "type":"string",
            "description":"Date and time when the plan run is completed.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "ExecutionId":{
            "type":"integer",
            "description":"Value that uniquely identifies the process.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ExecutionUser":{
            "maxLength":64,
            "type":"string",
            "description":"Login used by the user when launching the process.",
            "nullable":false,
            "x-queryable":true
        },
        "ForceRunFlag":{
            "type":"boolean",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "JobId":{
            "type":"integer",
            "description":"Value that uniquely identifies the scheduled process.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "Message":{
            "type":"string",
            "description":"Text of any error messages that occurred when running the scheduled process.",
            "nullable":true,
            "x-queryable":true
        },
        "Mode":{
            "type":"string",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the inventory plan.",
            "nullable":false,
            "x-queryable":true
        },
        "RecalculateSafetyStockFlag":{
            "type":"boolean",
            "description":"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.",
            "nullable":true,
            "x-queryable":true
        },
        "SavePlanToDb":{
            "type":"string",
            "description":"This attribute isn't currently used. Save the plan to database for future use such as plan simulation.",
            "nullable":true,
            "x-queryable":true
        },
        "StartDate":{
            "type":"string",
            "description":"Date and time when the scheduled process is set to start.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "Status":{
            "type":"integer",
            "description":"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.",
            "format":"int32",
            "nullable":false,
            "x-hints":{
                "precision":5
            },
            "x-queryable":true
        },
        "SubmissionNotes":{
            "type":"string",
            "description":"Notes provided by the user when submitting the plan from the Run Plan page.",
            "nullable":true,
            "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"
    }
}

Back to Top