ASCP Screens show ORA-04063: Package Body "APPS.MSC_GET_NAME" Has Errors

(Doc ID 1474012.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms