While running autoconfig,we got error ORA-04063: package body “APPS.FND_GLOBAL” has errors has been detected in FND_GSM_UTIL.upload_context_file

Error:


Attempting upload of Context file and templates to database…ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -4063: ORA-04063: package body “APPS.FND_GLOBAL” has errors has been detected in FND_GSM_UTIL.upload_context_file. 
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -4063: ORA-04063: package body “APPS.FND_GLOBAL” has errors has been detected in FND_GSM_UTIL.upload_context_file. 

SQL> alter package apps.FND_GLOBAL compile body; 


Warning: Package Body altered with compilation errors. 


SQL> show errors 
Errors for PACKAGE BODY APPS.FND_GLOBAL: 


LINE/COL ERROR 
——– —————————————————————– 
2048/11 PL/SQL: SQL Statement ignored 
2050/18 PL/SQL: ORA-04063: view “APPS.FND_USER_RESP_GROUPS” has errors 
SQL> alter view APPS.FND_USER_RESP_GROUPS compile; 


Warning: View altered with compilation errors. 


SQL> 
SQL> 
SQL> show errors view APPS.FND_USER_RESP_GROUPS 
Errors for VIEW APPS.FND_USER_RESP_GROUPS: 


LINE/COL ERROR 
——– —————————————————————– 
0/0 ORA-04063: view “APPS.WF_USER_ROLE_ASSIGNMENTS_V” has errors 
SQL> 
SQL> 
SQL> alter view APPS.WF_USER_ROLE_ASSIGNMENTS_V compile; 


Warning: View altered with compilation errors. 


SQL> show errors view APPS.WF_USER_ROLE_ASSIGNMENTS_V; 
Errors for VIEW APPS.WF_USER_ROLE_ASSIGNMENTS_V: 


LINE/COL ERROR 
——– —————————————————————– 
0/0 ORA-00980: synonym translation is no longer valid 

Workaround:

1. Please run:

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp APPLSYS apps APPS apps THIN
test1.ro.oracle.com:1521:VIS TABLE
$FND_TOP/patch/115/xdf/wf_local_user_roles.xdf $FND_TOP/patch/115/xdf/xsl changedb=y

2. Validate ‘APPS.WF_USER_ROLES’

3. Please run:
adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp APPLSYS apps APPS apps THIN
test1.ro.oracle.com:1521:VIS TABLE
$FND_TOP/patch/115/xdf/wf_user_role_assignments.xdf $FND_TOP/patch/115/xdf/xsl changedb=y

4. Check if WF_USER_ROLE_ASSIGNMENTS_V is valid.

5. recompile WF_DIRECTORY

6. After that compile the package body also (FND_GLOBAL)

SQL> alter view apps.WF_USER_ROLE_ASSIGNMENTS_V compile; 


View altered. 


SQL> alter view APPS.FND_USER_RESP_GROUPS compile; 


View altered. 


SQL> select object_name,owner,object_type,status from dba_objects where object_name=’WF_USER_ROLE_ASSIGNMENTS_V’; 


OBJECT_NAME 
——————————————————————————– 
OWNER OBJECT_TYPE STATUS 
—————————— ——————- ——- 
WF_USER_ROLE_ASSIGNMENTS_V 
APPS VIEW VALID 




SQL> select object_name,owner,object_type,status from dba_objects where object_name=’WF_DIRECTORY’; 


OBJECT_NAME 
——————————————————————————– 
OWNER OBJECT_TYPE STATUS 
—————————— ——————- ——- 
WF_DIRECTORY 
APPS PACKAGE VALID 


WF_DIRECTORY 
APPS PACKAGE BODY INVALID 


—————————————————————————————————————————————- 
OBJECT_NAME 
——————————————————————————– 
OWNER OBJECT_TYPE STATUS 
—————————— ——————- ——- 
WF_DIRECTORY 
APPS PACKAGE VALID 


WF_DIRECTORY 
APPS PACKAGE BODY VALID

7.  alter package apps.FND_GLOBAL compile body; 


Package body altered. 

  • January 16, 2017 | 34 views
  • Comments