Last updated on MARCH 17, 2008
Applies to:Oracle Financial Services Applications (OFSA) 4.5.39
Oracle Financial Data Manager - Version: 4.5.39
This problem can occur on any platform.
After upgrading the OFSA database from Oracle 188.8.131.52 to 184.108.40.206, a SQL query that uses "like" in its where clause against a column with a datatype of CHAR returns no rows in SQL Talk. The same query returned rows in Oracle 220.127.116.11.
select to_char(CURRENT_EOM,'mm/dd/yyyy') from naa_processdate where APPLICATION = 'ALLOCATION';
-- Returns rows
select to_char(CURRENT_EOM,'mm/dd/yyyy') from naa_processdate where APPLICATION LIKE 'ALLOCATION';
-- No rows returned in Oracle 18.104.22.168
The APPLICATION column has the following definition:
APPLICATION NOT NULL CHAR(15)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms