After Upgrade From 11.5.10.2 To 12.2.8 HRI_TIME_C Object becomes Invalid
(Doc ID 2749627.1)
Last updated on MARCH 14, 2022
Applies to:
Oracle E-Business Intelligence - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.8 version, Patch Application Issues
After upgrade from 11.5.10.2 to 12.2.8 HRI_TIME_C object becomes invalid
ERROR :
PL/SQL: ORA-00904: "CUR_FISCAL_DAYS"."PERIOD_START_DATE": invalid identifier
ERROR While Compiling the Package Manually :
[Error] ORA-00942 (3802: 16): PL/SQL: ORA-00942: table or view does not exist
[Error] PLS-00364 (3822: 20): PLS-00364: loop index variable
'CUR_FISCAL_DAYS' use is invalid
[Error] ORA-00984 (3822: 36): PL/SQL: ORA-00984: column not allowed here
[Error] PLS-00364 (3835: 19): PLS-00364: loop index variable
'CUR_FISCAL_DAYS' use is invalid
[Error] PLS-00364 (3841: 34): PLS-00364: loop index variable
'CUR_FISCAL_DAYS' use is invalid
[Error] ORA-00904 (3841: 34): PL/SQL: ORA-00904:
"CUR_FISCAL_DAYS"."REPORT_DATE": invalid identifier
[Error] PLS-00364 (3854: 33): PLS-00364: loop index variable
'CUR_FISCAL_DAYS' use is invalid
[Error] ORA-00904 (3854: 33): PL/SQL: ORA-00904:
"CUR_FISCAL_DAYS"."PERIOD_START_DATE": invalid identifier
[Error] PLS-00364 (3857: 28): PLS-00364: loop index variable
'CUR_FISCAL_DAYS' use is invalid
[Error] PLS-00364 (3946: 33): PLS-00364: loop index variable
'CUR_FISCAL_DAYS' use is invalid
[Error] ORA-00904 (3946: 33): PL/SQL: ORA-00904:
"CUR_FISCAL_DAYS"."PERIOD_START_DATE": invalid identifier
STEPS :
The issue can be reproduced at will with the following steps:
1. after upgrade 11.5.10.2 to 12.2.8 HRI_TIME_C object is invalid
2. Even tried to compile Manually , The above error received.
Changes
Upgrade to 12.2.8
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 |
Changes |
Cause |
Solution |
References |