Skip Headers
Oracle® Retail Price Management Oracle® Retail Price Management User Guide
Release 14.1
E54702-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

3 System Options

The system options workspace allows you to configure RPM to maximize the system. System options allow you to customize various parameters, defaults, and constants that are used throughout the system. Normally, these elements are set when RPM is installed by the system or database administrator. They tend to remain fixed unless a business practice is changed which necessitates a change in RPM. System options are the values used in your system that define the overall configuration of the system.

System Defaults

The System Defaults Edit workspace allows you to configure RPM to maximize the system. Select the values that should be should be initially displayed when a user enters the workspace. This helps the user save time as they do not have to select the appropriate value each time they complete a task. The values entered will appear in other areas of the application.

System Options Definitions

System options are organized on the following tabs:

  • General

  • Conflict Checking

  • Price Events

  • Location Moves

Table 3-1 System Options Fields and Descriptions

System Options Definition

General

Sales Calculation Method

The method used by the merchandise extract program to populate the Projected Sales column in the worksheet.

Update Item Attributes

When selected, the merchandise extract program updates certain item attributes during each extract that occurs during a worksheet review period.

Recognize WHs as Locations

When selected, indicates that warehouses can be assigned to regular and clearance price zones. They cannot be assigned to promotion price zones.

Open Zone Use

When selected, indicates a zone can be used across different types of pricing, regardless of zone type.

Exact Deal/Funded Promotion Dates

When selected, indicates that the dates of a deal associated with a vendor funded promotion must match the promotion component dates exactly. When selected, only deals with the same begin and end dates as the promotion component being created will appear in the deal.

Default Out of Stock Days

The number of days that should be added to an items clearance effective date in order to calculate the Out of Stock date. The default is applied to generate the out of stock date when the clearance is first created.

# of Days Reject Held

The number of days after the effective date of a rejected price change or clearance that it is purged from the system.

Ends in Digits for Zero Decimal Currencies

The number of digit fields set in system options that are available in the Ends In definition area. This field is used for currencies that do not contain a place after the decimal point. For currencies that contain places after the decimal point, the digit fields that are available.

External Prices Allowed

When selected, RPM accepts pricing events created in other systems.

Zone/Parent Ranging

When selected, RPM performs ranging checks for price changes, promotions, and clearances that are created at a higher level than transaction/location. If the indicator is set to yes, the system will not let you create a price change at the parent or zone level if none of the transaction item/location combinations are ranged. If the indicator is set to no, the system will let you create a price change at the parent or zone level even if none of the transaction item/location combinations are ranged.

Apply Promo Change Type 1st

Indicates which type of promotion change should be applied first. This system option is only factored into the promotion retail calculation when there are multiple promotion details under a single promotion that has different change types (amount off or percent off). The ranking algorithm used first applies a promotion as a whole to a given item/loc before ranking/applying the details under those promotions. The ranking is applied to the Promotion Header first, before looking at the Promotion Components. The promotions are applied to an item/location based on the following ranking order. These rules apply to all promotions, including those created using the Injector Price Event Batch.

Note: This system option will only be used when selling retail calculations are compounded. It will not be used when the system option: simple promotion overlap rule is set to non-compounding best deal.

Ranking order:

  1. Fixed price promotions

  2. Non secondary (vs. secondary flagged promotions)

  3. System Option: promo apply order 9either amount off or percent off)

  4. Secondary flagged promotions (promo header checkbox)

Example scenario:

  • Promo 1 - has one component; P1C1 created as Amount Off

  • Promo 2 - has two components; P2C1 created as Percent Off and P2C2 created as Fixed Price

Both promotions are NON secondary and the system option: Apply Promo Change Type 1st is set to Amount Off.

The system will first rank at the Promotion Level.

Since Promo 2 has the Fixed Price Component in it, it will be ranked higher than Promo 1. All components under Promo 2 will be applied first, and then component under Promo 1 will be applied.

When applying Promo 2, component P2C2 will be applied first, since it is a Fixed Price and then P2C1. After applying all components under Promo 2, then component under Promo 1 will be applied.

For this example, the order of application is:

  1. Promo 2, Component 2 (P2C2)

  2. Promo 2, Component 1 (P2C1)

  3. Promo 1, Component 1 (P1C1)

Pricing Strategy Default Effective Day

When selected, the user can choose which day of the week price changes will be effective.

Dynamic Area Differentials

