Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
Payroll Archiver Process Error - Printable Version

+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Human Resources (http://www.oraerp.com/forum-4.html)
+---- Thread: Payroll Archiver Process Error (/thread-71110.html)



Payroll Archiver Process Error - Archita Jartin - 07-24-2014

Hi
I am getting the following Error when I run the Payroll Archiver Process. The steps that I have followed are as follows:
Ran a Quick Pay for one employee (Successful)
Ran the Pre-Payments (Success)
Ran the Payroll Archiver (Error)
This is what I get in Log file:
Payroll: Version : 12.0.0
Copyright © 1979, 1999, Oracle Corporation. All rights reserved.
MX_PS_ARCHIVE module: Payroll Archiver
+---------------------------------------------------------------------------+
Current system time is 07-APR-2014 14:48:44
+---------------------------------------------------------------------------+
===============================================================================
Oracle Human Resources Generic Process
Started at : 07-APR-2014 14:47:37
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:

-------------------------------------------------------------------------
PL/SQL Output
-------------------------------------------------------------------------
-------------------------------------------------------------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found
ORA-06512: at "APPS.HR_DYNSQL", line 1888
ORA-06512: at "APPS.HR_DYNSQL", line 2415
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 287
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 593
ORA-06512: at line 1

SQL_NO 1642
TABLE_NAME pay_population_ranges_pkg.perform_range_creation
APP-PAY-06881: Error ORA-01403: no data found
ORA-06512: at "APPS.HR_DYNSQL", line 1888
ORA-06512: at "APPS.HR_DYNSQL", line 2415
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 287
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 593
ORA-06512: at line 1
has occurred in table pay_population_ranges_pkg.perform_range_creation at location 1642

Cause: an oracle error has occurred. The failure was reported on table pay_population_ranges_pkg.perform_range_creation at location 1642 with the error text ORA-01403: no data found
ORA-06512: at "APPS.HR_DYNSQL", line 1888
ORA-06512: at "APPS.HR_DYNSQL", line 2415
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 287
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 593
ORA-06512: at line 1
.

Action: Please contact your support representative.
+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
0


Finished executing request completion options.
Concurrent program returned no reason for failure.

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Payroll Archiver" has completed with error.
Could you please assist, since I noticed that there is one similar or same problem with no correct solution to it.
Kind regards,


RE: Payroll Archiver Process Error - Archita Jartin - 07-28-2014

Just to update, we have logged SR to Oracle Support, still in progress.
thanks