Hi,
I have a sequence created as below
DROP SEQUENCE XXC.LIC_REQUEST_ID_S;
CREATE SEQUENCE XXC.LIC_REQUEST_ID_S
START WITH 1
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;
GRANT ALL ON XXC.LIC_REQUEST_ID_S TO APPS WITH GRANT OPTION;
As I didn't specify increment option ideally it should increment by 1. But for some reasons when this is running from Oracle EBS I see request_id(the column which uses this sequence) is incrementing everytime by 20. This is happening only in one particular schema, I have atleast 200 requests in a dev environment where it worked as expected(incremented by1), recently I migrated this to QA Instance and I see the sequence incrementing by 20. When I am trying LIC_REQUEST_ID_S.nextval from QA backend I am seeing it incremented by 1, this is only happening when a request is made from Oracle Applications.
I never faced this issue, appreciate any suggestions if anyone encountered this.
Thanks!