ORA-04063: Package Body APPS.FND_PROFILE Has Errors

Error:-


Cause: afpodbinit failed due to ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped package body "APPS.ICX_SEC"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.ICX_SEC"
ORA-06512: at "APPS.FND_PROFILE", l.


The SQL statement being executed at the time of the error was: begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; and was executed from the file &ERRFILE.


Solution:-

SQL> alter package apps.ICX_SEC compile;

Package altered.

SQL> alter package apps.ICX_SEC compile body;

Package body altered.

SQL> show  error
No errors.
SQL> alter package apps.FND_PROFILE compile;

Package altered.

SQL> show error
No errors.
SQL> alter package apps.FND_PROFILE compile body;

Package body altered.

SQL> show error
No errors.
SQL> exit


Run Autoconfig at application.