My Oracle Support Banner

Forecast Date And RPAS_TODAY Did Not Pick POM DATE In The Weekly Batch - Day/Date Configuration for AI Foundation (AIF) Weekly Forecast Generation. (Doc ID 3049513.1)

Last updated on OCTOBER 01, 2024

Applies to:

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

Symptoms

When the weekly batch triggered a forecast run in AI Foundation (AIF) through job RSE_FCST_BATCH_PROCESS_JOB, it did not take the RPAS_TODAY date.
RPAS_TODAY is supposed to be equal to the POM date that we use to schedule our batch to run, so the RPAS_TODAY date should be picked up from POM, and the forecast run in AIF should have its forecast Start date as the RPAS_TODAY date.

Is it possible to make the POM date and RPAS_TODAY dates incremental through the weekly batch, and have that feed the forecast Start date that is triggered in AIF?

The issue can be reproduced with the following steps:

1. RPAS_TODAY was removed (unset) from the Planning Data Schema (PDS) and a 'list set unset PDS environment variables' was performed. It does not show that we are overriding the Today date which means that the Today date should be picked up from POM.
However, that did not happen and LPPmTodayDt measure is still the date of the last batch run.

2. The forecast run in AIF was triggered through the batch. However the forecast start date did not take the RPAS_TODAY or the POM date, it took an earlier date as start date which is not understood.

Cause

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.