My Oracle Support Banner

Service Bus Adaptor PL/SQL Stored Procedures (Wrapper) Created In jDeveloper (Not Though EBS Adapter Wizard) Do Not Show in the Project Directory and are Not Present in the APPS Schema (Doc ID 2123627.1)

Last updated on OCTOBER 02, 2020

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 and later
Information in this document applies to any platform.


Integrated SOA Gateway 12.2.1, Installation Issues

Wrapper Stored Procedures created though jDeveloper (instead of the EBS Adapter wizard) do not show in the project directory.

Oracle SOA Version -
Oracle EBS Version - 12.1.3

Created a service bus project in jDeveloper, and selected Oracle Apps (E-Business) Adapter to create a business service for a PLSQL stored procedure using APPS user. The wizard displayed that it created two wrapper procedure XX_BPEL_APPSREFERENCE.sql and XX_BPEL_APPSREFERENCE_drop.sql in the project directory.

However the package files do not display in the project directory. The above packages are also not available in the APPS schema.

How/Where can I get the generated SQL files?

The generated SQL Files by Oracle Apps (E-Business) should be visible in the OSB Project.

The issue can be reproduced at will with the following steps:
Open JDeveloper
Create Service Bus project
Create a ORacle APPS Adapter reference and invoke a PLSQL which has a PLSQL table type as input or output parameter
Complete the wizard. This appears in all cases where Ebusiness adapter wizard mentions that a wrapper SQL file is to be generated.


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

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