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.

Symptoms

On : 12.1.3 version, Invoice Issues & MassAdd

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

EXPECTED BEHAVIOR
-----------------------
System should Create a Correct Remaining Amount

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

Example: 

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).

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

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

Cause

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