My Oracle Support Banner

EAR: When Payments Are Unposted, the Deposit Control Record Is Updated With Incorrect Data. (Doc ID 2653461.1)

Last updated on APRIL 06, 2022

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When payments are unposted, the Deposit Control record PS_DEPOSIT_CONTROL is updated with the incorrect data.
The issue can be reproduced at will with the following steps:
1). Create 3 Items, all in Business Unit US001 and Customer ID 1003 with amounts 100 USD(INV222), 150 USD(INV333), and 250 USD(INV444) respectively.
2). Create a new Regular Deposit with 2 Payments for amounts 30 and 70, each making reference to one of the Invoices created.
3). From the Payment Worksheet Application page, replace the Pay Amount value from 100 USD(Item amount) to 30 USD(payment amount) and save the changes:(This will automatic create a
     second row for the remainder amount of 70   USD).
4). For second payment, replace the Pay Amount value from 150 USD(Item amount) to 70 USD(payment amount), and save the changes:(This will automatic create a second row for the
     remainder amount of 80 USD)
5). Post payment worksheets .
6). Realizing that applying the first payment against Item INV222 was a mistake, proceed to perform a Partial Unpost, and apply the 30 USD amount to Item ID INV444 instead.Unselect  the default row  on  Item ID INV222, and manually add a new line   for Item ID INV444 and save the changes. post.
7). Confirm that Item ID INV222 got its payment of 30 USD unposted and Confirm that Item ID INV444 got partially paid for 30 USD.
8). Query PS_DEPOSIT_CONTROL. Record shows as posted only $30 and 1 count which is incorrect .




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

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