My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2019

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

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.