Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.1.11.1.0 and laterOracle Fusion Application Toolkit Cloud Service - Version 11.1.11.1.0 and laterInformation in this document applies to any platform.

Goal

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:

Test case

Operator LIKE, Contain all, Contain any works, but if customer have data somelike

Supplier name Invoice Type name Amount

Abc* Standard 100Abcdef Standard 50Abczzz 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