Current Position:Home > Retropay by element run Errors for one employee

Retropay by element run Errors for one employee

Update:10-11Source: network consolidation
Advertisement
When i am running retropay for 3711 employees one of them errors out and the retropay by element process ends as Incomplete.
The following is the error for the assignment:
Error ORA-01427: single-row subquery returns more than one row has occurred in table pay_element_entries_f at location 4502
Cause: an oracle error has occurred. The failure was reported on table pay_element_entries_f at location
The log file for that it appears as follows:
Payroll: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
RETROELE module: RetroPay By Element
Current system time is 15-APR-2010 16:26:51
===============================================================================
Oracle Human Resources Generic Process
Started at : 15-APR-2010 16:26:51
Chunk Size : 20
Threads : 1
Logging Category :
User Messaging : N
Interlock : N
Trace : N
RR Buffer Size : 500
RRV Buffer Size : 500
Bal Buffer Size : 500
EE Buffer Size : 500
Logging Area :
Assignment ID for Start:
Assignment ID for End o:
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01427: single-row subquery returns more than one row
SQL_NO 4502
TABLE_NAME pay_element_entries_f
APP-PAY-06881: Error ORA-01427: single-row subquery returns more than one row
has occurred in table pay_element_entries_f at location 4502
Cause: an oracle error has occurred. The failure was reported on table pay_element_entries_f at location 4502 with the error text ORA-01427: single-row subquery returns more than one row
Action: Please contact your support representative.
Ended processing at : 15-APR-2010 21:50:07
Total Assignment count : 3711
Total Action count : 3711
Successfully processed : 3710
Skipped : 0
Unprocessed : 0
Errored : 1
===============================================================================
PL/SQL Output
PL/SQL Output
Executing request completion options...
------------- 1) PRINT   -------------
Printing output file.
Request ID : 595012      
Number of copies : 1      
Printer : noprint
APP-FND-00092: Routine PRINT_OUTPUT cannot find the file /data/oracle/PRD/inst/apps/PRD_hrmsprod/logs/appl/conc/out/o595012.out to print.
Check if the file exists. Check if the person who started the concurrent manager has read privileges on the directory and on the file. Contact your system administrator to assign read privileges.
Finished executing request completion options.
Concurrent request completed
Current system time is 15-APR-2010 21:50:08
Please can some one help me to troubleshoot so that i can rectify this error for 1 employee?
Edited by: 594647 on Apr 16, 2010 10:46 AM

The Best Answer

Advertisement
you can delete the retro assignment action for the moment, so you can launch the run for all employees.
As such, you have some more time to debug the issue.
I would activate some payroll tracing, so you know which fast formula throws this error. And then you should dig further, so you can identify the sql retruning multiple rows.
Or you do a sql*trace. That one will also point you to the offensive sql.
  • Retropay by element run Errors for one employee Update:10-11

    When i am running retropay for 3711 employees one of them errors out and the retropay by element process ends as Incomplete. The following is the error for the assignment: Error ORA-01427: single-row subquery returns more than one row has occurred in

  • Retropay by element run errors out Update:10-11

    I am getting the following error in the log file for the retropay by element run process: Payroll: Version : 12.0.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. RETROELE module: RetroPay By Element Current system time is 13-APR-

  • Details report for the retropay by element process Update:11-30

    I have ran retropay by element and i would like to create a detail report that will show me all the entries for a specific retropay element. For example i have Basic salary and the retro element for this is Basic Salary Arrears When the retropay by e

  • Error when runing retropay by element Update:11-30

    i processed 2 employees who are ex-employees as of last month but their Final close date have not been entered in the termination window. Now when i run the retropay by element on these 2 employees i am getting the following error for one of the empl

  • We are trying to install elements 11 but the program will not run error 213:11 Update:11-30

    we are trying to install elements 11 but the program will not run error 213:11http://helpx.adobe.com/creative-suite/kb/error-store-does-not-allow.htmlRead other 2 answers

  • Retropay by element....Right or Wrong Update:11-30

    Dear All Need some guidance and confirmation on retro pay steps I have tried to run retro pay. I followed setting up Retro Pay notifications Report document first as it was given in user guide. After that i setup retro pay by element. here are the st

  • Problem with Adobe Premiere Elements 10 : error DW046 Update:10-11

    Dear community members, I have bought Adobe Premiere Elements  10 and installed it from the DVDs on my MAC OSX10.5.8 on december 27, 2013 When creating a new project , I get the following message : following a serious error, Premiere Elements 10 must

  • XML document must have a top level element. Error processing resource Update:10-11

    Hi, I am trying to send a XML file to a web browser from a servlet. I read the contents of the XML file into a string and I am sending it to the brower. Before I do this I set the 'Content-type' header of the httpResponse to "application/xml" .

  • Converting Organizer Catalog created for version 8 to Elements 11 errors out. Help? Update:11-30

    The conversion of the Organizer Catalog version 8 to use with Elements 11 errors out. It asked me to repair the old catalog. I went back to 8, repaired it and optmized it as other articles mentioned, and still did  not work. would somebody please hel

  • Third party posting run error- Garnishments Update:11-30

    I am running third party remittance posting run for garnishments and getting thr following error for few employees. For perno/ seqno 4323 237 not in GRDOC. Please advice. How to fix this issue.See the following threads: How to Fetch a data from HR Ma