My Oracle Support Banner

SIM Outbound Stock Count FDETL Record Contains Non-Numeric Inventory Quantity (Doc ID 2804967.1)

Last updated on DECEMBER 02, 2021

Applies to:

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

Symptoms


SIM produces the stock count file outbound to RMS that contains an item with a non-numeric value that fails in RMS with the following error.

ERROR
----------
"The stock count specified records in the field FILE_RECORD_COUNT in the SVC_STKUPLD_FTAIL for stock count 2276 with process ID 213 does not match the number of records from the the table SVC_STKUPLD_FDETL"


Steps to Reproduce:

1. Create Product Group of Type Unit and amount.
2. Schedule the product group by creating a scheduler.
3. Extract Unit and amount stock count using base batch.
4. Count the item using 6 digit number and 7 digit number.
5. Authorize the count and check STK file QTY which will be different from authorized qty.

 

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.