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
Last updated on FEBRUARY 02, 2018
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 - 22.214.171.124
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 126.96.36.199
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.
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