Concurrent Processing - How To Run the Purge Concurrent Request FNDCPPUR, Which Tables Are Purged, And Known Issues Like Files Are Not Deleted From File System
Last updated on SEPTEMBER 28, 2017
Applies to:Oracle Concurrent Processing - Version 184.108.40.206 to 12.2.4 [Release 11.5 to 12.2]
Oracle Concurrent Processing - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
To run the Purge Concurrent Request and/or Manager Data program:
1. Log in to Application as System Administrator responsibility.
2. Navigate to Request> Run> Single Request
3. Query up Purge Concurrent Requests.
4. For values to be entered in the parameter screen refer to the Oracle
Administration System Administration Guide
The following tables will be purged:
Table contains a complete history of all concurrent requests.
|FND_RUN_REQUESTS||When a user submits a report set, this table stores information about the reports in the report set and the parameter values for each report.|
|FND_CONC_REQUEST_ARGUMENTS||Table records arguments passed by the concurrent manager to each program it starts running.|
|FND_DUAL||Table for forms which only submit concurrent requests, and need to perform a commit cycle without updating a applications database table|
|FND_CONCURRENT_PROCESSES||Table records information about Oracle Applications and operating system processes.|
|FND_CONC_REQ_OUTPUTS||Table serves as a register of output files generated by requests|
|FND_CONC_PP_ACTIONS||Stores the post request processing actions(e.g., print, notify) for each submitted request. There's a concurrent_request_id here for each request_id
in the FND_CONCURRENT_REQUESTS.
Stores the post request processing actions(e.g., print, notify) for submitted request set programs that are stored in FND_RUN_REQUESTS
|FND_ENV_CONTEXT||Table stores information about environment name and value for each of the concurrent process|
In Oracle Applications R11i & R12:
Purge Concurrent Request and/or Manager Data (FNDCPPUR) program completes successfully, However either one or both of the following symptoms encountered:
1- The program deletes only unnecessary concurrent manager/requests information from database tables ( i.e. FND_CONCURRENT_REQUESTS, ...etc ). But itdoes not delete ( log / out ) files from the Operating System (OS) file system.
2- Customers who are running Oracle Applications Instances using:
Virtual Nodes/Hosts Environment and/or Shared APPLTOP Environment may have the files deleted but in this case the program is running slow and takes longer time to be completed.
The following could show that you are facing the issue:
Log file for (FNDCPPUR) concurrent program shows file deletion failed as below:
* 545345 - /../../w545345.mgr
* 545346 - /../../w545346.mgr
* denotes file deletion failed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms