OTL: Error "ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process :: Firing patc call. : ORA-20021: ORA-20927" When Using HXC_TIMESTORE_DEPOSIT API For Loading The Timecard (Doc ID 2962947.1)

Last updated on JULY 28, 2023

Applies to:

Symptoms

When executing the API "HXC_TIMESTORE_DEPOSIT API" to create time card, the below error is encountered.

Error Message:
---------------------------
ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process :: Firing patc call. : ORA-20021: ORA-20927:
ORA-06512: at "APPS.HXC_TIMESTORE_DEPOSIT", line 2623
ORA-06512: at "APPS.PA_OTC_API", line 4760
ORA-06512: at line 2
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 346
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 779
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 1044

Step to Reproduce:
---------------------
The issue can be reproduced at will with the following steps:
1) Execute hxc_timestore_deposit.create_timecard_bb
2) Get the error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.