My Oracle Support Banner

Why Is FlexFact Data Not Loaing into W_PDS_FLEXFACT1_F? (Doc ID 3065663.1)

Last updated on JANUARY 02, 2025

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

We would like to load the sales data at day level. To achieve this, we are trying to leverage the FLEXFACT configuration by loading the day level data into one of the FLEX tables and move it to PDS. Detailed steps followed are given below:

Step 1: Create the W_RTL_FLEXFACT1_FS.dat and .ctx file with the day level sales data.
Step 2: Zip the file and place it in the object storage.
Step 3: Run the HIST_ZIP_FILE_LOAD_ADHOC process.
Step 4: Run the FLEXFACT_LOAD_ADHOC process.

After Step 4, the data got loaded in W_RTL_FLEXFACT1_FS, W_RTL_FLEXFACT1_F tables.

Step 5: Now, run the LOAD_PDS_FACT_PROCESS_ADHOC process to load the data to W_PDS_FLEXFACT1_F table.

After Step 5, even though the job runs successfully, the data is not being loaded to W_PDS_FLEXFACT1_F table.

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.