AP: Deleting Vouchers Attachments Not Removing Row from PV_ATTACHMENTS
Last updated on MARCH 08, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
Even with the fix for <Bug 16226959> applied, deleting voucher attachments does not delete data from the PS_PV_ATTACHMENTS table.
1. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry, and upload attachment to the Voucher page
2. Check rows inserted in the tables:
3. Delete the attachment
4. Check the tables:
AP_VCHR_ATT > deleted
PV_ATTACHMENTS > exist
PV_ATT_DB_SRV > deleted
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms