My Oracle Support Banner

GP CHE - Error Ocurs When Charging Bank File For Switzerland - Step GPCH_BK_03.MAIN.Step10 (Doc ID 2243249.1)

Last updated on MARCH 09, 2020

Applies to:

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


When launching load Files CHE for bank file a SQL error occurred in the AE cause of subquery wich returns more than one row.

Replication steps
1- Load Postal Code (necessairy to load bank file)
Acces to : Set Up HCM>Product Related>Global Payroll & Absence Mgmt>Framework>Processing>Load Files CHE.
Select Postal File and download Postal file. Modify it following instruction on pop-pup
Upload File and run the Process.

2- Load bank file.
Select Bank File and download file fromhyperlink
Upload File on peoplesoft
Run the Process

Process ABENDED at Step GPCH_BK_03.MAIN.Step10 (SQL)


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

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