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.
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.
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