My Oracle Support Banner

PriceEventExecutionRMSBatch Fails With "ORA-06533: Subscript Beyond Count Returned by Program Unit RMSSUB_PRICECHANGE_UPDATE.BUILD_PRICE_CHANGE" Error (Doc ID 1274001.1)

Last updated on OCTOBER 01, 2020

Applies to:

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


RPM priceeventexecutionrms batch aborts with an error when a price change is created for a parent item which has multiple color diffs.

Instructions to Re-create

1. Created new Parent Item with Color Diff and ranged the parent and child items to stores.
2. Approve the parent item with all Childs.
3. Run
4. Created a price change for the Parent Item against primary zone group and base zone.
5. Notice that multiple price change are created for each Diff.
6. Approved the price changes.
7. Ran
8. Notice that RPM_EVENT_ITEMLOC table was populated with the following:2 records for each price change:
one for the parent item and one for the child item.
9. Run
10. The batch program failed with the following 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.