Stock Count Authorize Recovery Fails With Error Because Stock Count Date and Time is Not Updated for Missing Items

(Doc ID 2078411.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

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

Symptoms

In Store Inventory Management (SIM) application, find that the StockCountAuthorizeRecovery.sh batch fails with the following error:

INFO [main][core.SimBatchRunner] Executing batch: StockCountAuthorizeRecoveryJob
ERROR [main][job.StockCountAuthorizeRecoveryJob] Stock Count Location [ null - u&A1 ] for stock count [ XXX ] for store [ XXXX ] authorization failed: Error executing batch statement.


ERROR-1 User: [BATCH_CLIENT] Time: XX/XX/XX HH:MI PM Type: SimServerException Message: Error executing batch statement. Root Cause: Error executing batch statement.
oracle.retail.sim.common.core.SimServerException: Error executing batch statement.
  at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeBatch(Unknown Source)
  at oracle.retail.sim.server.dataaccess.BaseOracleDao.executeBatch(Unknown Source)
  at oracle.retail.sim.server.dataaccess.daoimpl.StockCountOracleDao.decrementOpenStockCountWithBatch(Unknown Source)
  at oracle.retail.sim.server.dataaccess.daoimpl.StockCountOracleDao.decrementOpenStockCount(Unknown Source)
  at oracle.retail.sim.service.stockcount.MarkStockCountChildAsApprovedCommand.doExecute(Unknown Source)
  at oracle.retail.sim.common.core.Command.execute(Unknown Source)
  at oracle.retail.sim.service.stockcount.StockCountChildServerServices.markStockCountChildApproved(Unknown Source)
  at oracle.retail.sim.service.ejb.StockCountChildBean.markStockCountChildApproved(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
...
...
...

Steps to recreate:

1. Create a Third Party Unit and Amount Stock count Stock count and schedule it for two days from today. (Example: 24th Oct 2015)
2. Make sure to perform a few sales transactions on the items belonging to the count for the date when the count is scheduled. (Ex: 24th Oct 2015)
3. Perform the count authorization a day after the count has been scheduled (Ex: 25th Oct 2015)
4. Stock count authorization is stuck in status '8' - "Approval in Progress"
5. Run the StockCountAuthorizeRecovery.sh batch
6. The batch fails with the above error

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