My Oracle Support Banner

One Row Is Inserted Into PV_ATTACHMENT Table Even if The Attachment Is Deleted From The Journal Attachment Page. (Doc ID 1670886.1)

Last updated on JUNE 03, 2021

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version MP9, Functionality

ACTUAL BEHAVIOR
---------------
When an attachment is added and then deleted from a journal entry, the attachment is not deleted from pv_attachments record

EXPECTED BEHAVIOR
-----------------------
Expect row to get delete from PV_ATTACHMENT.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open an existing or create new journal entry
2. Go to Attachments page and add an attachment
3. Delete the attachment
4. Click OK and then Save the journal
5. Attachments count on header page shows 0
6. Attachment still exists in PV_ATTACHMENTS



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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