My Oracle Support Banner

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

Last updated on SEPTEMBER 23, 2024

Applies to:

SOA on Marketplace - Version 12.2.1.4 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


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