My Oracle Support Banner

GPAUS: Process GPAU_EFT_CMX Runs To Error After Applying PI#26 (Doc ID 2429583.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise HCM Global Payroll Australia - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

STATEMENT:
==========
Process GPAU_EFT_CMX runs to error after applying PI#26
While testing of PI#26 , process GPAU_EFT_CMX ran to error.

ERROR:
=======
File: e:\pt85425c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1708 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
[Microsoft][SQL Server
 Failed SQL stmt: INSERT INTO PS_GPAU_EFT_CLRMAP ( PAY_ENTITY , GP_PAYGROUP , RECIPIENT_ID , RECIPIENT_TAG , CAL_RUN_ID , CAL_ID , GPAU_LODGEMENT_REF , SRC_BANK_ID , GPAU_BANK_DB_TYPE , BRANCH_EC_CD , ACCOUNT_EC_ID , ACCOUNT_NAME , GPAU_PARTY_ID , GPAU_TR_BRANCH_CD , GPAU_TR_ACCOUNT_CD , GPAU_ACCOUNT_NAME , GPAU_CLRHOUSE_LRN ) SELECT DISTINCT A.PAY_ENTITY , A.GP_PAYGROUP , A.RECIPIENT_ID , A.RECIPIENT_TAG , A.CAL_RUN_ID , A.CAL_ID , A.GPAU_LODGEMENT_REF , A.SRC_BANK_ID , A.GPAU_BANK_DB_TYPE , A.BRANCH_EC_CD , A.ACCOUNT_EC_ID , A.ACCOUNT_NAME , C.GPAU_PARTY_ID , D.BRANCH_EC_CD , D.ACCOUNT_EC_ID , D.ACCOUNT_NAME , C.GPAU_LODGEMENT_REF FROM PS_GPAU_EFT_CMX_TR A , PS_GPAU_THIRD_DTL B , PS_GPAU_THIRD_PRTY C , PS_RECIPIENT D WHERE A.PAY_ENTITY = B.PAY_ENTITY AND B.GPAU_ORG_LINK_OPTN = 'RE' AND A.RECIPIENT_ID = B.ORG_LINK_UNIT AND B.GPAU_THIRD_PARTY = '02' AND B.GPAU_PARTY_ID = C.GPAU_PARTY_ID AND C.GPAU_CLRHOUSE = 'Y' AND C.GPAU_PARTY_ID = D.RECIPIENT_ID AND A.PMT_TYPE IN ('02', '03') AND B.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GPAU_THIRD_DTL TD1 WHERE TD1.GPAU_ORG_LINK_OPTN = B.GPAU_ORG_LINK_OPTN AND TD1.PAY_ENTITY = B.PAY_ENTITY AND TD1.ORG_LINK_UNIT = B.ORG_LINK_UNIT AND TD1.SETID = B.SETID AND TD1.EFFDT <= '2018-05-24' ) AND A.GPAU_EFT_TRANS_CD = '50' AND A.GPAU_BANK_DB_TYPE = '30'

Process 4683 ABENDED at Step GPAU_EFT_CMX.GETXINFO.Step19 (SQL) – RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) – RC = %s
PSAESRV completed service request at 09.44.58 2018-05-09

STEPS TO REPLICATE:
===================
The issue can be reproduced at will with the following steps:
1.Navigate to Create EFT Payment File AUS page
2.Run the GPAU_EFT_CMX process
3.Process went to No Success

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.