EAR 9.2:AR Deposit Unposting Payments Posted Total Count Error (Doc ID 2244844.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Symptoms

On 9.2 version, when unposting a payment group the record DEPOSIT_CONTROL, POSTED_COUNT field is set to -1. After the payment has been reapplied the record DEPOSIT_CONTROL, POSTED_COUNT field is set to 0. All payments are complete and posted but the deposit remains available on the Regular Deposit page.

Navigation: Accounts Receivable > Payments > Online Payments > Regular Deposit.

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

1. Select payment group to unpost.
2. Insert unpost reason and edit accounting date to fall within the current open period.
3. Set Posting Action to Batch Standard, Save and run ARUPDATE
4. One payment within the unpost group fails with a combo edit error as the project_id on the item within the payment is inactive, three payments have successfully unposted.
5. Deposit is available on the Regular Deposit page but references a Posted Total Count -1
6. Open inactive project and complete unposting of payment group item that had previously failed. Deposit still shows a count of -1
7. Reapply payments and run ARUPDATE. Payment group is successfully posted.
8. Deposit remains available on the Regular Deposit page and references Posted Total Count = 0.

Cause

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