DB poller polling same lineitem records multiple(3) times (even though we have 3 different lineitem)

Hi Everyone,

I have production issue in SOA 12c (version 12.2.1.1.0) single Node SOA server.

DB adapter poller polling same record multiple times.

Input table has 3 records like line 1,2,3 but SOA db poller polling only line 1 three times (line 2 & 3 are not geeting polled even though they satisfy polling criteria).

Prod SOA env is Single node server.

DB adapter file properties are as below:

<endpoint-activation portType="Poll_XXStar_EC_OrderEditLine_ptt" operation="receive">

   <activation-spec className="oracle.tip.adapter.db.DBActivationSpec">

     <property name="DescriptorName" value="Poll_XXStar_EC_OrderEditLine.XxstarEcOrderEditLinesTbl"/>

     <property name="QueryName" value="Poll_XXStar_EC_OrderEditLineSelect"/>

     <property name="MappingsMetaDataURL" value="Poll_XXStar_EC_OrderEditLine-or-mappings.xml"/>