'Invalid Promotion' Message Shown on Order Screen

(Doc ID 2339682.1)

Last updated on JANUARY 02, 2018

Applies to:

Oracle Retail Merchandising System - Version 13.2.7 and later
Information in this document applies to any platform.


Message Invalid Promotion shown on Order screen. User wants to query an order which is associated to a promotion that has ended.When promo is ended, the record is deleted from the main table (RPM_PROMO) and moved to the history table (RPM_PROMO_HIST).Since promo record is no longer found in the main table, an error message pops up in the RMS form and can no longer query the order.

Steps To Recreate:
1) Create a Promotion.
2) Let the Promotion end.
3) Run the PROMOTION_ARCHIVE batch. Make sure the promotion goes into PROMO_HIST table.
4) Go to Order Find Screen.
5) Enter order number then it shows the message.
6) It displays 'Invalid Promo' error.




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