Searching for Serial Number in Serial Numbers and View Genealogy Forms Error with "ORA-00920: invalid relational operator"
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