My Oracle Support Banner

PROMO Promotions Integration Jobs Not Working As Expected: Order of operations on W_RTL_PROMO_D (Doc ID 3071276.1)

Last updated on FEBRUARY 10, 2025

Applies to:

Oracle Retail AI Foundation Cloud Service - Version NA and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version NA and later
Oracle Retail Demand Forecasting Cloud Service - Version NA and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service Plus - Version NA and later
Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service Plus - Version NA and later
Information in this document applies to any platform.

Goal

The flow that was enabled to integrate Promotions data into forecasting on a once-per-week schedule (it runs day-1 from the weekly batch), is not adding records to table W_RTL_PROMO_IT_LC_D from table W_RTL_PROMO_IT_LC_DS .

This is the flow for Promo integration into forecasting:

1. RI_IW_PRELOAD_CUSTOM_JOB

POM
2. SI_W_RTL_PROMO_EXT_DS_JOB
3. W_PROMO_D_RTL_TMP_JOB
4. W_RTL_PROMO_D_TL_JOB
5. W_RTL_PROMO_IT_LC_D_JOB
 

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.