Payables and Cash Management - EBS (MOSC)

MOSC Banner

When setup payments method, I found multiplicated rows in usage rules per payment method

edited Oct 13, 2020 1:22PM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center