My Oracle Support Banner

W_PDS_PO_ONORD_IT_LC_WK_A Imports all OO into Next Week in RPASCE Instead of into Expected Future Weeks (Doc ID 3039031.1)

Last updated on AUGUST 08, 2024

Applies to:

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

Goal

After upgrading to 24.1.201.1, all TY On Order for the balance of the year is showing in the next week. Previously, all future weeks showed OO.

Before the upgrade, W_PDS_PO_ONORD_IT_LC_WK_A showed many future EOW_DATEs. After the upgrade, the only EOW_DATEs are current week and next week.

Query to check dates: select distinct trunc(eow_date) from w_pds_po_onord_it_lc_wk_a where run_id = (select max (run_id) from W_PDS_PO_ONORD_IT_LC_WK_A) order by trunc(eow_date) desc 

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.