Getting "ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process :: Firing patc call. : ORA-20021: ORA-06508: PL/SQL: could not find program unit being called" on Submitting Projects Timecard (Doc ID 1402344.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms


On 12.1.3 When submitting Projects Timecard,  the following error occurs.

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process :: Firing patc call. : ORA-20021: ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "APPS.PA_OTC_API", line 4394
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 651
ORA-06512: at "APPS.HXC_TIMECARD", line 1300
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