SIM Fails With 'Error executing stored procedure' While Integrating RegPrcChg Message
(Doc ID 2172137.1)
Last updated on FEBRUARY 13, 2019
Applies to:Oracle Retail Store Inventory Management - Version 15.0 and later
Information in this document applies to any platform.
Oracle Retail Store Inventory Management (SIM) integration produces an error message when receiving a RegPrcChg message type from Retail Price Management (RPM). This message contains a multi-unit price change from RPM and fails with 'Error executing stored procedure'.
Steps to Recreate:
- Create a price change with multi units in RPM
- Let the message get into SIM through RIB
- Check table MPS_STAGED_MESSAGE
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