OSB : DB Adapter-Poll - Update sequencing file using Oracle Service Bus 12c
In this section, will explain only the DB adapter section how to update sequencing file operation using OSB (only the operation design part) .In the DB adapter option, select "Update a sequencing field" instead of "Delete the rows that were read" option in the below link and follow the steps mentiond here. For detailed step on creating proxy,pipeline,xquery,business service , please refer https://gnanaprakasamsolutionsblog.blogspot.com/2018/02/osb-db-adapter-poll-delete-physical.html Source table before running integration: Target table before running integration: Creating proxy in composite with DB adapter (Please see the link mentioned above for detailed explanation) Source table,Sequencing file, Target Table data after the integration run: