Fusion OTBI - Converting Asterisks Into Percent Wildcards In Report Filter
Last updated on DECEMBER 13, 2017
Applies to:Oracle Fusion Financials Common Module Cloud Service - Version 18.104.22.168.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Some of our supplier names have asterisks in them. When using their name in a filter, OTBI treats the asterisk as a wildcard and converts it to a % in the SQL shipped off to the database. Is there a way to turn this "featuree" off? Here is a snippet of the SQL that gets sent to the database:
Operator LIKE, Contain all, Contain any works, but if customer have data some
Supplier name Invoice Type name Amount
Abc* Standard 100
Abcdef Standard 50
Abczzz Standard 300
In this case if we use any of the Operator LIKE, Contain all, Contain any and select the supplier filter Abc*, it is going to display all the 3 suppliers.
If we take the Supplier name from the report output, in this case the report will be showing incorrect date instead of 100, it will be displaying 450 for the Abc* filter Invoice Type name Amount Standard 450
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