My Oracle Support Banner

Sim_rms_stock_count_result_detail_hist Multiple The inventory_quantity by 1000 (Doc ID 3002399.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

Unit and Amount stock count and processed from SIOCS - MFCS, File from SIOCS has Authorized quantity as 10 but once the data in imported to MFCS, SIM_RMS_STOCK_COUNT_RESULT_DETAIL_HIST INVENTORY QUANTITY is updated as 10000.

Steps To Reproduce:


Prerequisite : Direct DB integration enabled.


1) Create and process a stock count in SIOCS.
2) Data processed to MFCS has Sim_rms_stock_count_result_detail_hist.inventory_quantity Multiple by 1000



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.