Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Connecting Oracle Integration to Oracle ATP - Issue with Sequencing — Cloud Customer Connect
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

Connecting Oracle Integration to Oracle ATP - Issue with Sequencing

Accepted answer
17
Views
9
Comments
edited Jul 16, 2019 5:34AM in Integration 9 comments

Summary

I am not able to understand from where the sequence is picked up.

Content

In Oracle ATP DB : Created new sequence

CREATE SEQUENCE ZEB_TEMP START WITH 1000000 INCREMENT BY 1

so as per sequence when I call sequence number next val it give me next digit. 

When we mentioned the same sequence in Oracle ATP connection step in integration, it is generating some different sequence number. Only one good thing is, it is not random. But not sure from where sequence is getting generated. It works fine from ATP database, only issue is when i call it from Oracle Integration Cloud. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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