Oracle SOA Marketplace Image SQL Statement Failing (Doc ID 3041359.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

Goal

On : 12.2.1.4 version, Creating and Terminating Services

Oracle SOA Marketplace image SQL Statement Failing

We're hitting SQL Statement errors when spinning up the Marketplace image 'Oracle SOA Suite with B2B EDI Adapter (PAID)'.
(Reference: https://console.us-gov-ashburn-1.oraclegovcloud.com/marketplace/application/76630572/overview)

The SQL that's failing:

15908 Tue Jul 30 15:01:25.812 UTC 2024 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/soa/common/sql/soainfra/sql/oracle/createschema_soainfra_oracle_LARGE.sql'Line Number: 14260
15909 Tue Jul 30 15:01:25.812 UTC 2024 rcu:Statement Type: 'PL/SQL Statement - Object Type:PACKAGE Object Name:WIRE_MESSAGE_TYPES'
15910 Error encountered executing SQL statement FileName: '/u01/app/oracle/middleware/soa/common/sql/soainfra/sql/oracle/createschema_soainfra_oracle_LARGE.sql' LineNumber: '14260'
15911 SQL Statement: [CREATE OR REPLACE PACKAGE WIRE_MESSAGE_TYPES IS
15912 TYPE WDATA IS REF CURSOR RETURN B2B_WIRE_MESSAGE%ROWTYPE;
15913 END WIRE_MESSAGE_TYPES;
15914 ]
15915 Error creating PL/SQL Object WIRE_MESSAGE_TYPES : PACKAGE - PLS-00201: identifier 'B2B_WIRE_MESSAGE' must be declared
15916 Error creating PL/SQL Object WIRE_MESSAGE_TYPES : PACKAGE - PL/SQL: Compilation unit analysis terminated
15917
 

Solution

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