My Oracle Support Banner

AIF_DATA.RSE_AGGREGATE_ACTUALS_LOAD_ADHOC_JOB Not Loading All Data (Doc ID 3061340.1)

Last updated on NOVEMBER 29, 2024

Applies to:

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

Goal

Why does the following process show a discrepancy with the following two table's data, that should be equal?

W_RTL_FACT3_PROD3_LC3_T3_F
RSE_PR_LC_CAL_CDA

1.Run RPASCE Schedule & AIF Data Schedule whilst putting a hold on the AIF_APPS.ORASE_START_BATCH_JOB (Ensuring all relevant inter-schedule dependencies are enabled)
2.Let AIF DATA Complete
3.Let RPASCE get to the point of inter-schedule dependency waiting (RPASCE.MFP_POST_DATA_IMP_START_JOB is waiting on AIF_APPS.RSE_MFP_FCST_EXPORT_JOB)
4.Run RSE_AGGREGATE_ACTUALS_LOAD_ADHOC_JOB
5.Release hold on AIF_APPS.ORASE_START_BATCH_JOB Allowing AIF_APPS schedule to complete
 

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.