Data Seeding Process Loads Negative Non-sellable Inventory, Without Populating Non Sellable Bucket (Doc ID 3002437.1)

Last updated on FEBRUARY 09, 2024

Applies to:

Goal

On : 23.1 version, Database

Data Seeding process loads negative Non-sellable inventory, without populating non sellable bucket

While Rollout out stores in SIOCS, and using the Initial Data Seeding process to get data from RMFCS, it was noticed that RMFCS had negative unavailable inventory in some items.
Thess items were loaded to SIOCS with the same negative Non Sellable bucket update to negative (STORE_ITEM_STOCK), however nothing was loaded in STORE_ITEM_STOCK_NONSELL for these items, causing invalid data that cannot be addressed with inventory adjustments.

SIOCS should not allow this to happen: Either it does not allow negative non sellable while seeding or it should seed the negative value also to STORE_ITEM_STOCK_NONSELL so it can then be actioned and corrected in SIOCS.
 

Solution

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