Wednesday, April 29, 2015

Supplier Remittance Advice

For remittance advice Oracle fetches the email address from 'iby_external_payees_all' table.

When testing any changes to the remittance advice make sure to update the email before running the concurrent program.

SELECT   aps.segment1 "Vendor Number"
        ,aps.vendor_name "Vendor Name"
        ,iepa.remit_advice_email "Remittance Advice Email"
  FROM  ap_suppliers aps
       ,iby_external_payees_all iepa
 WHERE  iepa.payee_party_id = aps.party_id
   AND  aps.vendor_name= '<>';


You can also see the same at Payment Details -> Supplier / Supplier Site Level. Navigate to “Separate Remittance Advice Delivery” Tab.