EAR9.2: When Partially Unposting Payment, the System is Populating DEPOSIT_CONTROL.POSTED_ TOTAL and COUNT With Wrong Values (Doc ID 2994553.1)

Last updated on JANUARY 30, 2024

Applies to:

Symptoms

When partially unposting payment the system is populating DEPOSIT_CONTROL.POSTED_ TOTAL and COUNT with wrong values.

Replication steps of the issue:

1. Create new customers 0000050047, 0000050048, 0000050049, 0000050050, 0000050055 under navigation Customers / Customer Information / Create Customer Information
2. For Cust ID 0000050047 create Item PUNPOST1 for 1919.19 USD amount and apply later on Cash for exact amount under navigation Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
3. For Cust ID 0000050048 create Item PUNPOST2 for 2020.2USD amount and apply later Cash for less than amount (2020 USD amount)
4. For Cust ID 0000050049 create Items PUNPOST3 for 2121.21 USD amount and apply later Cash For 101.00 more and Item PUNPOST4 for 2222.22 USD amount No Payment was staged
5. For Cust ID 0000050050 create Item PUNPOST5 for 2323.23 USD amount Applied to customer, but not the Item as expected therefore it was applied against the oldest open item for the customer, Item ABSI-20221231-886-A for 362072.67 USD amount
6. For Cust ID 0000050055 create Item JUSTINCASE for 70000 USD amount No Payment was staged
7. Create Deposit with 4 payments under navigation Accounts Receivable/ Regular Deposit / Online Deposit
For first payment reference the first customer/item 0000050047/ PUNPOST1
Second payment for Cust ID 0000050048 / item PUNPOST2 and cash for less amount 2020 (not 2020.2)
No reference for the next payment
For the last payment reference Item ABSI-20221231-886-A and Cust ID 0000050050
Apply first payment, payment Sequence 1
Apply the second payment, Payment Sequence 2
Apply the last payment, Payment Sequence 4
Keep the Sequence 3 of the payment in Payment Worksheet status Check Deposit Payment status
Posted Total Amount and Count as expected
8. Create new item for Cust ID 0000050047 for 5436.22 USD amount
9. Unpost the first Payment Sequence and Last Payment Sequence (sequence 4) of the Deposit and reapply them to different items under navigation Accounts Receivable / Receivables Update / Unpost Groups / Payment group
Check Deposit Payment Status
POSTED_TOTAL 6919.19 / should be 8939.19 POSTED_COUNT 2 / should be 3.

Attached OSS.pdf replication file.

Cause

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