Purging Strategy in Oracle E-Business Suite -2- (FNDCPPUR)

Concurrent Program shortname is FNDCPPUR

Program name is "Purge Concurrent Request and/or Manager Data"

This concurrent program purge tables listed below.

FND_CONCURRENT_REQUESTS      

FND_RUN_REQUESTS       

FND_CONC_REQUEST_ARGUMENTS

FND_DUAL                 

FND_CONCURRENT_PROCESSES 

FND_CONC_STAT_LIST     

FND_CONC_STAT_SUMMARY    

FND_ENV_CONTEXT

Recommendation is scheduling this program every day with purging 30 days older data. To realize this schedule program with parameters ENTITY=ALL and Mode=Age and value is 30

Do not forget that purge concurrent request data will cause losing audit information which are used Signon Audit Concurrent Request Report.

As additional info with different values of ENTITY paramter will change purged tables.


ENTITY = ALL       : Fnd_Concurrent_Processes
                                  Fnd_Dual
                                  Fnd_Concurrent_Requests,
                                  Fnd_Run_Requests
                                  Fnd_Conc_Request_Arguments
                                  Fnd_Dual
                                  Fnd_Context_Env
                                  Deletes concurrent requests' log and out files from OS

ENTITY = MANAGER   : Fnd_Concurrent_Processes
                                          Fnd_Dual
                                          Deletes concurrent manager log files from OS

ENTITY = REQUEST     : Fnd_Concurrent_Requests,
                                          Fnd_Run_Requests
                                          Fnd_Conc_Request_Arguments
                                          Fnd_Dual
                                          Deletes concurrent requests' log and out files from OS

Oracle Support Document ID :  104282.1

Purging Strategy in Oracle E-Business Suite -1-(FNDLGPRG)