My Oracle Support Banner

Week_data Negative Values In OPN_STK_RETAIL (Doc ID 2933733.1)

Last updated on MARCH 15, 2023

Applies to:

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


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?


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

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