E1: 43: R43800 - Evaluated Receipt Fails to Select Data with SQL Server Database (Doc ID 2877287.1)

Last updated on JULY 12, 2022

Applies to:

Symptoms

Under BUG: 33922313 changes were made to the logic of R43800 in order to perform data sequencing based on the processing option setup.
As a result of these changes the R43800 UBE fails to select any records from the F43121 when running over certain databases like for example SQL server.
It appears that the F43121 SELECT statement includes duplicates for columns PRDOCO, PRDCTO, PRKCOO and PRAN8 in the ORDER BY Clause of the SELECT statement, which causes the following error in the logs.

ODB0000164 - STMT:04 [42000][169][2] [Microsoft][ODBC SQL Server Driver][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.

The error does not occur with an Oracle Database


Steps to Duplicate:
-----------------------
1) P4310 Enter Purchase order
2) P4312 Receive Purchase order
3) Run R43800 selecting on order number (DOCO) and Report ends in error
4) JDE.log shows error ODB0000164 - STMT:04 [42000][169][2] [Microsoft][ODBC SQL Server Driver][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.
5) Check JDEDebug.log and Note the duplicate for columns PRDOCO, PRDCTO, PRKCOO and PRAN8 in the ORDER BY Clause of the F43121 Select statement

Cause

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