My Oracle Support Banner

E1: 31: Work With Operation Dispatch SQL Error When Display Sequence Request Date And ASC Selected (P31220) (Doc ID 2678985.1)

Last updated on JULY 13, 2020

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When signed into an E1 SQL database / environment i.e. JDPSQL and attempting to search on work orders by work center i.e. 200-201 via the P31220 Work With Operation Dispatch, and the Display Sequences Request Date and ASC options are selected, when find is clicked the P31220 throws an SQL Exception error. Error: Jas Data Base Failer:  SQJ Exception Occurred An SQL exception occurred A column has been specified more than once in the order by list. Columns in the order by list must be unique.

Steps To Duplicate:  
1.  Sign into E1 9.2 JDPSQL Environment then go to P31220 Work With Operation Dispatch and enter the following information i.e. Work Center, From Date Period, Through Date Period, and select the Display Sequence  Request Date and ASC options.
Note this can only be duplicated in an SQL environment i.e. JPDSQL


2.  Click Find and notice the SQL Exception Error Jas Data Base Failer:  SQJ Exception Occurred An SQL exception occurred A column has been specified more than once in the order by list. Columns in the order by list must be unique is given.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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