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 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:
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 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 |