Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, 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 and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 27 Vote(s) - 3.48 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Payroll Archiver Process Error
07-24-2014, 03:20 AM,
#1
Payroll Archiver Process Error
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
07-28-2014, 03:39 AM,
#2
RE: Payroll Archiver Process Error
Just to update, we have logged SR to Oracle Support, still in progress.
thanks
Reply


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



Users browsing this thread: 3 Guest(s)