OAS connecting to Redshift DB is failing to run oracle db functions

We are moving from OBIEE 12c to OAS 2024, our current OBIEE reports points to Oracle database. We are migrating the data to Redshift db and then repointing migrated OAS reports to Redshift db.

While running the migrated reports we are seeing an issue with the database function incompatibility. Below is one such error.

State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: S1000 code: 56966976 message: [Oracle DataDirect][ODBC Redshift Wire Protocol driver][Redshift]ERROR: SUBSTR() function is not supported (Hint: use SUBSTRING instead)(Detail ----------------------------------------------- error: SUBSTR() function is not supported (Hint: use SUBSTRING instead) code

In OBIEE reports we have used the oracle db functions like Substring, but I see when the report runs the physical query generated is having SUBSTR() which is Oracle compatible, now redshift db is throwing an error to use SUBSTRING(), which we already have used it while creating a logical column, but when report is processed SUBSTRING () is getting changed to oracle db compatible function SUBSTR().