My Oracle Support Banner

Adjusting a Transaction Results in Wrong ACCTD_AMOUNT_DUE_REMAINING in AR_PAYMENT_SCHEDULES_ALL Table (Doc ID 2911304.1)

Last updated on DECEMBER 12, 2023

Applies to:

Oracle Receivables - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When adjusting a transaction results in wrong acctd_amount_due_remaining in ar_payment_schedule_all table.

Responsibility: Receivables Manager
Navigation
: Transactions > Transactions

Steps to reproduce (Example):

1 create an invoice (A) for USD 100.

2 create receipt for USD 100 and apply it to invoice (A). So Transaction A balance is 0

3 create a credit memo (B) for USD -100 and apply it to invoice (A).

4 create an adjustment for invoice (A) for USD -10. Transaction (A) balance is -110

5 Check the balances on ar_payment_schedules_all table and see the acctd_amount_due_remaining field is -110 which is incorrect

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?


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