My Oracle Support Banner

MultiBuyPromoMod Fails in the SIM MPS_STAGED_MESSAGE Table Due to ORA-30926 Error (Doc ID 2450730.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Retail Store Inventory Management - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Store Inventory Management (SIM), the inbound Simple MultiBuy Promotion update message (i.e. MultiBuyPromoMod) fails to be processed and the following error is logged in the MPS_STAGED_MESSAGE table;


Steps to Recreate:

  1. Create a simple MultiBuy promotion in Oracle Retail Price Management (RPM) and make sure it is processed in SIM.
  2. Modify the promotion in RPM and check if corresponding message with type "MultiBuyPromoMod" is processed.
  3. Verify that message was staged into SIM staging table and fails to be processed with the above mentioned error.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.