My Oracle Support Banner

InjectorPriceEventBatch Does Not Approve Promotions In RPM_PROMO_DTL Table (Doc ID 1268591.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Retail Price Management - Version 13.0.1 and later
Information in this document applies to any platform.
***Checked for Relevance on 25-May-2012***
***Checked for relevance on 10-Nov-2013***


In Retail Price Management (RPM), if a larger number of lines/new promotions are inserted in the staging table, RPM_STAGE_PROMO_COMP_SIMPLE, the InjectorPriceEventBatch does not approve them in RPM_PROMO_DTL table.

In the staging table the status changes to approved but not in the destination table.

Steps to Recreate:

1. Create a large number of promotions in staging table with status 'A' (>100)
2. Run  InjectorPriceEventBatch . rpmbatch status = 'N' and event_type = 'SP '
3. Verify that the status in RPM_STAGE_PROMO_COMP_SIMPLE  table changed to 'A'
4. Verify that status in RPM_PROMO_DTL table is still worksheet.




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.