State Periodic Detail Reports For Multiple States Error ORA_20001 Ora-6512 at APPS.PAY_ARCHIVE, line 1234 ORA-6512 at line 3
(Doc ID 2792154.1)
Last updated on JUNE 10, 2024
Applies to:
Oracle HRMS (US) - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.7 version, State Quarterly Periodic Wage Listings (Enhanced) - SPWL
When attempting to submit the State Periodic Wage Listing (SPWL) the following error occurs:
ERROR
-----------------------
Error ORA_20001
Ora-6512 at APPS.PAY_ARCHIVE, line 1234
ORA-6512 at line 3
has occurred in table
pay_archive_process_employee at location 1108
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Submit the Single Request > Concurrent Program > State Periodic Wage Listing for multiple states
- One GRE in the State finishes without error, a Second GRE ends in error
- Navigate to View > Payroll Process Results window > query in the State Periodic Wage Listing > click on message
- Error observed for specific assignment(s)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |