R12.2 Apps DBA. Powered by Blogger.

ORA-04063: package body "APPS.AD_ZD_PREP" has errors

No comments :
Remote execution is operational.
    [ERROR]     Failed to execute SQL statement :
   declare
    l_msg varchar2(4000);
  begin
    ad_zd_adop.adop_database_validations(l_msg);
    dbms_output.put_line(l_msg);
  end;
     [ERROR]     Error Message :
    [ERROR]     ORA-04063: package body "APPS.AD_ZD_PREP" has errors
    [ERROR]     ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"
    [ERROR]     ORA-06512: at "APPS.AD_ZD_ADOP", line 2443
   [ERROR]     ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute)
    [UNEXPECTED]Error occurred while performing database validations
Solution:
sqlplus "/ as sysdba" @adgrants.sql APPS/appspawd

No comments :

Post a Comment

Note: only a member of this blog may post a comment.