E-FTP: Delete Orphan File Attachments Incorrectly Treat Files With Mixed-Case Or All-Upper-Case Extensions As Orphans (Doc ID 1181526.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

CleanAttachments (Delete Orphan File Attachments) does not take into consideration the letter case of the filenames stored in attachsysfilename fields when it checks for orphan files.

The functionality is accessed on page: PeopleTools > Utilities > Administration, PeopleTools Copy Attachments, with the "Delete Orphaned File Attachments" button.  Alternatively, the CleanAttachments() PeopleCode can be called directly, or with the delivered CLEANATT84 Application Engine program.

For example, in the reference table if there is a attachsysfilename (PS_1272_resume.DOC) with extension is in upper case. AddAttachment however in the upload process changes the extension to all lower case in the data table (i.e. PS_1272_resume.doc). When CleanAttachments executes, it considers PS_1272_resume.doc as an orphan file since no reference for this file found in the reference tables because of the different letter case in the extension. The file gets deleted from the database as it gets marked as orphan.

Basic Replication Steps:

1. Upload file called Doc_test.DOC
2. Can see filename stored exactly as is (Doc_test.DOC) in ATTACHSYSFILENAME of attachment reference table (with FILE_ATTACH_SBR subrecord)
3. However, filename in actual attachment storage table (with FILE_ATTDET_SBR subrecord) shows the same filename in ATTACHSYSFILENAME but the extension is all lower case (Doc_test.doc), note that the non-extension part of the file retains the letter case.
4. Run 'Delete Orphan File Attachments' function
5. Notice that the data in actual attachment storage table (with FILE_ATTDET_SBR subrecord, e.g. PSFILE_ATTDET) was deleted

Cause

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