When selected, allows the worksheet to dynamically update secondary locations based on changes to the primary location.

Minimize Worksheet Data
Filter Screen

When checked, the user is given an optional workflow which includes worksheet data filtering. When unchecked, the worksheet filter screen will not be accessible.

Maximum Worksheet Search Result

Indicates the maximum number of rows that are displayed based on the respective search criteria.

Allow Item List Explosion

Allows you to select whether the item list should be exploded to the item level or left at itemlist level. Recommendation to set value to N if you are not managing your items on a price event at a lower level.

Valid values are:

Y – Yes/Checked. Two options are provided in the Item Level field: Item List and Item (when Item Type = Item List).

N – No/Unchecked. Item Level could only be Item List (when Item Type = Item List). The default value is N/Unchecked.

System Generated Exclusion Tolerance %

This system option is used to determine the number of transaction items that will be automatically excluded during the price event approval process. This feature is available for price changes, clearance, and simple or threshold promotions that are created at a merchandise hierarchy level above transaction level. The percent value designated determines the number of items on a price event that can encounter conflicts and continue with the approval of the price event. If the number of items with conflicts exceeds the percent value based on the total item in the price event, the price event will be set to worksheet status and conflicts will be flagged.

Conflict Check

# Days Event Displayed Before Vdate

The number of days before the VDATE that a pricing event is displayed in the Conflict Review Check window.

# Days Event Displayed After Vdate

The number of days after the VDATE that a pricing event is displayed in the Conflict Review Check window.

Display Conflicts Only

When selected, only the record that caused the conflict will be displayed in the lower portion of the Conflict Review List window.

When unchecked and the days before/after are provided, the system will search for all records using the price event's effective date as the point to search forward and back. This will bring back all records within the window of time calculated.

Multiple records are displayed in the conflict review list window so that if one rule returns conflicts for multiple item/locs in a price event, all those conflicts are displayed. This is limited to a maximum of 100 records.

Unique UOM is used for all items

(DBA maintained) When selected, you have to specify which UOM should be used when fixed price events are created and the system will skip the UOM validation.

Unique UOM to be used for all items

(DBA maintained) Specifies which unique UOM needs to be used. This is a required field if ”Unique UOM is used for all items” option is checked.

Do not run Conflict Check for Submit

When checked, the system will skip conflict checking process when the user clicks the Submit button.

Do not run Conflict Check for Complex Promotion Approval

When checked, the system will skip conflict checking process when the user approves a Complex Promotion.

Price Events

Price Change/Promotion Overlaps

When selected, indicates an item/location can have a price change occur during the middle of an active promotion.

Cost Calculation Method

The way cost is determined for the zone. Choose Highest Location Cost or Average Location Cost.

Clearance/Promotion Overlaps

When selected, indicates an item/location can be on clearance and promotion at the same time.

Multiple Item/Loc Promotions

When selected, an item/location can exist on more than one promotion detail at any given time.

Maximum Number of Overlapping Promotion Component Details

The number of overlapping promotion components allowed for any single item/location. The default value is 4.

Simple Promotion Overlap Rule

This field determines handling of a simple promotion overlapping another simple promotion, based on the following selected options. The field will be disabled after initial setting.

- Compounding (default value)

The selling price is calculated by compounding each (two or more) simple promotions for the overlapping period.

- Non-compounding Best Deal

The selling price is calculated for each (two or more) promotions separately for the overlapping period.

Allow Complex Promotions

When selected, all promotion types are available.

Purge Reset Clearance Months

The number of months RPM will retain clearance price events that have reset before purging them.

Default Reset Date

When selected, indicates a reset date should be defaulted when a clearance is created. The reset date is defaulted to one day greater than the out of stock date.

Promotion End Date Required

When selected, a promotion end date is required for the promotion header.

Promotion # Days Rejects Held

The number of days, set in system options, after the end date (or start date for promotions with no end date) of a rejected promotion that it is purged from the system.

Price Change Processing Days

The number of days, set in system options, between the creation date of a price change and the first date it can become effective. It allows the retailer to insure that price changes are created with enough advance timing that stores and other process areas can react.

Promotion History Months

The number of months, set in system options, after a promotion is completed that is purged. This parameter is also used to purge cancelled promotions.

Filter Price Change/Clearance Results

When selected, the user is taken to a filter window that displays the search results for price changes and clearances.

