CPADMIN command line utility for managing the Concurrent Processing in Oracle Apps R12.2.6 version and above.


It is an ADADMIN-style utility that can be used for multiple tasks like below:
  • View Concurrent Manager status
  • Clean CP tables
  • Set Concurrent Manager diagnostics
  • Start, stop, or verify an individual Concurrent Manager
  • Rebuild Concurrent Manager views
  • Move request files
  • Analyze requests
  • Configure request log/out file directory locations
Running the cpadmin utility
Complete the steps below to run the command-line utility and its maintenance tasks.

1. Set the application Run environment.
2. From any directory, start cpadmin with the below command:
   $ cpadmin.sh
   The utility starts and prompts you for the APPS password (required).
3. Respond to prompts. Supply the information requested by cpadmin prompts. Prompts unique to an option are described with the option. When you complete the prompts, the Main Menu appears.
4.Choose one of the tasks listed above.
5. Exit the cpadmin utility.


It has the following menu options:
Manager Status
This option is used to view the status of concurrent managers and services.
Use this option to display running managers (with or without process IDs) or display all managers.
The same status information is shown in Administer Concurrent Managers form and OAM Concurrent Managers page.

Clean CP Tables
Use this option to clean up the concurrent processing tables. This utility replaces cmclean.sql. Use this option when the Internal Concurrent Manager (ICM) fails to start due to corrupted/conflicted tables. Note the following actions when choosing this option:
Managers must be stopped first (the utility will verify this).
Clean up inconsistencies in manager tables; remove corruption.
Reset manager states for clean start-up.
Clean and reset Advanced Queue tables for the Output Post-Processor and FNDSM Service Manager.
Reset request conflicts for the Conflict Resolution Manager (CRM).
Identify and clean orphaned requests.
This option is supported by Oracle for use on client systems.
Important: DO NOT USE the cmclean.sql script.

Set Manager Diagnostics
Turn diagnostics on or off for individual managers with this option. You can use this option to turn diagnostics on/off for specific managers without bouncing all services.
This option is available for:
ICM
CRM
Output Post-Processor
Request Processing Managers
Transaction Managers
Each option will display the current diagnostic status (ON or OFF) of the running managers/services and allow you to change the status.

Manager Control
Use this option to send a request such as start, stop, or verify to an individual manager.
Use to send a control request to a manager or service.
This option does the following:
Displays current status of all managers and processes.
Once a manager or service is chosen, offers valid control options for that specific choice.
Valid options for managers: activate, deactivate, verify, restart, abort, shut down.
Valid options for services also include: suspend and resume. Any service can be programmed to respond appropriately to each option; but if one is not, then the service will not respond.

Rebuild Manager Views
Use when Manager Views must be rebuilt.
This option rebuilds the FND_CONCURRENT_WORKER_REQUEST and FND_CONCURRENT_CRM_REQUESTS views with the following steps:
Managers must be stopped first. The utility verifies that these are stopped.
Rebuilds FND_CONCURRENT_WORKER_REQUESTS.
Rebuilds FND_CONCURRENT_CRM_REQUESTS.
Running this option is the same action as running FNDCPBWV.

Move Request Files
Change request log and output file locations with this option.
Use to update the concurrent processing tables for changing the following values for request LOG file, OUT file, or BOTH:
Individual requests: fully qualified file name or node name
Range of requests: directory name or node name
Range of requests can be selected by minimum/maximum date or minimum/maximum request_id
Important: The cpadmin utility changes only the concurrent processing database table values to support movement. The files must be manually moved by an administrator.

Analyze Request
Use this option to analyze a concurrent request.
Use when analyzing a request for any reason. This is non-destructive.
Managers need not be shut down for this option.
This option does the following:
Checks the manager's status.
Analyzes the request's status.
Provides a detailed report on concurrent program.
Gives a detailed report on request's current status.


Reference:

R12 E-Business Suite Concurrent Processing Script Cpadmin.sh Command Line Utility Which Consolidates Existing CP Tools Into A Single Menu-Based Shell Script (Doc ID 2319585.1)