'Error:Invalid SQL Type' Running FTP 6.0 Upgrade (Doc ID 1524230.1)

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)

Symptoms

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.

Cause

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