My Oracle Support Banner

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

Last updated on JULY 13, 2023

Applies to:

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

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

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
Symptoms
Cause
Solution
References


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