In Oracle iProcurement, Tax Is Not Recalculated Correctly When Requisition Quantity Is Changed (Doc ID 2372674.1)

Last updated on APRIL 11, 2022

Applies to:

Symptoms

In Oracle iProcurement, Release 12.1.3 and Release 12.2.4 through 12.2.7, the tax is not calculated correctly when a change request is issued on a line with very low quantity (example - 0.01) which is being increased to a higher quantity.

Due to this issue, users are not seeing the correct tax values when submitting a change request.

 

Steps To Reproduce

The issue can be reproduced at will with the following steps in a Vision Demo environment:

1. Responsibility : Tax Manager > Tax Configuration tab > Taxes subtab
- Query the Tax Name used on the requisition line
- In the search results, click the Update icon
- On the resulting Update Tax page, in the Main Information region, the fields "Rounding Rule" = Nearest and "Tax Precision" = 2.

2. In iProcurement, created and submitt non-catalog request.
Two lines
Line 1 has quantity 1000, unit price 1, Tax Classification = VA Tax
- Estimated Tax (USD) = 100.00
- Recoverable Tax (USD) = 0.00
- Non Recoverable Tax (USD) = 100.00
Line 2 has quantity 0.01, unit price 1, Tax Classification = VA Tax
- Estimated Tax (USD) = 0.00
- Recoverable Tax (USD) = 0.00
- Non Recoverable Tax (USD) = 0.00

3. Checked PO_DISTRIBUTIONS_ALL
- The distribution for Line 1 has NONRECOVERABLE_TAX = 100
- The distribution for Line 1 has NONRECOVERABLE_TAX = 0

4. In Purchasing, AutoCreate the req to Standard PO. Approve the PO.

5. In iProcurement, find the same requisition and select Change
On the Change Order: Select Lines page:
- Change the quantity on Line 1 from 1000 to 1200. The line price then updates correctly to 1200.
- Change the quantity on Line 2 from 0.01 to 900. The line price then updates correctly to 900.
Click Next and then Next again.
On the Change Order: Review and Submit page, the following changes are seen:
Line 1 changes:
- Quantity - from 1000 to 1200
- Amount (USD) - from 1,000.00 to 1,200.00
- Non-Recoverable Tax - from 100.00 to 120.00
Line 2 changes:
- Quantity - from 0.01 to 900
- Amount (USD) - from 0.01 to 900.00
- Non-Recoverable Tax - from null (blank) to 0.00

** The tax is not generated on the Line 2 change request. This is the problem. It is expected that the tax will be changed from 0.00 to 90.00.

6. Once the change request processing is completed and the PO has been updated, the tax amounts on the PO are correct.

Changes

Cause

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