OIC - How to access Database sequence value in Oracle Integration

Usecase: Here, I will show you how to get the database sequence value in Oracle Integration.

Logic steps: 

• Create a sequence as required in the database.
• Create a database connection
• In the integration canvas , drag and drop the db adapter and configure as follow:
• Choose operation as "Run a SQL Statment"
• Provide sql query as select OIC_USER."Invoice_SEQ".nextval from dual and validate

Implementation steps with screenshots:

For create sequence , you can follow below blog:

https://soalicious.blogspot.com/2020/06/database-create-sequence.html