PriceEventExecutionRMSBatch Fails With "ORA-06533: Subscript Beyond Count Returned by Program Unit RMSSUB_PRICECHANGE_UPDATE.BUILD_PRICE_CHANGE" Error
Last updated on APRIL 06, 2018
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 newItemLocBatch.sh
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 priceEventExecutionBatch.sh.
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 priceEventExecutionRMSBatch.sh
10. The batch program failed with the following error:
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