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 DECEMBER 14, 2016

Applies to:

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

Symptoms

Integrated SOA Gateway 12.2.1, Installation Issues

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

Oracle SOA Version - 12.2.1.0
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?

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Open JDeveloper 12.2.1.0
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.


Cause

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