My Oracle Support Banner

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

Last updated on SEPTEMBER 28, 2020

Applies to:

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

Symptoms

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.


Steps
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



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
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.