Cannot Create Data Filter on Some Simple Dimension Columns in OFSAAI 7.3.3
Last updated on JANUARY 17, 2014
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) 7.3.3, you cannot create a Data Filter on certain Simple Dimensions (ex. Account Officer). When you select the Simple Dimension in the "Data Element Selection" list, the following message appears on the screen:
No Data Found
When you check the FUSIONSUBSYSTEMSService.log in the Web Server's OFSAA log directory, you find an error like the following:
[FUSIONSUBSYSTEMS] Nov 22,13 09:41:47 : [COMMONFUNCTIONS]Query to get the code values.. select b.ACCOUNT_OFFICER_CD,tl.ACCOUNT_OFFICER from FSI_ACCOUNT_OFFICER_CD b, FSI_ACCOUNT_OFFICER_MLS tl where b.ACCOUNT_OFFICER_CD = tl.ACCOUNT_OFFICER_CD AND (UPPER(tl.ACCOUNT_OFFICER) like UPPER(coalesce(?,tl.ACCOUNT_OFFICER)) OR ( b.ACCOUNT_OFFICER_CD IN (''))) AND TL.MLS_CD = ? order by tl.ACCOUNT_OFFICER
[FUSIONSUBSYSTEMS] Nov 22,13 09:41:47 : [COMMONFUNCTIONS]SQL Exception occured while trying to retrieve code values.
[FUSIONSUBSYSTEMS] Nov 22,13 09:41:47 : [COMMONFUNCTIONS]
java.sql.SQLSyntaxErrorException: ORA-00904: "TL"."MLS_CD": invalid identifier
The error appears to occur because the Simple Dimension's "_MLS" table does not have an MLS_CD column. However, according to the Oracle Financial Services Data Model Utility Guide, a simple dimension's "_MLS" table does not require an MLS_CD column.
Steps to Reproduce:
- Go to Financial Services Applications
- Go to Master Maintenance > Filters
- Create a new Data Element Filter
- In Data Element Selection, select a simple dimension column (ex. Account Officer Code)
After selecting the column, the "No Data Found" message appears.
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