Searching for Serial Number in Serial Numbers and View Genealogy Forms Error with "ORA-00920: invalid relational operator"

(Doc ID 1673783.1)

Last updated on AUGUST 21, 2016

Applies to:

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


When attempting to query a serial number in the Serial Numbers or View Genealogy forms, where the serial number begins with a pound sign (#) or other special character, the following errors occur:

NOTE: the issue only presents when the serial number begins with a pound sign, (#) or other special character.

ORA-00920: invalid relational operator

FRM-40505: ORACLE error: unable to perform query.

The issue can be reproduced at will with the following steps:
1. Navigation: Inventory > on-hand availability > serial numbers
2. Query any serial number that begins with a pound sign (#)
3. Click on View Genealogy Button
4. The error appear in both forms.


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