Connecting Oracle Integration to Oracle ATP - Issue with Sequencing
SummaryI am not able to understand from where the sequence is picked up.
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.