Soa 12.2.1 – RCU Installation Error – Error Creating PL/SQL Object – MDS Internal Common

While Installing schemas using RCU utility for the latest SOA 12.2.1 release, following error occurred irrespective of Database version (10g XE, 11g XE, 11gR2, 12c).

RCU Error SOA 12.2.1
RCU Error SOA 12.2.1

After Ignoring the error, rest of RCU installation went through fine. On logging in with MDS schema user account (<prefix>_MDS), JDev shows following error

Error in DB
Error in DB

These kind of errors occur occasionally in 11g and re-compilation in JDev would resolve the issue. However, re-compiling  gave “Malformed or Corrupted wrapped unit” error.

Malformed or Corrupted wrapped unit
Malformed or Corrupted wrapped unit

I suspected <home>\oracle_common\common\sql\mds\sql\MDSINCB.plb  is corrupted and tried Online Unwrap service. The online service was able to unwrap the package without any issue.

Re-running the MDSINCB.plb script from SQL worksheet fixed the issue.

Error Resolved
Error Resolved

5 thoughts on “Soa 12.2.1 – RCU Installation Error – Error Creating PL/SQL Object – MDS Internal Common

  1. Hi Krish..

    Your post helped me in nailing down the issue “Error(1): PLS-00753: malformed or corrupted wrapped unit”.
    Thanks for your help..

  2. Hi, thanks for the post. But I haven’t been able to solve this problem. I did exactly as you showed in your post. I tried to compile the package MDS_INTERNAL_COMMON but still showing me an error and can’t compile it. I have the same version SOA 12.2.1.

    I hope your answer can help me with mi issue, Thank you

      1. when I trying to complile the PACKAGE BODY mds_internal_common
        showed me this Error:

        PLS-00753: Malformed or Corrupted wrapped unit

Leave a Reply

Your email address will not be published. Required fields are marked *