MDO/COE: How is the PROMO_TYPE field in ASH_PROMO_TBL (Promotions Standard Interface) used by the Optimization Engine?

(Doc ID 2233132.1)

Last updated on FEBRUARY 13, 2017

Applies to:

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


According to the Operations Guide, the PROMO_TYPE is "the promotion type, or interpretation, is either ceiling (candidate prices can be no higher than the promotion price), floor (candidate prices can be no less than the promotion), or unrestricted." What are the expected values for the PROMO_TYPE, and how does the optimization engine use the PROMO_TYPE data?


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