Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: Payroll Archiver Process Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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,
Just to update, we have logged SR to Oracle Support, still in progress.
thanks