Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Thread Rating:
  • 18 Vote(s) - 3.83 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Payroll Archiver Process Error
#1
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,
Reply
Thanks given by:
#2
Just to update, we have logged SR to Oracle Support, still in progress.
thanks
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Oracle Payroll Processes and Their Relevant Tables fanni339 0 1,169 03-25-2015, 02:47 PM
Last Post: fanni339
  Oracle iExpense Account Error in workflow James Robert 1 1,076 01-27-2015, 06:41 PM
Last Post: Justen Kegan
  What are different ways of correction of mistakes in Payroll Run? fanni339 0 646 08-09-2014, 01:37 AM
Last Post: fanni339
  Leave Process, attachment mandatory Pryia Rai 0 810 06-04-2014, 04:28 PM
Last Post: Pryia Rai
  Want to close several process periods at a stretch uniquenaga 0 594 04-10-2014, 04:21 PM
Last Post: uniquenaga



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!