Display Full Promotion Column Detail

When selected, all columns in the table are displayed. If this option is not selected, not all columns are displayed. If the user wants to review the details for the remaining columns, the user can do so by selecting rows and requesting the additional data.

Recommend value is Not Selected. You have the ability to select specific rows to view full column data when in the RPM screens instead of having all rows return all data every time the screen opens. Another option is to use the price inquiry screens to view details on retail impact.

Display Full Price Change/Clearance Column Detail

When selected, all columns in the table are displayed. If this option is not selected, not all columns are displayed. If the user wants to review the details for the remaining columns, the user can do so by selecting rows and requesting the additional data.

Recommend value is Not Selected. You have the ability to select specific rows to view full column data when you are in the RPM screens instead of having all rows return all data every time the screen opens. Another option is to use the price inquiry screens to view details on retail impact.

Event ID Required

When selected, a promotion event must be assigned to the promotion.

Display And/Or Condition

When selected, this option allows OR conditions to be used when a multi-buy promotion component contains multiple buy lists or reward lists. If this option is not selected, only AND conditions can be used.

Maximum Number of Buy Lists

This option specifies the maximum number of buy lists allowed for a multi-buy promotion component.

Recommend setting value not greater than 500.

Maximum Number of Reward Lists

This option specifies the maximum number of reward lists allowed for a multi-buy promotion component.

Recommend setting value not greater than 500.

Number of Past Markup Impact Events Displayed

The maximum number of past dates that have a cost or retail change to be displayed in the Markup Change Date column, used to review cost/retail change history. The value of this option can be an integer from 1 to 10 (default 1).

Maximum Number of Promotion Component Details per Promotion Component

Specifies the maximum number of promotion component details for a promotion component.

Recommend setting value not greater than 500.

Maximum Search Results

Price Changes

The maximum number of search rows returned for price changes. If the search limit is reached, a message is displayed informing users that they will not see all of their search results.

Clearances

The maximum number of search rows returned for clearances. If the search limit is reached, a message is displayed informing users that they will not see all of their search results.

Promotions

The maximum number of search rows returned for promotions. If the search limit is reached, a message is displayed informing users that they will not see all of their search results.

Price Inquiry

The maximum number of search rows returned for price inquiry. If the search limit is reached, a message is displayed informing users that they will not see all of their search results.

Clearance Resets Inquiry

The maximum number of search rows returned for clearance reset inquiry. If search limit is reached, a message is displayed informing users that they will not see all of their search results.

Location Moves

Location Move Lead Time

The number of days, set in system options, required before a location can be moved between zones in RPM.

Location Move Purge Days

The number of days RPM will retain location moves that have either successfully completed or are the same number of days past the scheduled effective date but have had no action taken on them.

Promotion Overlap

When selected, promotions are allowed to overlap a scheduled location move. If Promotion Overlap is selected, a Promotion Overlap Behavior option must be selected.

If Promotion Overlap is not selected (default), promotions cannot overlap a scheduled location move.

Promotion Overlap Behavior

When Promotion Overlap is selected, one of these behavior options must also be selected:

  • Do not start existing promotion and inherit new promotion

    The location does not start the promotion if the zone promotion overlaps the move date. The location inherits a promotion in the new zone that overlaps the move date. The inherited promotion starts on the same day that the zone-level promotion starts or it starts the day the move is scheduled if the zone-level promotion is already active.

  • End existing promotion and inherit new promotion

    The existing promotion ends at the location on the evening before the move date. The location inherits a promotion in the new zone that overlaps the move date, but the promotion starts on the location move date.

  • Extend existing promotion and do not inherit new promotion

    The location continues to run the promotion from the old zone. The location does not inherit a zone-level promotion for the new zone if the promotion overlaps the move date.

Inherit New Zones Regular Retail

When selected, the location inherits the retails of the new zone.

If not selected (default), the zone keeps the existing retail.

Pricing Strategy Review Period Overlap

When selected, pricing strategies with review periods are allowed to overlap a move date. The validation of a worksheet review period is bypassed, and a location move can be scheduled.

When unchecked (default), validation is not bypassed.


Edit System Options

Navigate:From the Task Pad, select System Options > System Options Edit. The System Options workspace opens.

Figure 3-1 System Options Workspace - General

System Options Workspace
  1. Update any enabled fields as necessary.

    See "System Defaults" for more information.

  2. Click Save to commit any changes and close the workspace.

