Database Performance and Statistics Analyzer Issue- ORA-04063: package body "APPS.DB_PERFORMANCE_ANA
EBS Database Performance and Statistics Analyzer Concurrent request completed with errors and Log file shows below errors: -
ORACLE error 4063 in FDPSTP
Cause: FDPSTP failed due to ORA-04063: package body "APPS.DB_PERFORMANCE_ANALYZER_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.DB_PERFORMANCE_ANALYZER_PKG"
ORA-06512: at line 1
Earlier it was working fine but from 2nd Jan we noticed this issue. No changes done on application or patch applied on that day.
Please advise if anyone had experienced same issue and fix.
Thanks,
Kunal