Apps Adapter Does Not Call Stored Procedures The Same Way As The Db Adapter (Doc ID 579368.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle SOA Platform - Version: 10.1.3.3.1 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.
***Checked for relevance on 26-Oct-2010***

Symptoms

While trying to use the Apps R12 adapter as a partner link from a BPEL process to call the native create order API in R12, you click finish and a Processing popup appears. After about 10-20 minutes, it errors with

Error while writing wsdl file.



-- Steps To Reproduce:
Example: create an Apps adapter connection and call a PL/SQL API. If the PL/SQL is using standard parameter types, it woks okay.

If the PL/SQL is using non-standard parameter types (extensions that are non-standard: boolean, record, etc), then the adapter is supposed to generate a wrapper SQL procedure to handle these types but does not.


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