My Oracle Support Banner

PO_AUTO_SRC Fails with ORDER BY Items Must Appear in the Select list if SELECT DISTINCT is Specified (Doc ID 2516534.1)

Last updated on DECEMBER 01, 2019

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE
---------------
When running PO_AUTO_SRC the process is running to No Success.


ERROR
-----------------------
File: e:\...\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725  Erro r Position: 0  Return: 8617 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]ORDER BY items m ust appear in the select list if SELECT DISTINCT is specified.
 [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180 Failed



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Requisition
2. Add contract to the requistion
3. Select Requisition
4. PO Auto Source

 

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.