ORA-00904 while executing ADZDPSUM.sql in (GSCC) patch 16236081 on 11.5.9
We are trying to execute the scripts in the "STANDALONE READINESS REPORT AND GLOBAL STANDARDS COMPLIANCE CHECKER (GSCC)" patch 16236081 for a customer who is planning an upgrade to R12.2 with online patching. The customer is currently on 11.5.9.
After installing the patch and executing the script ADZDPSUM.sql using system username we get the following error and messages:
@ADZDPSUM.sql;
PL/SQL procedure successfully completed.
Table created.
Index created.
Table created.
Table truncated.
and r.namespace = 'SERVER'
*
ERROR at line 9:
ORA-00904: "R"."NAMESPACE": invalid identifier
Please advise on the reason for this error.