View System Options

Navigate: From the Task Pad, select System Options > System Options View. The System Options View workspace opens.

Figure 3-2 System Options View Workspace

System Options View Workspace

See "System Defaults" for more information.

  • Click Close to exit the workspace.

System Defaults

The following table lists the system defaults.

Table 3-2 System Defaults Definitions

System Default Definition Options

Item Level

The level of an item in an item group.

  • Parent Item

  • Parent Item/Diff

  • Transaction Level Item

Pricing Strategy

The pricing strategy is the default strategy type displayed for the user when entering the Pricing Strategy workspace.

  • Area Differential

  • Clearance

  • Competitive

  • Margin

  • Maintain Margin

Diff Type

The category that a diff belongs.

Valid diff types from the Merchandising System.

Type

The type is the default price change type displayed when creating a price change.

  • Change by Amount

  • Change by Percent

  • Fixed Price

Currency

The primary currency used in RPM.

See LOV button on System Default screen for code and description.

Maintain Margin Strategy Method

Defines the default method used when creating a maintain margin pricing strategy.

  • Market Basket Margin

  • Current Margin

Ignore Constraints

Defines whether or not promotion constraints are taken into account when conflict checking is performed in the worksheet.

Select/Clear checkbox


Edit System Defaults

Navigate: From the Task Pad, select System Options > System Defaults Edit. The System Defaults Edit workspace opens.

Figure 3-3 System Defaults Edit Workspace

System Defaults Edit Workspace
  1. Update enabled fields as necessary. See "System Defaults" for more information.

  2. Click Save to commit any changes and close the workspace.

View System Defaults

Navigate: From the Task Pad, select System Options > System Defaults View. The System Defaults View workspace opens.

Figure 3-4 System Defaults View Workspace

System Defaults View Workspace

See "System Defaults" for more information.

Click Close to exit the workspace.

Aggregation Levels

The Aggregation Level Settings workspace allows you to define system parameters that vary for price strategies and price worksheet. When a department is created in the merchandising system, Oracle Retail Price Management assigns the default value for each parameter to the default or default level defined in the system. You may choose to define the aggregation level at a different parameter than the default. When a price strategy exists for a department, parameters are disabled and cannot be changed.

Maintain Aggregation Level Settings

Navigate: From the Task Pad, select Aggregation Level > Maintain Aggregation Levels. The Aggregation Level Settings workspace opens.

Figure 3-5 Aggregation Level Settings Workspace

Aggregation Level Settings Workspace
  1. Select the record you want to update.

  2. Click in the field that you want to change.

    • Lowest Definable Level: Select the lowest level of the merchandise hierarchy for which a price strategy can be defined.

    • Worksheet Level: Select the level of the merchandise hierarchy at which worksheets are generated.

    • Historical Sales: Select the sales period RPM should represent as historical on the worksheet.

    • Regular: Select the checkbox to indicate that regular sales should be included as part of historical sales in the price worksheet.

    • Clearance: Select the checkbox to indicate that clearance sales should be included as part of historical sales in on the price worksheet.

    • Promotion: Select the checkbox to indicate that promotional sales should be included as part of historical sales in on the price worksheet.

    • Include WH Inventory: Select the checkbox to indicate that warehouse inventory should be included in the calculations for sell through and price change impact in the price worksheet.

    • Include On Order In Sell Thru: Select the checkbox to indicate that inventory ordered is included in the sell through calculations on the price worksheet.

    • Price Change Amount Calc: Select the method of calculating the price change amount on the price worksheet.

      • New-Current: The current price is subtracted from the new price.

      • Current-New: The new price is subtracted from the current price.

    • Past Retail Change Highlight Days: Enter the number of days previous retail changes will cause the Last Price Change column of the pricing worksheet to be highlighted.

    • Past Cost Change Highlight Days: Enter the number of days previous cost changes will cause the Last Cost Change column on the pricing worksheet.

    • Pending Cost Change Window Days: Enter the number of days into the future the system should look for pending cost changes.

    • Pending Cost Change Highlight Days: Enter the number of days into the near future the system should look for pending cost changes. The Pending Cost Change column on the worksheet is highlighted if a cost change falls within the Pending Cost Change Highlight Days.


    Note:

    Pending Cost Change Highlight Days must be less than or equal to Pending Cost Change Window Days.

  3. Click Done to save any changes and close the workspace.