My Oracle Support Banner

Missing Files Locator Reports Deleted Files After Files are Removed from File Folder (Doc ID 2699125.1)

Last updated on JANUARY 31, 2022

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


Actual Behavior
When removing an attachment file from a File Folder object, the file record remains in the FILES table while the actual physical file are removed from the file vault. This causes Missing Files Locator tool (MissingFilesLocator.jar) to report deleted files even after files have been removed from the file folder.

The issue can be reproduced at will with the following steps:
1. Login to Web Client
2. Create a new file folder object
3. Add attachment file to file folder : file.txt
4. Run SQL. 1 record is returned.

ID                  FILENAME
11122265     file.txt


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.