After Applying AAI 8.0.7.7 Patch 33511716 Some OFSAA Screens Are Not Working Properly
(Doc ID 2869244.1)
Last updated on APRIL 02, 2024
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.7.2.0 and laterOracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Analytical Application Infrastructure (OFSAAI / AAI)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
In an integrated environment, after applying AAI 8.0.7.7.0 (<Patch 33511716>) some OFSAA Screens are not working properly. Allocation Specification screen gives a NULL error message and Post Load Changes and Data Mappings are stuck on loading.
Additionally, below errors can be seen in the OFSAA.log:
[18-02-22 11:55:47,272 GMT AM] [DEBUG] [WEB] [NA] [NA] Exception Occured while executing query :: java.lang.reflect.InvocationTargetException
[18-02-22 11:55:47,272 GMT AM] [DEBUG] [WEB] [NA] [NA] Query -> SELECT * FROM AAI_WF_GLOBAL_CLUSTER_LOCK WHERE V_LOCK_NAME=? for update
Query Parmeters as provided -> REQUEST
[18-02-22 11:55:47,273 GMT AM] [ERROR] [WEB] [NA] [NA] java.lang.reflect.InvocationTargetException
[18-02-22 11:55:47,273 GMT AM] [DEBUG] [WEB] [NA] [NA] Error while getting request lock for updatejava.sql.SQLException: Could not execute sql command - Original message: SQL string is not a DML Statement
[18-02-22 11:55:47,273 GMT AM] [ERROR] [WEB] [NA] [NA] java.sql.SQLException: Could not execute sql command - Original message: SQL string is not a DML Statement
Screenshots:
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 |
| Cause |
| Solution |
| References |