My Oracle Support Banner

E1: 42: During Pick Slip (R42520) Processing Operator Was Changed from And to Or in Data Selection (Doc ID 2916128.1)

Last updated on DECEMBER 16, 2022

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.2 and later
Information in this document applies to any platform.


When Pick Slip Print (R42520) was run twice 30 seconds apart, the first job had AND in the operator of the third data selection and the second job had OR in the operator of the third data selection. The user that ran the two jobs insists they did not manually select OR from the Operator drop down list. The user believes the system automatically changed the selection. The client cannot duplicate the issue, but here are the steps reported by the user that led up to the issue:

First the user clicks the Print Pick Ticket Button on their E1 Page.

This brings up the Version Prompting Page. The user clicks the data selection checkbox and then clicks the Submit button so they can enter their assigned order number in the data selection.

There are three data selections pre-populated as follows:

The user pulls down the right operand for the third line (order number) and selects “Literal” from the drop-down list.

On the Select Literal Value screen the user types in the Order Number and clicks the green checkmark. 

When the Data Selection screen returns, “And” is still in the left operator on the third row, but the user says when they click the green checkmark, the “And” is changed to “Or”. This cannot be duplicated in test but client says it has happened 4 times in 4 months.





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.