Oracle Payable Tax Tolerance Holds Issue
Payables Invoices Not Having Tax Tolerance Holds Applied Despite Being Set Up In The Configuration Owner Tax Options(COTO) For The Operating Unit(OU) XXXX
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set up tolerances at COTO for the OU
2. Create Invoice in AP
3. Validate Invoice
Transaction and Tax currencies are different and Exchange rate is missing for the same.
Debug log shows:
No rate found for tax conversion type: XXXXX p_conversion_date = XXXXXX
ZX_TDS_TAX_ROUNDING_PKG: round_tax(-)Not enough info to perform rounding Amount, Rounding rule, Mau, or Precison is NULL
Solution
Define the Exchange Rate
1. Query the Payables Options setup for Operating Unit XXXX
2. Under 'Currency' tab, find the Exchange Rate type
3. For this rate type, ensure a rate is present with below combination:
from_currency = XXXX
to_currency = XXXX
conversion_date = XXXXX
to_currency = XXXX
conversion_date = XXXXX
Navigation:
General Ledger : Setup : Currencies : Rates : daily
General Ledger : Setup : Currencies : Rates : daily
