'Error:Invalid SQL Type' Running FTP 6.0 Upgrade
Last updated on JANUARY 26, 2015
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Oracle Financial Services Asset Liability Management - Version 6.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
When upgrading to Oracle Financial Services Funds Transfer Pricing (FTP) 6.0, the following error appears in the FTP Install log:
[Tue 13/3/2012 06:51:33] [OFSFTP] [ERROR] - Query:'-- For Bug no: 12690196 After executing SP5.6 Pack, it is removing existing roles.
-- Removed DELETE From "CSSMS_GROUP_ROLE_MAP,CSSMS_ROLE_MAST" as the delete will delete entries in child table
--DELETE FROM CSSMS_GROUP_MAST WHERE V_GROUP_CODE IN ('UGFTPADMIN','UGFTPANALYST','UGFTPAUDITOR')'
Error:Invalid SQL type
You do not know what causes the error and if you need to do something to fix it.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms