OBIA 10.3 PS4: C_PARAM_DW_VAL Table Having Duplicate Lines For Parameter Code, Resulting In Error 'ORA-01427: single-row subquery returns more than one row'
(Doc ID 3059949.1)
Last updated on DECEMBER 25, 2024
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.10.3 - PS4 - Patch Set 4 and laterInformation in this document applies to any platform.
Symptoms
After upgraded to OBIA 11.1.1.10.3 PS4, while executing newly generated Load Plan, getting failures on multiple variable refresh step with below error:
It is due to table C_PARAM_DW_VAL having duplicate lines for Parameter code for variables like INITIAL_EXTRACT_DATE.
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 |
| References |