My Oracle Support Banner

Stock Count Export File Not Sent to Merchandising Cloud Server from SIOCS (Doc ID 2867921.1)

Last updated on MAY 12, 2022

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 19.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to generate the stock count export results, ThirdPartyStockCountImport_OpsJob fails with following error and the stock count results file is not exported to the Merchandising system.

ERROR
-----------------------

java.lang.Exception: Failed to export stock count child for stock count: 181901
at oracle.retail.sim.service.batch.stockcount.StockCountImportProcessorBatchlet.processStockCount(Unknown Source)
at oracle.retail.sim.service.batch.stockcount.StockCountImportProcessorBatchlet.doProcess(Unknown Source)
at oracle.retail.sim.service.batch.BaseBatchlet.process(Unknown Source)
at com.ibm.jbatch.container.artifact.proxy.BatchletProxy.process(BatchletProxy.java:33)
at com.ibm.jbatch.container.impl.BatchletStepControllerImpl.invokeBatchlet(BatchletStepControllerImpl.java:80) at

 

:

 

022-05-11 12:56:46,760 ERROR [[STUCK] ExecuteThread: '53' for queue: 'weblogic.kernel.Default (self-tuning)'][o.r.s.s.e.StockCountServiceBean_4bceio_Impl] Error occurred during service invocation. ERROR-413637 Time: 5/11/22 12:56 PM Type: SimServerException Message: Stock count outbound staging directory not found: /u01/retail/sim/batch/staging/out/to_thirdparty/stockcount

 

 

Expected Results:

When SIOCS in integrated with MFCS, the following file movement is expected.

STK_<storeId>_<scheduleId>_<yyyyMMddHHmmss>.dat.zip  to be sent to MFCS
STK_UIN_<storeId>_<scheduleId>_<yyyyMMddHHmmss>.dat.zip to be sent to thirdparty system to be sent to SFTP/Export/to_thirdparty.


Steps to Reproduce:


1. Create a Product Group and Product Group Schedule for a U&A Thirdparty Stock Count for stores 65 and 69
2. Run the ExtractUnitandAmountStockCount Batch job
3. Copy the STK_20220505171917_69.dat” and “STK_20220505191106_65.dat  in a zip format to the SFTP incoming/to_thirdparty folder.
4. Run the ThirdPartyStockCountImport batch job
5. Stock Count snaphot , counted and approved qty get updated
6. Batch job fails with error 'java.lang.Exception: Failed to export stock count child for stock count: 181901'
7. Run the Stock Count Export File SFTP Push Job
8. Batch job fails with 'java.lang.IllegalArgumentException: SFTP file location must exist for config key: file.out.stage.stock.count.path'


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


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