Getting "ORA-06502: PL/SQL: numeric or value error" on Creating a Timecard for Contingent Worker (Doc ID 1271154.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On 12.0.6, getting the following error when trying to submit a Projects timecard:

ERROR
----------
java.sql.SQLException: ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process :: Check for quantity being negative. : ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-01403: no data found
ORA-06512: at "APPS.PA_OTC_API", line 4383
ORA-06512: at line 2
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 344
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 653
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 858
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 909
ORA-06512: at "APPS.HXC_TIMECARD", line 518
ORA-06512: at "APPS.HXC_TIMECARD", line 839
ORA-06512: at line 2

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