EBS 12c Adapter calling PL/SQL by Jon Petter Hjulstad

clip_image002I have used the EBS Adapter on version 12 – and encountered some problems. The EBS Adapter is for example packaged into Mobile Suite with OSB and is perfect for example mobile-enabling you EBS. Here is some more info: Youtube  or datasheet. The problem I encountered was during call to a PL/SQL API in EBS Adapter. It looked like this:

What should be expected here is that it call a wrapper package that is generated in the APPS schema, but it calls the original package. Here is a link to the documentation

and the WSDL anticipates that the boolean is now an int, but it calls the wrong package. This can also be verified by logging SQL by using this tip. So to fix this you must update the file myAppsReference_apps.jca manually: Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

About Jürgen Kress
As a middleware expert Jürgen works at Oracle EMEA Alliances and Channels, responsible for Oracle’s EMEA Fusion Middleware partner business. He is the founder of the Oracle SOA & BPM and the WebLogic Partner Communities and the global Oracle Partner Advisory Councils. With more than 5000 members from all over the world the Middleware Partner Community is the most successful and active community at Oracle. Jürgen manages the community with monthly newsletters, webcasts and conferences. He hosts his annual Fusion Middleware Partner Community Forums and the Fusion Middleware Summer Camps, where more than 200 partners get product updates, roadmap insights and hands-on trainings. Supplemented by many web 2.0 tools like twitter, discussion forums, online communities, blogs and wikis. For the SOA & Cloud Symposium by Thomas Erl, Jürgen is a member of the steering board. He is also a frequent speaker at conferences like the SOA & BPM Integration Days, JAX, UKOUG, OUGN, or OOP.

One Response to EBS 12c Adapter calling PL/SQL by Jon Petter Hjulstad

  1. Anders Mørk says:

    Thanks for the great post …. it solved an issue I just ran into in SOA Suite 12c – I really wish Oracle would put a greater effort into quality assurance. 12c is a real pain with a lot of bugs. Things that are completely broken compared to 11g: MTOM in SOA Suite, Correlation in BPEL just to mention a few. Inconsistency – for instance you can add a policy to a Proxy service but when you try to deploy you’re met with ‘feature not supported’. Besides from that JDeveloper crashes frequently – making developer productivity very hard ….

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: