APP-PAY-06881: Error SQL-02112: SELECT..INTO returns too many rows has occurred in table PER_TIME_PERIODS Error Is Displayed in Process Log After Running Payroll Processes
(Doc ID 973305.1)
Last updated on FEBRUARY 27, 2024
Applies to:
Oracle HRMS (UK) - Version 12.1.3 and laterOracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
When attempting to run a Payroll Process (for example Payroll Run concurrent program) the following error is displayed in the process log:
HR_6881_HRPROC_ORA_ERR
SQLERRMC SQL-02112: SELECT..INTO returns too many rows
SQL_NO <number>
TABLE_NAME PER_TIME_PERIODS
APP-PAY-06881: Error SQL-02112: SELECT..INTO returns too many rows has occurred in table PER_TIME_PERIODS at location <number>
SQLERRMC SQL-02112: SELECT..INTO returns too many rows
SQL_NO <number>
TABLE_NAME PER_TIME_PERIODS
APP-PAY-06881: Error SQL-02112: SELECT..INTO returns too many rows has occurred in table PER_TIME_PERIODS at location <number>
The issue can be reproduced at will with the following steps.
1. Under HRMS Manager Responsibility or equivalent.
2. Navigate to Processes and Reports > Submit Processes and Reports > Single Request > Run Payroll Run process for a specific payroll and pay period.
3. Observe that this is ending in error.
4. Click on View Log and observe above error.
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 |