Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Updating IAR due to multiple ATP nodes affected by alphanumeric switch

in Integration 7 comments

Summary:

We are currently in the progress of an OIC Gen3 upgrade and essentially all of our integrations are affected by the instance ID switch from numeric to alphanumeric. Consequently, we have needed to change the PL/SQL procedure parameters in our ATP database to be switched from NUMBER to VARCHAR2.

We noticed that after compiling the latest updates to our PL/SQL procedures, we are required to go into each node of the integration that calls the procedure, select "Continue" → "Continue" → "Finish" for it to update the datatype of the input parameter. This process has been extremely tedious and are looking for ways to expedite these OIC changes. Without this tedious step, running the integration will result in the integration to fail with a fault message of

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!