Data Rows Not Deleted From PV_ATTACHMENTS Record Even After Deleting Direct Deposit Transactions.
(Doc ID 2896184.1)
Last updated on SEPTEMBER 22, 2022
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Attachment lines from PV_ATTACHMENTS record are not deleted after a Direct Deposit with an attachment is deleted.
The issue can be reproduced at will with the following steps:
1. Create a Deposit with 1 payment and an attachment ,save .Navigation: Accounts Receivable -->Payments-->Online Payments-->Regular Deposit.
2. Run sql select query on records PS_PAYMENT_WS_ATT and PS_PV_ATTACHMENTS,confirm data row for attachment exists .
3. Delete deposit by clicking on "Delete Deposit" on Regular Deposit page.
4. Run sql select query on records PS_PAYMENT_WS_ATT and PS_PV_ATTACHMENTS,notice data row for attachment is deleted from PS_PAYMENT_WS_ATT ,but NOT from PS_PV_ATTACHMENTS.
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