TheKnowledgeBlog

 In this section, will explain only the DB adapter section how to update sequencing table operation using OSB (only the operation design part) .In the DB adapter option, select "Update a sequencing table" 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                The sequence gets updated with the sequence picked Directly inserting sequence 12 with status Y in source table so that i gets skipped from polling and there wont be an entry in sequence table Sequence table with latest picked sequence from source table Target table with all records picked from source

   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:

In this section, we will see how to use the Logical delete of records from table for polling tables from database.  Note: For creating connection factory, datasource, deployment , DBAdapter for poll and merge please verify my blog page  OSB : DB Adapter-Poll - Delete Physical Records using Oracle Service Bus 12c Here will explain only the essence of logical delete and how the data is picked and processed.  VERSION USED:  SOA SUITE 12C - 12.2.1.3 DB  12C - 12.2.0.1.0 SOURCE SCHEMA - SCOTT  SOURCE TABLE - EMP_UI TARGET SCHEMA - TGT  TARGET TABLE - EMP_UI_TGT Create table and insert records . In this option we have to add one more column for performing the logical delete just by updating the values.  Here we are making logical delete on column "STATUS" by changing poll value from "N" to "Y"  Physically the data will be available in the database but the process wont pick it as the condition mentioned for the pr