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.

Sequence number what it is generating is 1200214, 1200215, 1200216 etc

nope.. latest created record should display first.. anyway thanks for quick response. i will try to see if i can write a trigger to populate the rowid into another custom column so that i can use that instead.