Calculate Assignment Budget Values (UK) for HeadCount get ORA-06502: PL/SQL: Numeric or Value Error (Doc ID 949879.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 11.5.10.2 and later
Information in this document applies to any platform.
*** checked for relevancy 13-Jan-2015 ***

Symptoms


When attempting to run the Calculate Assignment Budget Values (UK) concurrent program, the following error occurs:

ERROR
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: 'pqp_budget_maintenance.update_value_for_event_dates{10}: OR
A-06502: PL/SQL: numeric or value error'
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001: 'pqp_budget_maintenance.update_value_for_event_dates{10}:
ORA-06502: PL/SQL: numeric or value error'
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108
Cause: an oracle error has occurred. The failure was reported on table
pay_archive.process_employee at location 1108 with the error text ORA-20001:
'pqp_budget_maintenance.update_value_for_event_dates{10}: ORA-06502: PL/SQL: numeric or value error'
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
.




Additional information

 

 

Steps To Reproduce:
The issue can be reproduced at will with the following steps:


(implement Automatic Calculation of Assignment Budget Values as per <Note 854792.1>)


1. Run the Calculate Assignment Budget Values (UK) concurrent program with the following parameters



Cause

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 hundreds of Community platforms