My Oracle Support Banner

Receipts Workbench: Query in Receipt Summary Form for Customers with Names Starting with Special Characters (Like #) Error - ORA-00920 FRM-40505 (Doc ID 1641270.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to query a receipt in the Receipts Summary form, by entering customer name that starts with a special character (such as #) and receive the following error:

Error Encountered:
ORA-00920: invalid relational operator
FRM-40505: ORACLE error: unable to perform query


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
 Still Have Questions?

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