Allocation Stock Order Messages From Warehouse To Store Inventory Management are failing With Error Executing Batch Statement (Doc ID 2300603.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

SOStatus message getting failed in SIM.MPS_STAGED_MESSAGE table.

Allocation Stock order messages from Warehouse to SIM are failing with SQLException. The SQL statement expects 14 parameters but only 11 being passed.

 

ERROR
-----------------------
oracle.retail.sim.common.core.SimServerException: Error processing message! [Inbound: true, MessageType: SOStatusCre, BusinessId: 1000180075]
at oracle.retail.sim.service.mps.BaseSimMessageServiceHandler.buildException(Unknown Source)
-----------------------------------------------
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:548)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused by: oracle.retail.sim.common.core.SimServerException: Error executing batch statement.
at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeBatch(Unknown Source)

... 60 more


The issue can be reproduced at will with the following steps:

  1. Create a Purchase Order (PO) in Retail Merchandising System (RMS).
  2. Create Standard Allocation (PreDist).
  3. Receive and Ship from Retail Warehouse Management System (RWMS).
  4. Check MPS_STAGED_MESSAGE table in SIM.


Changes

 

Cause

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