DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, January 16, 2017

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. 


No comments: