Wrong TERV Amount At The Invoice Distribution Line (Doc ID 2087940.1)

Last updated on FEBRUARY 21, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Invoices TAX and WITHHOLDING

ACTUAL BEHAVIOR
---------------
the Tax Exchange Rate Variance is incorrect at the AP invoice distribution level.

PO#: 4003748
PO: Amount: 15,000.00 USD
PO Tax Amount: 1,500.00 USD
PO Rate: 1507.5

Invoice#: 04000-RI-14000001
Invoice Amount: 16,500.00 (Including Tax)
Invoice Rate: 1515

Exchange Rate Difference: 1515 - 1507.5 = 7.50

Based on the above
Exchange Rate Variance = 7.5 * 15,000 = 112,500 (Correct)
Tax Exchange Rate Variance = 7.5 * 1,500 = 11,250 which is not the case because the amount created in AP Invoice is 0.75

EXPECTED BEHAVIOR
-----------------------
correct trv

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. just observed

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot on prod further process an invoice

Cause

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