Unable To Load The Spread Profile Table. (Doc ID 3071206.1)

Last updated on FEBRUARY 10, 2025

Applies to:

Goal

For Week to Day spread in AIF. To do that, we tried loading the RSE_FCST_SPREAD_PROFILE table. Here are the steps followed.

1. Created a text file named rse_fcst_spread_profile_stg.txt for one location and one item for 2 weeks with a spread profile.
2. Zipped the file in the name of ORASE_WEEKLY_ADHOC.zip and uploaded to object storage.
3. Ran the INPUT_FILES_ADHOC_PROCESS process to extract the file from object storage.
4. Ran the process RSE_MASTER_ADHOC_PROCESS with the parameter -M to load the spread profile data.
5. The table RSE_FCST_SPREAD_PROFILE_STG got loaded as expected.
6. Now, we are running the job RSE_FCST_SPREAD_PROFILE_LOAD_ADHOC_JOB to load the data to the table RSE_FCST_SPREAD_PROFILE.

The 6th step above is failing. When checking in the table RSE_FCST_SPREAD_PROFILE_BAD, the error description says 'The CAL_EXT_KEY AND DOW_KEY BOTH cannot have values.' There is no column named CAL_EXT_KEY in this table.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.