My Oracle Support Banner

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

Last updated on APRIL 15, 2021

Applies to:

Oracle Retail Warehouse Management System - Version 14.1 and later
Information in this document applies to any platform.


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


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

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