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 (Doc ID 822368.1)

Last updated on JUNE 10, 2016

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

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 NameDescription
FND_CONCURRENT_REQUESTS
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.
FND_RUN_REQ_PP_ACTIONS
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

Known Issues:

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.

Cause

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