R12:AP: RCA: Automatic Withholding Tax (AWT) Calculation for Foreign Currency Payments is Using the Wrong Exchange Rate
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,
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 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