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

Last updated on AUGUST 17, 2016

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***

Symptoms

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.

Cause

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