ORA-06512 ORA-06508 ORA-04063

Following Instructions in Note 1058763.1 And Applying Patch 10024524 Causes Invalid Object MSCUTILS.pls With Errors ORA-04063: Package Body Apps.Msc_util Has Errors ORA-06512 ORA-06508 [ID 1274919.1]

 

Applies to:

Oracle Advanced Supply Chain Planning - Version: 12.1.3 to 12.1.3 - Release: 12.1 to 12.1
Information in this document applies to any platform.

Goal

Users are upgrading Oracle Applications from 12.1.1 to 12.1.3, and database from 11gR1 (11.1.0.7) to 11gR2 (11.2.0.2).  They are following Note 1058763.1 - Interoperability Notes EBS R12 with Database 11gR2

As per the note they need to apply the below

If you are on E-Business Suite Release 12.1, apply

11g Release 2 interoperability patch for Release 12.1 (patch 9062910)
12.1 TXK Delta 3 patch (patch 8919489)
Patch 9868229
Patch 10024524

When patch 10024524 was applied as per the note an invalid object was created.

ERROR at line 1:
ORA-04063: package body "APPS.MSC_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.MSC_UTIL"
ORA-06512: at "APPS.MSC_CL_EXCHANGE_PARTTBL", line 2279
ORA-06512: at line 138

How was this resolved?

Solution

The users who created Note 1058763.1 were actually doing this install/upgrade when they ran into the problem described by bug 10024524. This patch they were given is a one off patch and it's readme states that no other user should apply this patch without first checking with development. So for this user, the patch should never have been applied without first checking with development. We have informed the author of this note to remove this patch number and replace it with applying the latest 12.1.3 patch from Note <746824.1>. If the patch is applied, and the invalid error does occur perform the following in a Test instance first and migrate the solution to other environments upon successful testing:

1. Apply VCP/ASCP 12.1.3.2 patch 10192383 to obtain key fixed file MSCUTILS.pls 120.24.12010000.10 or higher. Or apply the latest VCP/ASCP patch available as per Note 746824.1

2. Verify the package is compiled successfully

Workarounds:

Go to $MSC_TOP/patch/115/sql and run the following command:

strings -a MSCUTILS.pls |grep Header

If the version returned is MSCUTILS.pls 120.24.12010000.3 or MSCUTILS.pls 120.24.12010000.5 then follow instructions for Workaround A.

If the version returned is MSCUTILS.pls 120.24.12010000.6 then follow instructions for Workaround B.

Workaround A:

1.  Edit the package spec MSCUTILS.pls and add the following directly underneath the Header section:

TYPE TblNmTblTyp IS TABLE OF VARCHAR2(30);

2.  Recompile the invalids and verify the package spec compiles successfully

Workaround B:

1.  Login to Unix and then sqlplus as the APPS userid/pwd

2.  Run the following command:

SQL>@$MSC_TOP/patch/115/sql/MSCUTILS.pls

3.  Recompile the invalids and verify the package spec compiles successfully