My Oracle Support Banner

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 OCTOBER 29, 2018

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.