Item MRP and MPS Planning Specifications

The following are the item MRP and MPS Planning specification attributes and their possible values. You set these attributes when you define or update items.

Item MRP and MPS Planning Specification Attributes

Attribute Name Description
Acceptable Early Days Enter the number of days before which the planning process won’t reschedule orders. The planning process only suggests rescheduling out if:
  • The new calculated order date is later than the original order due date plus the acceptable early days
  • The new calculated order doesn’t violate the order of current schedule receipts.

For example, if the original order due date is 10-JUN, and Acceptable Early Days is 3, the planning process not suggest rescheduling if the new due date is less than or equal to 13-JUN. When rescheduling doesn’t occur (because of Acceptable Early Days), a second order, due before the first, won’t be rescheduled past the first order

This lets you reduce plan nervousness and eliminate minor reschedule recommendations, especially when it’s cheaper to build and carry excess inventory for a short time than it’s to reschedule an order.

This applies to discrete items only.

Calculate ATP Indicate whether to calculate and print available to promise (ATP) on the Planning Detail Report, using the following formula:

ATP = planned production - committed demand

Where:

  • Planned production = planned orders, scheduled receipts (purchase orders, jobs, and repetitive schedules), suggested repetitive schedules, nettable quantity on hand.

  • Committed demand = sales orders, component demand (from planned orders, discrete jobs, suggested repetitive schedules, and lot expiration). Committed demand doesn’t include forecasted demand.

Note: You can use this attribute only when you integrate Product Hub with Oracle E-Business Suite. This attribute is invalid in an Oracle Fusion Cloud Applications only scenario, where Product Hub interacts with the Fusion Applications source system.
Create Supply Indicates if the application can suggest supply for this item. If you use an item as a substitute to meet demand for another item, then this attribute indicates whether you can create new supply for the item as part of meeting the demand for the original item.
Create Supply After Indicates the date after which you can use the item to create supply for Oracle Fusion Cloud Supply Chain Planning. You can't set a past date for this attribute. You can specify this date only if Create Supply is set to Yes.
Critical Component If selected, marks the item as a critical component for MPS and DRP planning. This lets you plan master scheduled items with respect to only critical component and their material resource constraints. Hidden by default.
Demand Time Days Calculates the demand time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you enter here.
Demand Time Fence Select an option to determine a point in time inside which the planning process ignores the forecast demand and considers only the sales order demand when calculating gross requirements. This reduces the risk of carrying excess inventory.

Calculate the demand time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you select here.

The demand time fence values are:
  • Cumulative manufacturing lead time: The cumulative manufacturing lead time for the item.
  • Cumulative total lead time: The total manufacturing lead time for the item.
  • Total lead time: The total lead time for the item.
  • User-defined: The value you enter for Demand Time Fence Days.
Distribution Planned Indicate the kind of planning to be used for the item. It’s the application of replenishment inventory calculations to assist in planning of key resources contained in a distribution system, such as sourcing and transport. Hidden by default.
Exclude from Budget Indicate whether the item is to be excluded from the budget. Hidden by default.
Forecast Control Select an option to determine the types of demand you place for the item. This guides the key processes of two-level master scheduling: forecast explosion, forecast consumption, planning, production relief, and shipment relief. This is appropriate only for items that are models, option classes, options, or mandatory components of models and option classes.
  • Consume forecast: You forecast demand directly, rather than by exploding the forecast demand. You can use this value only with Oracle E-Business Suite Supply Chain Planning Applications.
  • Consume and derive forecast: You forecast demand directly, explode the forecast demand, or use a combination of both methods. You can use this value only with Oracle E-Business Suite Supply Chain Planning Applications.
  • Consume then explode: You first forecast demand directly, then by exploding the forecast demand.
  • Explode then consume: You first explode the forecast demand, then directly forecast demand.
  • None: You place sales order demand but don’t forecast demand.
Maximum Inventory Days of Supply Enter the maximum amount necessary of any materials and supplies in the application that are needed to achieve the desired business metric like throughput rate, cost, due date performance, inventory, days of supply, and so on. Hidden by default.
Maximum Inventory Window Enter the maximum amount necessary (in terms of quantity) of any materials and supplies in the application that are needed to achieve the desired business metric like throughput rate, cost, due date performance, inventory, days of supply, and so on. Hidden by default.
Pegging Indicate the planning process uses to decide when to calculate and print end assemblies for the item. Hidden by default.
  • Soft Pegging: This option allocates supply to demand based on the Reservation Level option set in the MRP Plan options.
  • End Assembly Pegging: This option traces the end assembly the item is pegged to at the top of the bill of material. Even if you don’t select end assembly pegging, you can still calculate and view end assemblies on-line.
  • End Assembly / Soft Pegging: Choose this option for both soft pegging and end assembly pegging.
  • Hard Pegging: This option allocates supply to demand based on the Reservation Level option set in the MRP Plan options. This pegs supply to demand and demand to supply by project at all levels of a bill of material. This lets you allocate supply to demand and generate planned orders based on the plan-level options.
  • End Assembly / Hard Pegging: Choose this option for both hard pegging and end assembly pegging.
  • None: This option disables project material allocation, end assembly pegging, and full pegging.
