Search Multiple GL accounts from BI Reports using concatenated segments

David Wright - More4apps

Description

We need to be able to fetch multiple GL accounts from a BI report using the entire account number (i.e. concatenated segments).

We need to be able to search for GL accounts using the LIKE lexical operator in BI reports. Currently, this is not supported for WHERE statements and no results are returned. Using a SELECT statement causes the indexing to be broken, resulting in timeouts.

Currently, there is no workaround available to fetch large amounts of data using Flex fields in Data models as these are using PL/SQL packages.
To pass multiple values in to the Flex fields we need "IN" operator. Currently, Flex fields are not supported with "IN" operator.

When adding KFF Where lexical, the LIKE operator does not work with parameters.

We're expecting to be able to use a LIKE operator and provide a % value when running the report, however no results are returned.

Use Case and Business Need

This is needed for the retrieval of account information and currently, without this we cannot retrieve values within Oracle BI Publisher through the user of reports.

More details

The major issue with using the separated segments is that the data that is imported using the integration tool has the account concatenated, so for this and other KFF structures it's not feasible to split it (i.e. the chart of accounts change the structure).

Original Idea Number: f31a4276bf