InjectorPriceEventBatch Does Not Approve Promotions In RPM_PROMO_DTL Table
Last updated on AUGUST 18, 2017
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.
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