Assign the "Purge Obsolete Generic File Manager Data" Concurrent Program to the Request Group "System Administrator Reports". 1. Access Oracle Applications as the Sysadmin user. 2. Select the System Administrator responsibility. 3. Navigate to the following menus: Security / Responsibility / Request 4. Place the cursor in the "Group" field of the "Request Groups" form. 5. Select "View" from the menu. Select "Find" from the menu. Select "System Administrator Reports". 6. Place the cursor in the "Type" column. Use "File" from the menu to create a "New" record. 7. Set the "Type" field to "Program". 8. Select "Purge Obsolete Generic File Manager Data" for the "Name" field. 9. Select "File" from the menu. Select "Save and Proceed" from the menu.
- Expired: Enter "Y" if you want to purge expired data only. Enter "N" if you want the purge to include all data. The default is "Y."
- Program Name: Enter the program name(s) to process. Leave blank to process all programs.
- Program Tag: Enter the program tag(s) to process. Leave blank to process all program tags. Tags are identifiers used by the Generic File Manager for categorization purposes.
alter index APPLSYS.FND_LOBS_CTX rebuild;
alter index APPLSYS.FND_LOBS_N1 rebuild;
alter index APPLSYS.FND_LOBS_U1 rebuild;