Importing IAR File Not Creating Pl/sql Objects (Doc ID 2272826.1)

Last updated on AUGUST 16, 2017

Applies to:

Integration Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 invoke to call a DB procedure. When IAR file initially getting created and goes through the invoke wizard, it creates the necessary ics wrapper type and package in the database.

But if the iar gets exported, and imported into new environment, the ics warpper pl/sql type and packages are not getting created. To get the wrapper PL/SQL objects created, Customer needs to open the invoke in integration and go through the wizard to get the type and package created




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Integration to invoke DB PL/SQL
2. Export the iar file and delete all the pl/sql objects created before.
3. Reimport the iar file and note pl/sql objects not getting created.

 

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