This appendix covers the following topics:
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.
To create a new program type and include a program in that program type:
Log in to Oracle E-Business Suite as SYSADMIN, and navigate to:
System Administrator > Concurrent: Program > Type
Select or enter the following attributes:
Name: R12PUPT
Application: System Administration
Description: Program Type for Post Upgrade Request
Include programs from the above list into this new program type.
Navigate to:
System Administrator > Concurrent: Program > Define
Search for the program 'Refresh Materialized Views' and enter or select: R12PUPT
Repeat for other programs in the list.
To exclude a program type from the Standard Manager:
Log in to Oracle E-Business Suite as SYSADMIN and navigate to:
System Administrator > Concurrent: Manager > Define
Search for Standard Manager.
Click on Specialization Rules.
Navigate to the bottom of the list to add a new record.
Select or enter the following attributes:
Include/Exclude: Exclude
Type: Request Type
Application: System Administration
Name: R12PUPT
Repeat for all other Request Processing Managers.
To create a new concurrent manager and include a program type:
Log in to Oracle E-Business Suite as SYSADMIN and navigate to:
System Administrator > Concurrent: Manager > Define
Select the Enabled checkbox.
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.
Log in to Oracle E-Business Suite as SYSADMIN and navigate to:
System Administrator > Concurrent: Manager > Administer
Select the new Concurrent Manager 'R12_Post_Upgrade'.
Click the Activate button.
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.
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:
Release level of Oracle E-Business Suite.
Additional product patches or patchsets applied to the instance.
Unaddressed upgrade failures.
| 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 |