EAP: FLUID - Error When Viewing Payment Request Attachments in MS SQL Server DB
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.
When using Fluid Approval for a Payment Request with an attachment, an error is thrown when you click on the attachment icon.
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.
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.
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