SALWEEK_PRE_JOB Aborts with Error ORA-01405 "fetched Column Value Is NULL~Fetch C_get_avg"
(Doc ID 3046534.1)
Last updated on SEPTEMBER 10, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 and laterInformation in this document applies to any platform.
Symptoms
On: MFCS/RMS 24.0.201.4 version
In the first night batch run, the salweek_pre_job process aborts.
Error
-----------------------
"prepost~20240903061122~salweek_pre~salweek_restart_dept~-1405~ORA-01405: fetched column value is NULL~Fetch c_get_avg"
Steps to Recreate
-----------------------
1. In a new enviroment, change the vdate from "Jul/06/2024" and to date "Sep/02/2024", with the DTESYS process to today (02/09/2024);
2. In POM, execute the night batch cycle.
3. The cycle will abort in SALWEEK_PRE_JOB
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! |
In this Document
| Symptoms |
| Cause |
| Solution |