When setup payments method, I found multiplicated rows in usage rules per payment method
Hello,
After doing the setup of payments Methods , I found duplicated informations when review Usage Rules as it can be seeing in the file added.
When I use this sql requests, I found many rows per payment method.
select count(*), creation_date, created_by, payment_method_code
from iby.iby_applicable_pmt_mthds
where applicable_type_code = 'PAYEE'
and application_id = 200
and payment_flow = 'DISBURSEMENTS'
and payment_method_code = 'CHECK'
AND ( ( inactive_date IS NULL )
OR ( inactive_date > SYSDATE ) )
Group by creation_date, created_by, payment_method_code
;
Please, can somebody can explain this strage behavior ?
Many thanks
best regards