Imported Payables Invoice With Multiple Item Lines and One Manual Tax Line Prorated Across All Item Lines Goes On Tax Amount Range Hold Upon Validation (Doc ID 1604516.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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

Goal

NOTE - the issue and explanation described below is for a specific example.  However, the information arising from this example can serve as a general source of truth for the application behaviour regarding tax tolerance and the reasons why the Tax Amount Range hold is applied.

Scenario
A number of Payables invoices imported through the Payables open invoice interface that are being put on Tax Amount Range hold despite the tax being calculated correctly and within the tax tolerance setup.

The Configuration Owner Tax Option settings are as below:
- Default Rounding Level: Header
- Regime Determination Set: Stcc
- Perform Additional Applicability for Imported Documents is ticked
- Enforce Tax from Reference Document is ticked
- Tolerance Range Amount is 0.02

Example Invoice:
- Sum of 14 ITEM lines is 932.43
- The one manual tax line amount is 139.86; this is stamped with a 15% tax rate

In interface tables, the tax amount is prorated across all 14 Item lines.

Now take the summed amount of the item lines 932.43 * 0.15 (the rate amount) = 139.8645.

The tax line amount is 139.86, so this lies well within the 0.02 tolerance.
Yet the imported invoice gets the Tax Amount Range hold applied when the invoice is validated.

Please explain / provide fix.
 

Solution

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