Schema Upgrade to 11.1.1.4 or 11.1.1.5 Results in Invalid ORABPEL Object (Doc ID 1330369.1)

Last updated on OCTOBER 21, 2013

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.

Goal

Oracle BPEL Process Manager Product Information Center > 11g Purge Scripts Master Note > Known Issues> Document 1330369.1

You've upgraded from an earlier version to SOA 11.1.1.4 or SOA 11.1.1.5.  After updating the schemas with the Patch Set Assistant, you verify that you have no invalid objects in the repository with the following query:

SQL> SELECT owner, object_name FROM all_objects WHERE status='INVALID';

The next step in the instructions call for running the soa_purge_scripts.  After the soa_purge_scripts complete, you see that the ORABPEL package body is now invalid.  Recompiling the ORABPEL package body results in the following errors:

Line: 24 Column: 15 Error: PL/SQL: ORA-00947: not enough values
Line: 24 Column: 3 Error: PL/SQL: SQL Statement ignored
Line: 38 Column: 15 Error: PL/SQL: ORA-00947: not enough values
Line: 38 Column: 3 Error: PL/SQL: SQL Statement ignored
Line: 189 Column: 15 Error: PL/SQL: ORA-00947: not enough values
Line: 189 Column: 3 Error: PL/SQL: SQL Statement ignored


Invalid objects also remain in the DB. This issue is also seen if <Patch 10297850> has been applied.

You want to know how can you get all the soainfra packages compiled cleanly.

 

Solution

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