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.

Error:

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.

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.