Error "ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process :: Firing patc call" when submitting timecard

(Doc ID 2261769.1)

Last updated on MARCH 30, 2018

Applies to:

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

Symptoms

 Getting following error while submitting time cards 

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process :: Firing patc call. : ORA-20021: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PA_OTC_API", line 4442
ORA-06512: at line 2
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 346
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 733
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 854
ORA-06512: at "APPS.HXC_TIMECARD", line 232
ORA-06512: at "APPS.HXC_TIMECARD", line 531
ORA-06512: at "APPS.HXC_TIMECARD", line 1474
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