APC-MDO: Parameters Not Created at Expected Levels by Raw AP Stage

(Doc ID 2173988.1)

Last updated on AUGUST 19, 2016

Applies to:

Oracle Retail Clearance Optimization Engine - Version 14.0.3 and later
Oracle Retail Markdown Optimization - Version 14.0.3 and later
Oracle Retail Analytic Parameter Calculator - MDO - Version 14.0.3 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle. This article will be updated as official patch information becomes available.

If you select non-consecutive levels in Raw AP, then all the selected levels will not get parameters even though they are valid and have good data.

For example, the Location Hierarchy might be:

If only CHAIN and CLUSTER are selected (perhaps skipping COMPANY if it is the same as CHAIN logically), then only CLUSTER might appear in the ASDS_PARAMETER_FACT_TBL after Raw AP.

Seasonalities shows same behavior.

The following SQL shows which levels are created:


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms