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)

 

APPLIES TO:

Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

GOAL

E-Business Suite R12 Concurrent Processing, Concurrent Manager and Request issues

 

 

 

 

Provide documentation and resources for the new cpadmin.sh command line utility.

The cpadmin.sh script is a command-line tool which consolidates various existing tools for concurrent processing into a single menu-based utility run via a shell script.

 

SOLUTION

The new cpadmin.sh utility initial announcement was provided in the following blog article released by development:

https://blogs.oracle.com/stevenchan/new-cpadmin-utility-for-managing-concurrent-processing-now-available

 

The cpadmin.sh utility is formally documented by development in the following user guide:

https://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T575591.htm#8159578

 

This adadmin style utility was designed to integrate the following Concurrent Processing features in one script.

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.

Running the cpadmin utility:

Complete the steps below to run the command-line utility and its maintenance tasks.

1. Set the environment. in order to apply the environment variables defined for the system. See Setting the Environment, Oracle E-Business Suite Maintenance Guide for more information.
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.

 

Note:

CPADMIN utility is designed only for interactive mode, and there is no documentation for it to be used otherwise.