Purging data in FND tables

Step1: Close the System Alerts of all severities

1. Navigate to System Administrator > Oracle Applications Manager > System Alert
2. Select the Critical Alert Click on the critical alert value.
3. Then click on  Close all button.
4. Repeat the steps for Error and Warnings, ensure all the alerts are closed.

Step2: Submit the concurrent request “Purge Logs and Closed System Alerts”

Step3: 
Run below sql commands.

 --- Verify the size -- 
SELECT SEGMENT_NAME, TABLESPACE_NAME, BYTES, BLOCKS, EXTENTS FROM DBA_SEGMENTS  WHERE segment_name ='FND_LOG_MESSAGES';

alter table APPLSYS.FND_LOG_MESSAGES enable row movement;

ALTER TABLE APPLSYS.FND_LOG_MESSAGES SHRINK SPACE;

alter table APPLSYS.FND_LOG_MESSAGES SHRINK SPACE CASCADE;

alter table APPLSYS.FND_LOG_MESSAGES disable row movement;

--- Verify the size ---

SELECT SEGMENT_NAME, TABLESPACE_NAME, BYTES, BLOCKS, EXTENTS FROM DBA_SEGMENTS  WHERE segment_name ='FND_LOG_MESSAGES';

FND_LOBS:


To Avoide abnormal growth of FND_LOBS table in Applications 11i [ID 298698.1]

select PCTVERSION from dba_lobs where TABLE_NAME = 'FND_LOBS' and COLUMN_NAME='FILE_DATA'; 
ALTER TABLE FND_LOBS MODIFY LOB (FILE_DATA) ( PCTVERSION 0 );

How To Manage, Reduce, and/or Purged The FND_LOBS Table? [ID 1288149.1]

Running the "Purge Obsolete Generic File Manager Data" (FNDGFMPR) program is the only supported method of purging data

Questions on Purge Obsolete Generic File Manager Data [ID 1165208.1]

Program Parameters:
    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.