My Oracle Support Banner

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 SEPTEMBER 27, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.9 and later
Oracle 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.