Planned Inventory Point Indicate if the item is an Inventory Point item. This means that material can be stored at the item level without losing materials or quality characteristics. Inventory Points generally point to major stocking phases in the manufacturing cycle. Hidden by default.
Planning Method Select the option that decides when to plan the item:
  • Not planned: The item doesn’t require long-term planning of material requirements. Choose this option for high volume and or low cost items that don’t warrant the administrative overhead of MRP; typically dependent demand items. You can’t use this option unless the Pick Components attribute is checked.
  • MRP planning: Choose this option for non-critical items that don’t require manual planning control, typically dependent demand items.
  • MPS planning: You master schedule the item and require manual planning control. Choose this option for items with independent demand, items that are critical to your business, or items that control critical resources.
  • MRP/DRP Planned: Choose this option when you want both MRP and DRP planning for the item.
  • MPS/DRP Planned: Choose this option when you want both MPS and DRP planning for the item.
  • DRP Planned: Choose this option when you have multiple organizations for which you’re exercising Distribution Requirements Planning for the item.
Planning Time Days Calculates the planning time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you enter here.
Planning Time Fence Choose one of the following options to determine a point in time inside which certain restrictions on planning recommendations apply. For discrete items, the planning process can’t suggest new planned orders or rescheduling existing orders to an earlier date. For repetitive items, the planning process can only suggest new daily rates that fall inside the acceptable rate increase and decrease boundaries.

A time fence increases manual control of the plan, minimizing short term disruption to shop floor and purchasing schedules.

Calculate the planning time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you select here.

The planning time fence values are:
  • Cumulative manufacturing lead time: The cumulative manufacturing lead time for the item.
  • Cumulative total lead time: The total manufacturing lead time for the item.
  • Total lead time: The total lead time for the item.
  • User-defined: The value you enter for Demand Time Fence Days.
Preposition Point The preposition point represents the push type relationship with a trading partner. When planning arrives at a preposition point for an item, it pushes all the existing supply downstream until this point.

In the case of multi-souring repair, you should not set the preposition point for the item-repair supplier. If you set select this check box for a multi-sourced item, then the application pushes the entire inventory to the first trading partner it encounters in the planning process. Hidden by default.

Release Time Days Calculate the demand time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you enter here.
Release Time Fence Choose an option to determine a point in time inside which planned orders for discretely planned items are automatically released as WIP jobs or purchase requisitions. The planned orders must meet the following auto-release criteria:
  • The new order date lies within the auto-release time fence for any order type (make or buy).

    Order Date = Start Date - Preprocessing Lead Time. For example, if the Order Date is April 5 and the Start Date is April 7, if the preprocessing lead time is 2 days. When the order date falls inside the release time fence, the planned order is released.

  • The lead time isn’t compressed
  • The orders are for standard items (won’t release models, option classes, and planning items)
  • The orders aren’t for Kanban items
  • The orders are for DRP planned items in a DRP plan, MPS planned items in an MPS plan, or MRP planned items in an MRP plan.
  • The release time fence option is defined as anything other than Do not auto-release, Do not release (Kanban), or Null
  • DRP, MPS, and MRP plans must be run with the Memory-based Planning Engine

Auto-release of repetitive schedules isn’t applicable for repetitively planned items. No material availability check is performed before WIP jobs are released.

Calculate the release time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you select here.
  • Cumulative manufacturing lead time: The cumulative manufacturing lead time for the item.
  • Cumulative total lead time: The total manufacturing lead time for the item.
  • Total lead time: The total lead time for the item.
  • User-defined: The value you enter for Demand Time Fence Days.
  • Do not auto-release: The item can’t be auto-released.
  • Do not release (Kanban): For Kanban items, prevent release of planned orders manually or automatically.
Repair Lead Time Time, in days, to repair the part at the supplier site. The definition is in context with the final usable part of product and not based on the defective part. For example, if you can repair an item A from a defective item B, planning assumes the repair lead-time from item A when it calculates the repair of defective item B. A repair organization requires the time equal to the repair lead-time to convert a defective part to a usable part. You define the repair lead time in the repair organization. Valid values are decimal numbers greater than or equal to 1.
Repair Program Indicates the relationship with the supplier for the repair of an item. Hidden by default. The available choices are:
  • Advanced Exchange on Defective Receipt
  • Advanced Exchange on PO Issue
  • Repair Return
Repair Yield Indicates the yield percentage when you upgrade or repair a defective part. For example, a repair yield of 23% is entered as 0.23. The repair yield is always in context with the final usable part or product and not based on the defective part. The repair yield represents the yield of the repair process. You define the repair yield in the repair organization. Valid values are decimal numbers greater than zero and less than 1.
Round Order Quantities Indicate whether the planning process uses decimal or whole number values when calculating planned order quantities or repetitive rates. When this option is turned on, decimal values round up (never down) to the next whole number. The planning process carries any excess quantities and rates forward into subsequent periods as additional supply.
Shrinkage Rate Enter a factor that represents the average amount of material you expect to lose during manufacturing or in storage. The planning process inflates demand to compensate for this expected loss. For example, if on average 20% of all units fail final inspection, enter 0.2; the planning process inflates net requirements by a factor of 1.25 (1 / 1 - shrinkage rate).
Substitution Window Days If the substitution window type is User-defined, then you specify the number of days a substitute is considered for an item. Hidden by default.
Substitution Window Code Hidden by default. Enter a value that calculates the time a substitute can be considered for an item.
  • Cumulative manufacturing lead time: The cumulative manufacturing lead time for the item.
  • Cumulative total lead time: The total manufacturing lead time for the item.
  • Total lead time: The total lead time for the item.
  • User-defined: The value you enter for Demand Time Fence Days.
Target Inventory Days of Supply Enter the target inventory (in terms of days of supply) to be achieved by the planning engine. Hidden by default.
Target Inventory Window Enter the target inventory (in terms of quantity) to be achieved by the planning engine. Hidden by default.