My Oracle Support Banner

After Applying AAI 8.0.7.7 Patch 33511716 Some OFSAA Screens Are Not Working Properly (Doc ID 2869244.1)

Last updated on JUNE 02, 2022

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.7.2.0 and later
Oracle 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


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