My Oracle Support Banner

Deleting An Attachment In Procurement Card Leaves Row In PS_PV_ATTACHMENTS (Doc ID 2112211.1)

Last updated on FEBRUARY 06, 2019

Applies to:

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


When adding an attachment in the procurement card module on the comments page the SCM_ATTACH_ID field is updated on PS_CC_COMMENTS. A row is also added to PS_PV_ATTACHMENTS. When you delete the attachment , PS_CC_COMMENTS table is updated for SCM_ATTACH_ID but the row persists in PS_PV_ATTACHMENTS.

Steps to reproduce the issue:
1. Add a new Pro card line attachment.
2. It will appear in PV_ATTACHMENT which is expected.
3. Now delete the attachment from the Pro card line.
4. Notice that the record is not deleted from the PV_ATTACHMENT


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.