ASCP Screens show ORA-04063: Package Body "APPS.MSC_GET_NAME" Has Errors (Doc ID 1474012.1)

Last updated on APRIL 01, 2024

Applies to:

Symptoms

Navigating in any of the ASCP screen, shows

ORA-04063: package body "APPS.MSC_GET_NAME" has errors
--------------------------------------------------------------
FRM-40502: ORACLE error: unable to read list of values.

Trying to recompile the package MSC_GET_NAME

Warning: Package Body altered with compilation errors.

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

LINE/COL ERROR
-------- -----------------------------------------------------------------
2147/3   PL/SQL: SQL Statement ignored
2148/8   PL/SQL: ORA-04063: view "APPS.MSD_DP_ASCP_SCENARIOS_V" has errors
2252/3   PL/SQL: SQL Statement ignored
2253/8   PL/SQL: ORA-04063: view "APPS.MSD_DP_ASCP_SCENARIOS_V" has errors
4649/1   PL/SQL: SQL Statement ignored
4656/7   PL/SQL: ORA-04063: view "APPS.MSD_DP_SCN_OUTPUT_LEVELS_V" has Errors

Check the apscheck file per note 246150.1 shows views:

MSD_DP_ASCP_SCENARIOS_V             VIEW                 INVALID    APPS
MSD_DP_SCN_OUTPUT_LEVELS_V        VIEW                 INVALID    APPS

trying to recompile the views gets following errors:

 
Warning: View altered with compilation errors.

SQL> show error VIEW  MSD_DP_SCN_OUTPUT_LEVELS_V
Errors for VIEW MSD_DP_SCN_OUTPUT_LEVELS_V:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      ORA-00980: synonym translation is no longer valid
SQL>
SQL> ALTER VIEW MSD_DP_ASCP_SCENARIOS_V COMPILE;

Warning: View altered with compilation errors.

SQL>  
SQL> show error VIEW  MSD_DP_ASCP_SCENARIOS_V
Errors for VIEW MSD_DP_ASCP_SCENARIOS_V:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      ORA-00980: synonym translation is no longer valid
SQL>

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.