Item Master Editor Build Query Error: 'This Vendor Number is Invalid' (Doc ID 2066148.1)

Last updated on MARCH 15, 2019

Applies to:

Symptoms

On the Item Master Editor screen, when trying to use Build Query functionality, observe the Critical Alert:

Steps to Recreate:

1. Navigate to: Setup -Item > Item Master Editor
2. Click on Build Query on the left menu
3. Enter Query: InnerPackQty < 2
4. Click on Run Query
5. Observe Critical Alert: "This Vendor Number is Invalid"
6. Click OK
7. Alert pops back up and you cannot get past the Alert.  You must kill the session to proceed.
8. Several other number fields behave the same way as above:  StdCasepack, UOM Conv Factor, etc.

NOTE: These same queries work fine on the Item Master Inquiry > Build Query screen

Cause

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