My Oracle Support Banner

APP-FND-01564 & ORA-00920 Using Condition with BETWEEN in Non-English Instance (Doc ID 1131192.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Profitability Manager - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

In Profitability Manager 11i, Mapping Rules are failing with the following error message in the View Log:

/ebs/visappl/fem/11.5.0/bin/FEMCCE
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.

For example:

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".

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.