My Oracle Support Banner

'Invalid Promotion' Message Shown on Order Screen (Doc ID 2339682.1)

Last updated on FEBRUARY 21, 2019

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.