EAP: FLUID - Error When Viewing Payment Request Attachments in MS SQL Server DB (Doc ID 2196507.1)

Last updated on MAY 27, 2017

Applies to:

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

Symptoms

When using Fluid Approval for a Payment Request with an attachment, an error is thrown when you click on the attachment icon.

ERRORS

SQL error. Function:  SQLExec
 Error Position:  0
 Return:  8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Column "PS_EOATT_CFG_D_TBL.EOATT_SEQNBR" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause. [Microsoft][SQL Server Native Client 11.0
 Statement:  SELECT COUNT(1) FROM PS_EOATT_CFG_D_TBL WHERE EOATT_CONFIG_ID = :1 AND EOATT_LEVELNO = :2 AND EOATT_DISPLAY = 'Y' AND EOATT_HEADER ='Y' ORDER BY EOATT_SEQNBR
 Original Statement:  SELECT count FROM PS_EOATT_CFG_D_TBL WHERE EOATT_CONFIG_ID = :1 AND EOATT_LEVELNO = :2 AND EOATT_DISPLAY = 'Y' AND EOATT_HEADER ='Y' ORDER BY EOATT_SEQNBR

SQL error in DescribeCol. EOATT_COMM_ATTCH.CommAttchHandler.OnExecute  Name:PopulateScroll  PCPC:37199 Statement:608
Called from:EOATT_COMM_ATTCH.CommAttchHandler.OnExecute  Name:fillCAPage Statement:349
Called from:EOATT_VW_SCF.Activate  Statement:1
During the execution of SQL, an error occurred in the DescribeCol subroutine.
The preceding message should have described the details of the SQL being executed.


The above SQL generated the error in MS SQL Server database only. It is working fine in Oracle database.

STEPS
1. Enter Payment Request with attachment.
2. Log in as approver. Click Approvals tile.
3. Select Payment Request Approval.
4. Click on the Attachments section.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms