RULE Generate Sql With Incorrect Syntax While Execution of RRF Rule Post Migration From PR2
Last updated on AUGUST 16, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 to 7.4.0 [Release 7]
Information in this document applies to any platform.
Execution of a RRF Rule that was migrated from PR2 using Archive/Restore feature fails due to incorrect Merge Query. The MERGE query in Task log under $FIC_DB_HOME/log/*/ shows an incorrect query that fail with "java.sql.SQLSyntaxErrorException: ORA-00905: missing keyword" error.
The Merge Query formed lags Spaces between the Keywords as per below extracts from log file
"CASE WHEN 0 = 1 THEN 17WHEN ", "THEN 1WHEN 0 < 0 THEN 22ELSE CASE "
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