My Oracle Support Banner

Canadian Legislation, Prepayment Error : Ora-06512: À ''Apps.Hr_pre_pay'', Ligne 2871 Ora-06512 (Doc ID 396581.1)

Last updated on MAY 16, 2018

Applies to:

Oracle HRMS (Canada) - Version 11.5.10.2 and later
Information 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:

  1. Submit payroll it processes fine
  2. Submit pre-payments it ends in 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.