EAP: Files Not Attached & Orpahan Rows in PS_PV_ATT_DB_SRV When File Name is Too Long (Doc ID 2812499.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Symptoms

Attachment Count is 0 but the Attached loaded in database when it is attached to voucher.

Steps:
1) Open an existing voucher.
Navigation: Accounts Payable > Vouchers > Add/Update > Regular Entry
2) Click Attachments link.
3) Attach multiple files with one file having 65 characters long filename.
4) Error message appeared.

AddAttachment failed: File name too long (137, 55)
Call to AddAttachment method failed because the specified file name was too long.

5) Voucher Header attachment did not show any attachment even if the one with a shorter filename.
6) Click OK.
7)Attachments link still shows (0).
8) Executed following SQL: SELECT * FROM PS_PV_ATT_DB_SRV Order By lastupddttm desc;

• Attachment with shorter filename is saved in database.
  
  
  

Changes

Cause

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