Profile Options

This appendix covers the following topics:

Profile Options Introduction

There are different categories of profile options that relate to the Oracle Advanced Planning suite:

Oracle Inventory Optimization uses the MSR profile options. In addition, Oracle Inventory Optimization may use MRP, MSC, and MSO profile options. For more information on other profile options, see Oracle Advanced Planning Implementation and User's guide.

The following sections contain tables which describe each profile option.

Special Considerations

Automatic Calculations

When the Default Value of a profile option states that it is automatically calculated, this means that the Planning Engine determines the default value of that particular profile option. These profile options are included in this appendix for information purposes only. If you must change these profile option values, do so only after consulting Oracle Development and Oracle Support.

Flexfield Attributes

Flexfield attribute profile options store the name of the flexfield column that contains the value in the corresponding table. For example, if the Aggregate Resource Name is stored in column ATTRIBUTE1, the profile option MSC: Aggregate Resource Name Flexfield Attribute will contain the value 1.

This setup is performed only during an Oracle Applications installation. Do not modify it unless absolutely necessary.

Floating Point Precision

Certain quantities used by Oracle Advanced Supply Chain Planning have fractional values. For internal processing purposes these quantities must have integer values. To resolve this problem, floating-point precision profile options act as internal multipliers. When a fractional quantity is encountered it is multiplied by the appropriate floating-point precision profile option value, and the resulting integer is processed by the Planning Engine.

There are several floating-point precision profile options. This enables greater flexibility in controlling the precision with which to consider each quantity. It also provides more flexibility to avoid numerical overflow on 32-bit platforms where the each equivalent integer processed by the Planning Engine cannot exceed 2.1 x 109. The floating-point precision profile options are: Floating Point Precision for Usages in Routing, Floating Point Precision, Floating Point Precision for Transportation Capacities (Weight and Volume), Floating Point Precision for Planning Bucket Efficiency.

MSR Profile Options

The following table lists and defines the MSR profile options in Oracle Inventory Optimization:

Profile Option Name Valid Values Default Value Description
MSR: Budget Category Set Null or any category sets Null Use this profile option to specify the category set that includes all items that follow a budget.
Valid values are:
- Null: Budget constraints are not applied to any item in the plan.
- Any category set: Specify the category set that contains all items following a budget. Ensure that you have included all items that follow the budget within the category set.
MSR: Postponement Factor Integers >= 0 10 Specifies maximum depth in the bill of materials and sourcing tree to which uncertainty must be postponed.
MSR: Safety Stock Holding Strategy Destination Organization or Source Organization Source Organization Specifies where safety stock should be held when the cost is the same for an item in the destination organization and a source organization. Valid values are:
- Destination Organization: The safety stock is held at the destination organization.
- Source Organization: The safety stock is held at the source organization.
MSR: Probability Distribution Type Cumulative Probabilities/ Probabilities Probabilities Determines probability distribution type associated with forecast sets as input to Oracle Inventory Optimization. Valid Values are:

  • Probabilities: Demand uncertainty is stated in terms of a (non-cumulative) probability distribution.

  • Cumulative Probabilities: Demand uncertainty is stated in terms of a cumulative probability distribution.