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 laterInformation 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 |