After 19c Database Upgrade on AAI 8.0.9.2 PFT Allocation Batch Tasks Are Hanging Without Any DB Session
(Doc ID 2809449.1)
Last updated on MARCH 08, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.9 and laterOracle Financial Services Profitability Management - Version 8.0.6.6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Symptoms
When attempting to run large allocation batches, one of the batch took more than 2 hours to complete. It is showing database session hanging and the allocation batch is not moving forward. When the allocation was re-run it is completed in a few minutes.
Steps:
1. Apply PFT 8.0.6.6 Maintenance Release Patch 31562914.
2. Apply AAI 8.0.9.2 Maintenance Release Patch and two platform patches below:
AAI 8.0.9.2.1 Patch 31647089 ISSUE IN COMMON OBJECT MODEL FOR CAPTURING START DATE AND END DATE
AAI 8.0.9.2.5 Patch 32006716 DT EDIT FAILING WITH THE ERROR [665530] EDIT FAILED CODE VALIDATION FAILED
3. Upgrade database to 19c.
4. Follow steps in After Database 19c Upgrade, All PFT Allocation Rules Are Failing With Errors "ofspa: error while loading shared libraries: libclntshcore.so.12.1" (Doc ID 2739931.1)
5. Run PFT Batches for monthly cycle.
6. Find one of the batch hang for over 2 hours.
7. Kill the process via OFSAA Services.
8. Re-run the PFT Batch that previously hang and it is completed successfully in a few minutes.
.
Changes
Upgrade database from 12c to 19c.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |