My Oracle Support Banner

W_RTL_PRICE_IT_LC_DY_F TO_DT_WID of 99999999999 (Doc ID 3037525.1)

Last updated on JULY 29, 2024

Applies to:

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

Goal

After loading catch up price data from 05/05/2024 to 07/06/2024. where the data staged fine and the HIST_PRICE_LOAD_ADHOC job completed fine, selecting distinct TO_DT_WID on W_RTL_PRICE_IT_LC_DY_F returns all the dates as expected except the date for 120240706000 which is coming out as 999999999999999. Why?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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