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 JULY 15, 2021
Applies to:Oracle HRMS (US) - Version 12.2.7 and later
Information in this document applies to any platform.
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:
Ora-6512 at APPS.PAY_ARCHIVE, line 1234
ORA-6512 at line 3
has occurred in table
pay_archive_process_employee at location 1108
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)
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