Total Pageviews

January 31, 2017

1/31/2017 01:23:00 AM

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
Navigation:
General Ledger : Setup : Currencies : Rates : daily
 
Related Posts Plugin for WordPress, Blogger...