R12:AP: RCA: Automatic Withholding Tax (AWT) Calculation for Foreign Currency Payments is Using the Wrong Exchange Rate

(Doc ID 1254446.1)

Last updated on FEBRUARY 10, 2016

Applies to:

Oracle Payables - Version 12.0.0 to 12.0.6 [Release 12.0]
Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Find that the automatic withholding tax (AWT) accounting amount for foreign currency payments is different than the calculated amount that should be correct (payment rate * invoice withholding).

To identify transactions with this issue, run the following query:

select aip.check_id,ai.invoice_id, aip.invoice_payment_id,
aip.exchange_rate pymt_exc_rt,ai.exchange_rate inv_exc_rt,
aphd.invoice_dist_amount, aphd.invoice_dist_base_amount aphd_dist_base_amt,
aid.base_amount aid_dist_base_amt, aphd.paid_base_amount
from ap_payment_hist_dists aphd,
ap_invoice_distributions_all aid,
ap_invoices_all ai,
ap_invoice_payments_all aip
where aphd.invoice_payment_id = awt_invoice_payment_id
and aid.invoice_id= ai.invoice_id
and (-1 * aphd.paid_base_amount) != aid.base_amount
and pay_dist_lookup_code='AWT'
and aphd.invoice_payment_id =aip.invoice_payment_id
and aip.exchange_rate != ai.exchange_rate
and aip.posted_flag ='Y'
and aip.accounting_date between to_date('&enter_start_date', 'DD-Mon-YY')
and to_date('&enter_end_date', 'DD-Mon-YY');


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms