GP CHE - Error Ocurs When Charging Bank File For Switzerland - Step GPCH_BK_03.MAIN.Step10

(Doc ID 2243249.1)

Last updated on MAY 02, 2018

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)


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