APP-FND-01564 & ORA-00920 Using Condition with BETWEEN in Non-English Instance
Last updated on JUNE 30, 2010
Applies to:Oracle Profitability Manager - Version: 11.5.10 to 126.96.36.199 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Program was terminated by signal 11
and the following message in the Output log:
APP-FND-01564: ORACLE error 920 in drv_upi
Cause: drv_upi failed due to ORA-00920: invalid relational operator.
The output log errors occur after SQL that uses a BETWEEN condition in the WHERE clause.
select natural_account_id from fem_nat_accts_b
where natural_account_display_code BETWEEN '861311' and '861364'
The word "BETWEEN" does not look correct in the log file. It is not the English word "BETWEEN".
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms