Retail Price Management (MOSC)

MOSC Banner

Promotions on a department level

edited Jan 6, 2017 5:34PM in Retail Price Management (MOSC) 3 commentsAnswered

Hello guys,

I have some doubts which I'd like you to help me resolve.
I'm using the RPM 13.2.0 and I'm creating a Simple Promotion on a department zone (class and subclass remains empty). At the end the promotion is approved.

Now I'm looking for a database table, where I could find the information that the particular promotion was created on a department level. According to the Oracle  Documentation such information should be saved within the RPM_PROMO_DTL_MERCH_NODE table in theMERCH_TYPE column. 0 stands for an item-level promotion and 3 stands for the department-level promotions.
But even if I'm creating the Simple promotion on a department level then the mentioned table is populated with Items and merch_type=0 (dept column remains empyt).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center