12.2.5 upgrade ORA-20001: ORA-20001: ORA-24344: success with compilation error on call dm_build_proc
We applied the 12.2.5 / mandatory patch on our 12.2.4.1 demantra instance. During the upgrade I ran into
ORA-20001: ORA-20001: ORA-24344: success with compilation error on call dm_build_procedures
ERROR at line 1:
ORA-20001: ORA-20001: ORA-24344: success with compilation error
ORA-06512: at "DP.DATA_MODEL", line 13
ORA-06512: at "DP.DATA_MODEL", line 11820
ORA-06512: at "DP.DATA_MODEL", line 12602
ORA-06512: at "DP.CALL_DM_BUILD_PROCEDURES", line 72
ORA-06512: at line 1
I checked metalink and found a note ORA-20001:ORA-24344: Success With Compilation Error when Upgrade Data Model (Doc ID 2014170.1).
The patch mentioned on this note was applied to the 12.2.4.1 instance. There is no available version for 12.2.5. Any ideas ? is this a setup issue of the data model ? Do i need to get the functional folks involved ? I do appreciate any suggestions.