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. 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 Product Catalog(EGO) EGOCPAGV User-Defined Attribute Group Views (AGV) Compilation Program 2
Advanced Supply Chain Planning(MSC) MSCREFMV Refresh Materialized Views 2
Application Implementation(AZ) AZR12UPGRADE iSetup R12 Upgrade Selection Sets Column 4
Application Object Library(FND) FNDIRLPP iRep Loading Post Processor 20
Application Object Library(FND) FNDWFBES_CONTROL_QUEUE_CLEANUP Workflow Control Queue Cleanup 4
Application Object Library(FND) FNDSCMPI Compile Security 2
Application Object Library(FND) FNDLOAD Generic Loader 10
Application Object Library(FND) FNDWFNTFCU Workflow Update Notification Action Comments 4
Application Object Library(FND) FNDFIXRN Fix FND role names 2
Application Object Library(FND) FNDWFMLRSTATCC Workflow Mailer Statistics Concurrent Program 4
Application Object Library(FND) FNDIRLOAD FNDIRLOAD 20
Application Object Library(FND) DIAGPATCHINGCP Diagnostics patching CP 4
Application Object Library(FND) FNDRSSUB Report Set 6
Application Object Library(FND) FNDRSSTG Request Set Stage 6
Application Object Library(FND) FDFVGN Flexfield View Generator 1656
Application Object Library(FND) FNDWFAASTATCC Workflow Agent Activity Statistics Concurrent Program 4
Application Object Library(FND) VERIFY Verify 2
Application Object Library(FND) FNDWFWITSTATCC Workflow Work Items Statistics Concurrent Program 4
Application Object Library(FND) FNDWFDSRHP Workflow Role Hierarchy Propagation 82
Application Object Library(FND) AFLOBBLD Rebuild Help Search Index 4
Application Object Library(FND) ABORT Abort 4
Application Object Library(FND) FDFCMPN Compile Non-Compiled Flexfields 6
Application Object Library(FND) FDFCMPK Compile Key Flexfields 108
Applications DBA(AD) ADDRPOBS Drop obsolete products schema 408
Applications DBA(AD) ADZDPATCH Online Patching In Progress 4
Asia/Pacific Localizations(JA) JAINDFOBS India - Remove India Localization contexts from DFFs 4
Collections(IEX) IEX_COLLECTORS_TO_RESOURCE IEX: AR Collectors To Resource Collectors 2
Contracts Core(OKC) OKCCHRCRCTX Create Contract Header Text Index 4
Contracts Core(OKC) OKCARTCRTCTX Create Clause Text Index 4
Human Resources(PER) PERNMFT_INT Update Person Names (Internal) 2
Human Resources(PER) PER_FND_SESSIONS_CLEANUP Remove obsolete sessions from fnd_sessions 12
Human Resources(PER) PERNMFT Update Person Names 2
Human Resources(PER) IRC_CREATE_NOTIFICATION iRecruitment Create Notification Preferences 16
Incentive Compensation(CN) CNUPGPMTCOMMTRXMGR Upgrade commissions and transactions for AutoUpgrade or AutoPatch - Manager 4
Incentive Compensation(CN) CN_R1212_CNCMHUPD CN_R1212_CNCMHUPD 32
Incentive Compensation(CN) CNUPGPMTCLWRKER Upgrade payment commission lines - Worker 40
Incentive Compensation(CN) CN_FORMULA_GEN Generate Formula Packages 4
Incentive Compensation(CN) CN_R1212_CNSRPTXN CN_R1212_CNSRPTXN 32
Incentive Compensation(CN) CNUPGPMTRXMGR Upgrade transactions for AutoUpgrade or AutoPatch 4
Incentive Compensation(CN) CNUPGPMTRXWRKER Upgrade payment transactions - Worker 40
Incentive Compensation(CN) CN_R1212_CNCMAUPD CN_R1212_CNCMAUPD 32
Inventory(INV) INVIDSEP Items Data Scripts Execution 4
Labor Distribution(PSP) PSPERUPB PSP: Migrate to OAFramework Effort Reporting 2
Oracle iProcurement(ICX) ICXCUCDER Catalog Child Data Exceptions Report 2
Purchasing(PO) POXUPMGR Purchasing Post-Upgrade Process 2
Purchasing(PO) POXUPWKR Purchasing Post-Upgrade Sub Process 6
Receivables(AR) ARHSUFXS Data Fix for Party Site Use 4
Receivables(AR) ARHDQCMAL DQM Compile All Rules 2
Receivables(AR) ARHGNRW Geography Name Referencing Worker 40
Receivables(AR) ARHDQMPC DQM Parallel Sync Index Child Program 16
Receivables(AR) ARHDQM DQM Staging Program 2
Receivables(AR) ARHDCH DQM Sync Import Child Program 8
Receivables(AR) ARHDQMPP DQM Parallel Sync Index Parent Program 4
Receivables(AR) ARHDQSYN DQM Synchronization Program 2
Receivables(AR) HZ_GNR_DYNMK_PKG_GEN GNR Dynamic packages Generation 4
Regional Localizations(JG) JGZZVATTRXUPG EMEA VAT: Transaction Upgrade 4
Service Contracts(OKS) OKSTAXBMGR Service Contracts Update Base Tax Columns Manager 4
Service Contracts(OKS) OKSLAUNCHKWF Launch Process Workflow for existing Service Contracts 4
Service Contracts(OKS) OKSTAXHWKR Service Contracts Update History Tax Columns Worker 16
Service Contracts(OKS) OKSUBAFMGR Service Contracts Update Base Annualized Factor Manager 4
Service Contracts(OKS) OKSAQUMG Service Contracts ASO Queue Migration 4
Service Contracts(OKS) OKSUBAFWKR Service Contracts Update Base Annualized Factor Worker 16
Service Contracts(OKS) OKS_TAX_MIGRATION Service Contracts eBTax Migration 4
Service Contracts(OKS) OKSUHAFMGR Service Contracts Update History Annualized Factor Manager 4
Service Contracts(OKS) OKSTAXHMGR Service Contracts Update History Tax Columns Manager 4
Service Contracts(OKS) REPROCESS_SYNC_RULE_DATA Service Contracts Reprocess/Synchronize Rule Data 2
Service Contracts(OKS) OKSTAXBWKR Service Contracts Update Base Tax Columns Worker 16
Service Contracts(OKS) OKSUHAFWKR Service Contracts Update History Annualized Factor Worker 16
Service Contracts(OKS) OKS_REPROCESS_SUBREQUEST Service Contracts Subrequest for Reprocessing Rule Data 2
Service(CS) CSSRAMGEN Service: General Upgrade for Audit Records - Manager 4
Service(CS) CS_KB_SYNC_SOLUTIONS_INDEX Knowledge Management Solution Index Synchronization 2
Service(CS) CS_KB_SYNC_CATEGORIES_INDEX Knowledge Management Category Index Synchronization 2
Service(CS) CS_SR_SYNC_TEXT_INDEX Service Request: Synchronize Text Index Program 2
Service(CS) CS_KB_SYNC_STATEMENTS_INDEX Knowledge Management Statement Index Synchronization 2
Service(CS) CSSRAUDCWKR Service: Upgrade for Audit Creation Record - Worker 12
Service(CS) CSCHGLINENOMGR Charges: Upgrade for Line Number - Manager 4
Service(CS) CSCHGLINENOWKR Charges: Upgrade for Line Number - Worker 12
Service(CS) CSSRAUDCMAN Service: Upgrade for Audit Creation Record - Manager 4
Service(CS) CSSRAWGEN Service: General Upgrade for Audit Records - Worker 12
Trade Management(OZF) OZFMIGUTLREC Migrate Accruals for Multi Currency Changes 4
Trade Management(OZF) OZFEARNMV Refresh Materialized View 2
Warehouse Management(WMS) WMSGRULE Generate All Rules 2
XML Publisher(XDO) XDOTMGEN XML Publisher Template Re-Generator 4