My Oracle Support Banner

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 JULY 19, 2022

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle E-Business Tax - Version 12.0.0 and later
Information in this document applies to any platform.


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.

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.