My Oracle Support Banner

R12: Incorrect Amount Remaining And Withholding Tax (AWT) Calculation When Split Payment Schedule (Doc ID 2225762.1)

Last updated on JANUARY 25, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Invoice Issues & MassAdd

Incorrect Amount Remaining and Withholding-Tax (AWT) calculation when Split Payment Schedules in Invoice Workbench after applied patch 21655067:R12.AP.B

System should Create a Correct Remaining Amount

The issue can be reproduced at will with the following steps:


1. Created an Invoice ‘3-12464657751’ with Invoice Amount 11,757.54.
2. Created Invoice Item Line with amount 11,757.54 and created Invoice AWT line with amount -587.87
3. Gross Amount is 11,757.54 in Schedule Payments tab
4. Updated Gross amount as 10,383.64 AND Clicked on ‘Split Schedule’ immediately
5. So, system has created another line with amount of 1373.90
6. For line with Gross amount 10,383.64, Amount Remaining is 9795.77(10383.64 - 587.87(AWT))
7. For line with Gross amount 1373.90, Amount remaining is 1305.21(It’s wrong)
8. Total amount remaining is 9795.77 + 1305.21 = 11100.98 (It’s Wrong).


The issue has the following business impact:

System calculates wrong Amount Remaining, which leads to wrong amount payment to the Suppliers 


To view full details, 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 a vibrant support community of peers and Oracle experts.