Week_data Negative Values In OPN_STK_RETAIL (Doc ID 2933733.1)

Last updated on MARCH 15, 2023

Applies to:

Goal

PROD week_data negative values in OPN_STK_RETAIL.

During Data Migration for Release 1 go-live they got a script approved to see week_data.

As part of approval, they were told to exclude any SOH in item_loc_soh which was negative, so you would therefore not expect to see any values in week_data where OPN_STK_RETAIL or CLS_STK_RETAIL is negative, but this is not the case.

Is it correct that there are negative values in week_data for OPN_STK_RETAIL? Or was the logic given just for the initial seeding of the table?
 

Solution

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