SIOCS - Retail Sale Audit Import Batch Failed on SIMT File with No Transactional Data (Doc ID 2944171.1)

Last updated on APRIL 27, 2023

Applies to:

Goal

In SIOCS application, retail sales audit batch is failed for file having only FHEAD and FTAIL records. File is rejected because of not having transactional data but batch should not be marked failed.

Sales audit files are created in OReSA. It is creating operational issue because team need to check for each failed scenario.

Example SIMT file:

FHEAD|1|SIMT|30105|20221208|20221209084629
FTAIL|2|0


ERROR
-----------------------
Failed process Import data as file line number: 2, FHEAD not present at line number 2


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Generate a Retail sales audit sales file to import in SIOCS. Normally files is created as part of ReSA SIM export process. Another option to create file manually to load.
2. Import the file in SIOCS
3. File will be rejected but batch will also be marked as failed.
 

Solution

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