GPFR: ORA-01427 IN RUN PAYMENT PREP PROCESS FRA (Doc ID 2193814.1)

Last updated on OCTOBER 17, 2016

Applies to:

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

Symptoms


When attempting to run the Payment Preparation process for France,
the following error occurs.

ERROR
-----------------------
Stmt #: 1703 Error Position: 46 Return: 1427 - ORA-01427: single-row subquery returns more than one row
[...]
Process 383256 ABENDED at Step GPFR_PMT_AE.POPULATE.updatet5 (SQL) -- RC = 1427 (108,524).

STEPS
-----------------------
Pre-req: . make sure there are similar bank and branch codes across countries in the bank and branch table


The issue can be reproduced at will with the following steps:
1. Navigate to Global Payroll & Absence Mgmt > Payment Processing > Run Payment Prep Process FRA



Cause

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