R12: AP: Incorrect Amount Remaining is Displayed into Scheduled Payments (Doc ID 2961269.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On : 12.2.10 version, Invoice Issues

ACTUAL BEHAVIOR
---------------
The retainage amount is deducted twice from the payable amount.

Create Standard Invoice with below details:
Item: 300000
Retainage: -15000
Withholding: -30000
Tax: 34200

Net Amount to be paid: 289200

Scheduled Payments Tab:
Gross Amount : 319200
Amount reaming: 274200

Difference : 289200- 274200= 15000 exactly equal to Retainage

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Payables Responsibility> Invoices > Entry > create invoice

2. Match invoice with complex PO

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Incorrect Amount Remaining is displayed into Scheduled Payments tab after
validate Invoice matched with complex PO, if Prepayment or Invoice
Withholding tax is applied on the Invoice.
The retainage amount is deducted twice from the payable amount causing incorrect payment data in ap_payment_schedules_all

Cause

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