Multiple rows are not updating in database using ICS adapter

Summary

Multiple rows are not updating in database using ICS adapter

Content

Issue while updating multiple rows in the database:

#1: I have selected 'Update' operation in the database adapter.

   Result: The interface is getting pass but failed to update the database, though the generated request payload is correct.

   Database adapter response:

   <WorkerResponse xmlns="http://xmlns.oracle.com/ics/scheduler/worker"&gt;
   <numBatchesProcessed />
   <numItemsSuccess />
   <numItemsError />
   <isTerminated>false</isTerminated>
   <isFailed>false</isFailed>
   <failedResult>
      <payload />
      <errorMessage />
      <errorEndpoint />
      <errorLocation />
   </failedResult>
   <outputDirs />
   <EssRequestExecutionContext />

 

#2: I have selected 'Insert or Update (Merge)' operation in database adapter

   Result: The interface is getting failed while invoking the database adapter, though the generated request payload is correct.