On Database 19.18 Unable To Save Post Load Changes Objects in OFSAA
(Doc ID 2942275.1)
Last updated on APRIL 19, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.1.2 and laterOracle Financial Services Analytical Applications Infrastructure - Version 8.1.2 and later
Oracle Financial Services Asset Liability Management - Version 8.1.2 and later
Oracle Financial Services Profitability Management - Version 8.1.2 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 Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Symptoms
Unable to save Post Load Changes (PLC) objects after upgrading to OFSAA 8.1.2.2 on database 19.18.
Error:
OFSAA.err shows below error:
DMTConnectionFactory]~[closeDBConnectionsWithCommit]~Exception committing changes to the config connection
java.sql.SQLException: ORA-20000: Oracle Text Error:
DRG-50603: unrecognized operation code Failed in-memory hash indexing
DRG-50850: ORA-20000: DRG-50850: drftsync on-commit internal error
DRG-12202: error while creating section group
DRG-50850: dresInsNew:offset
Steps To Replicate:
1. Upgraded AAI/FTP/PFT modules to 8.1.2 (AAI on 8.1.2.2).
2. Add a new object or edit existing PLC object.
3. Click save and it goes back to the main PLC screen and it would not save the object.
4. Error shown in OFSAAErr.log file.
5. Create the database function directly in database without any issues but when trying to put the same script in post load changes to save, it is failing.
Changes
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 |