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

February 13, 2015 1 Comment

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

Filed under SOA Tagged with , , , , ,

Unknown's avatarAbout 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's avatar Anders Mørk says:
    February 13, 2015 at 20:30

    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 ….

    Reply

Leave a comment