Managing Concurrent Processes

This appendix covers the following topics:

Isolate Post Upgrade Concurrent Programs to a Separate Manager Queue

Overview

The downtime portion of the upgrade includes the automatic submission of several concurrent programs. For a list of sample concurrent programs, refer to the Sample Concurrent Programs section in this appendix.

In many cases, concurrent programs run in multiple threads, therefore, the total number of concurrent requests that make up portions of the post-upgrade step can be high. These upgrade programs are run by the concurrent manager once the system is up, and processing will be mixed with ongoing concurrent jobs in the system.

You can define a separate concurrent manager queue to process only the post-upgrade concurrent programs, therefore improving manageability of this situation. You can use inclusion and exclusion rules to prevent other manager queues (such as the standard manager) from picking up requests, and force this new manager queue to process specific upgrade requests. This method lets you control the number of target processes allocated to these post-upgrade concurrent programs, including dynamic processes with the use of work shifts. For additional details on configuring new manager queues, target processes, inclusion and exclusion rules, and work shifts, refer to the Oracle E-Business Suite Setup Guide.

If you plan to isolate post-upgrade concurrent programs to a separate manager queue, then you must create a new concurrent manager for these upgrade concurrent programs before you shut down all services as part of the Perform the Upgrade tasks described in this guide. This procedure is needed to prevent existing Request Processing Managers from picking up and executing requests when services are started at the end of the upgrade.

Create a New Concurrent Manager for Upgrading Concurrent Programs

To create a new program type and include a program in that program type:

  1. Log in to Oracle E-Business Suite as SYSADMIN, and navigate to:

    System Administrator > Concurrent: Program > Type

  2. Select or enter the following attributes:

    Name: R12PUPT

    Application: System Administration

    Description: Program Type for Post Upgrade Request

  3. Include programs from the above list into this new program type.

  4. Navigate to:

    System Administrator > Concurrent: Program > Define

  5. Search for the program 'Refresh Materialized Views' and enter or select: R12PUPT

  6. Repeat for other programs in the list.

To exclude a program type from the Standard Manager:

  1. Log in to Oracle E-Business Suite as SYSADMIN and navigate to:

    System Administrator > Concurrent: Manager > Define

  2. Search for Standard Manager.

  3. Click on Specialization Rules.

  4. Navigate to the bottom of the list to add a new record.

  5. Select or enter the following attributes:

    Include/Exclude: Exclude

    Type: Request Type

    Application: System Administration

    Name: R12PUPT

  6. Repeat for all other Request Processing Managers.

To create a new concurrent manager and include a program type:

  1. Log in to Oracle E-Business Suite as SYSADMIN and navigate to:

    System Administrator > Concurrent: Manager > Define

  2. Select the Enabled checkbox.

  3. Select or enter the following attributes to create the new concurrent manager:

    Manager: R12_Post_Upgrade

    Short Name: R12PU

    Application: Application Object Library

    Description: New manager queue for R12 post upgrade requests

    Type: Concurrent Manager

    Cache Size: 1

    Program Library Name: FNDLIBR

    Specialization Rules:

    Include/Exclude: Include

    Type: Request Type

    Application: System Administration

    Name: R12PUPT

    Work Shifts:

    Work Shift: Standard

    Processes: Enter a Value, for example '4'

    Sleep Second: 30

Activate the New Concurrent Manager

After completing the above steps, activate the new concurrent manager R12_Post_Upgrade immediately after it is created.

  1. Log in to Oracle E-Business Suite as SYSADMIN and navigate to:

    System Administrator > Concurrent: Manager > Administer

  2. Select the new Concurrent Manager 'R12_Post_Upgrade'.

  3. Click the Activate button.

Disable the New Concurrent Manager

After all post-upgrade requests run during the Verify completion of concurrent programs step described in the Post Upgrade Tasks chapter, you must revert the exclusion and inclusion of managers and programs to the original state by removing the new program type and new manager. This is necessary because some programs in the list may need to run in the future as part of the regular system batch processing requirements rather than part of the upgrade process.

Sample Concurrent Programs

The following table contains a sample list of concurrent programs submitted during the upgrade from Release 12.1.3 Vision to Release 12.2.0. This data is for reference only. The actual list in your instance may vary based on, but not limited to various factors including:

Application Name Concurrent Program Name User Concurrent Program Name Total Number of Requests
Advanced Supply Chain Planning(MSC) MSCREFMV Refresh Materialized Views 1
Advanced Supply Chain Planning(MSC) MSCHUBM Maintain APCC Data Model 1
Application Implementation(AZ) AZR12UPGRADE iSetup R12 Upgrade Selection Sets Column 1
Application Object Library(FND) FDFCMPN Compile Non-Compiled Flexfields 1
Application Object Library(FND) AFLOBBLD Rebuild Help Search Index 2
Application Object Library(FND) ABORT Abort 2
Application Object Library(FND) FNDIRLPP iRep Loading Post Processor 3
Application Object Library(FND) FNDSCMPI Compile Security 2
Application Object Library(FND) FNDLOAD Generic Loader 5
Application Object Library(FND) DIAGPATCHINGCP Diagnostics patching CP 1
Application Object Library(FND) FNDIRLOAD FNDIRLOAD 5
Application Object Library(FND) FDFVGN Flexfield View Generator 443
Application Object Library(FND) FNDWFDSRHP Workflow Role Hierarchy Propagation 1
Applications DBA(AD) ADDRPOBS Drop obsolete products schema 71
Applications DBA(AD) ADZDPATCH Online Patching In Progress 1
Asia/Pacific Localizations(JA) JAINDFOBS India - Remove India Localization contexts from DFFs1 1
Incentive Compensation(CN) CN_R1212_CNCMHUPD CN_R1212_CNCMHUPD 8
Incentive Compensation(CN) CN_FORMULA_GEN Generate Formula Packages 1
Incentive Compensation(CN) CN_R1212_CNCMHUPD CN_R1212_CNCMHUPD 8
Incentive Compensation(CN) CN_R1212_CNCMAUPD CN_R1212_CNCMAUPD 8
Inventory(INV) INVIDSEP Items Data Scripts Execution 1
Master Scheduling/MRP(MRP) MRCSCW1 Planning Manager Worker (once-a-day tasks) 2
Master Scheduling/MRP(MRP) MRPSPMRP Maintain Repetitive Planning Periods 55
Master Scheduling/MRP(MRP) MRCRLF Planning Manager 3
Payments(IBY) IBYUPGCP iPayment FP.G Upgrade Program 1
Receivables(AR) ARHDQCMAL DQM Compile All Rules 1
Receivables(AR) HZ_THIRD_PARTY_UPDATE Third Party Data Integration Update 1
Receivables(AR) ARHDQM DQM Staging Program 1
Service(CS) CS_KB_SYNC_SOLUTIONS_INDEX Knowledge Management Solution Index Synchronization 1
Trade Management(OZF) OZFEARNMV Refresh Materialized View 1
Trade Management(OZF) OZFMIGUTLREC Migrate Accruals for Multi Currency Changes 1
Warehouse Management(WMS) WMSGRULE Generate All Rules 1
XML Publisher(XDO) XDOTMGEN XML Publisher Template Re-Generator 1