Canadian Legislation, Prepayment Error : Ora-06512: À ''Apps.Hr_pre_pay'', Ligne 2871 Ora-06512
(Doc ID 396581.1)
Last updated on JULY 07, 2020
Applies to:
Oracle HRMS (Canada) - Version 11.5.10.2 and laterInformation in this document applies to any platform.
ConcurrentProgram:QPPREPAY - QuickPay Pre-payment
ConcurrentProgram:PREPAY - PrePayments
Symptoms
When attempting to Run the prepayments receiving an error message the following error occurs.
Only happening to two assignments. (Using Multi assignment and Multi GRE)
The following Error is seen:
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_GENERAL", line 426
ORA-06512: at "APPS.HR_PRE_PAY", line 3112
ORA-06512: at "APPS.HR_PRE_PAY", line 3201
ORA-06512: at line 3
In English:
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_GENERAL", line 426
ORA-06512: at "APPS.HR_PRE_PAY", line 3112
ORA-06512: at "APPS.HR_PRE_PAY", line 3201
ORA-06512: at line 3
SQL_NO 1122
TABLE_NAME hr_pre_pay.do_prepayment
APP-PAY-06881: Error ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_GENERAL", line 426
ORA-06512: at "APPS.HR_PRE_PAY", line 3112
ORA-06512: at "APPS.HR_PRE_PAY", line 3201
ORA-06512: at line 3
has occurred in table hr_pre_pay.do_prepayment at location 1122
Cause: an oracle error has occurred. The failure was reported on table hr_pre_pay.do_prepayment at location 1122 with the error text ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_GENERAL", line 426
ORA-06512: at "APPS.HR_PRE_PAY", line 3112
ORA-06512: at "APPS.HR_PRE_PAY", line 3201
ORA-06512: at line 3
.
Action: Please contact your support representative.
In Canadian French (FRC):
An error ORA-06502: PL/SQL : Numeric or value error
ORA-06512: at "APPS.HR_GENERAL", line 421
ORA-06512: at "APPS.HR_PRE_PAY", line 2871
ORA-06512: at "APPS.HR_PRE_PAY", line 2960
ORA-06512: at line 3
Une erreur ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur
ORA-06512: à "APPS.HR_GENERAL", ligne 421
ORA-06512: à "APPS.HR_PRE_PAY", ligne 2871
ORA-06512: à "APPS.HR_PRE_PAY", ligne 2960
ORA-06512: à ligne 3
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Submit payroll it processes fine
- Submit pre-payments it ends in error.
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 |
Cause |
Solution |
References |