EABI 9.2:Deleting Billing Supporting Documentation Attachments Leaves Behind Data Record (Doc ID 2218630.1)

Last updated on JANUARY 03, 2017

Applies to:

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

Symptoms

On : 9.2 version on Bill Entry, when deleting Billing Supporting Documentation attachments,  the associated PS_BI_HDR_ATTACH or PS_BI_LINE_ATTACH records are removed, but leaves behind the related PS_PV_ATTACHMENTS record and leaves the actual (now orphaned) document on the FTP server.

REPLICATION STEPS
---------------------
The issue can be reproduced at will with the following steps:

  1. Logon as User VP1 on DEMO
  2. Navigate to : Billing > Maintain Bills > Standard Billing
  3. Enter Business Unit = US001
  4. Enter Invoice = RE-00006614
  5. Press Search
  6. On Header Documentation Page, Press Upload button
  7. Press Choose File Button
  8. Choose file to upload
  9. Press Upload Button
  10. Press Save Button
  11. Press Return to Search button
  12. Click on row with Invoice RE-00006614 in it
  13. Press on Delete icon on row with Attachment just added
  14. Press OK to Confirm Delete
  15. Press Save Button to save changes

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms