Data Filter: Not Showing Selected Values For the Currency Dimension (Doc ID 1382738.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.9 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x


Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.9 when attempting to edit a new Data Filter which filters on specific ISO_CURRENCY_CD values, the previously selected values do not appear and the following error occurs in the FUSIONSUBSYSTEMSService.log:

ERROR
[FUSIONSUBSYSTEMS] Aug 17,11 09:13:10 : [COMMONFUNCTIONS]Query to get the code values.. select b.ISO_CURRENCY_CD,tl.ISO_CURRENCY_CD_1 from FSI_CURRENCIES_V b, FSI_CURRENCIES_V tl where b.ISO_CURRENCY_CD = tl.ISO_CURRENCY_CD AND (UPPER(tl.ISO_CURRENCY_CD_1) like UPPER(coalesce(?,tl.ISO_CURRENCY_CD_1)) OR b.ISO_CURRENCY_CD IN (HRK)) order by tl.ISO_CURRENCY_CD_1
[FUSIONSUBSYSTEMS] Aug 17,11 09:13:10 : [COMMONFUNCTIONS]SQL Exception occured while trying to retrieve code values.
[FUSIONSUBSYSTEMS] Aug 17,11 09:13:10 : [COMMONFUNCTIONS]
java.sql.SQLException: ORA-00904: "HRK": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)

The issue can be reproduced at will with the following steps:
1. Create a new Data Filter which filters on specific currency code values.
2. Save the Data Filter
3. Open and edit the Data Filter again.

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