Getting "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" On Purchasing Timecard

(Doc ID 1400420.1)

Last updated on JULY 15, 2016

Applies to:

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

Symptoms

When attempting to save a purchasing timecard for a Contingent Worker,
the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error. Please contact the system administrator for assistance.

Java Stack trace shows:
oracle.apps.fnd.framework.OAException: 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-06512: at "APPS.PA_OTC_API", line 4395
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 774
ORA-06512: at "APPS.HXC_TIMECARD", line 183
ORA-06512: at "APPS.HXC_TIMECARD", line 482
ORA-06512: at "APPS.HXC_TIMECARD", line 1425
ORA-06512: at line 2

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Change Timecard Layout preference to Purchasing Timecard Layout
2. Create Timecard
3. Save Timecard errors with "You have encountered an unexpected error."

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