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.

Symptoms

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

Cause

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