My Oracle Support Banner

Consolidated Patch For Mass Time Upload Functionality Using Time Upload Standard Menu (Doc ID 3040738.1)

Last updated on AUGUST 12, 2024

Applies to:

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

Symptoms

Below issue/errors occurred while using the 'Time Upload Standard Menu' for mass timecard upload.

ERROR
-----------------------
Validating timecard for xxxxxx between DD-MON-YY and DD-MON-YY
Date : DD-MON-YY, Validation failed for - Task : xxxx Error - ORA-00904: "TASKNAME": invalid identifier
Validation failed

 

ERROR
-----------------------
Exception Details.
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 4760
ORA-06512: at line 2
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 353
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 941
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 1122
ORA-06512: at "APPS.HXC_TIMECARD", line 346
ORA-06512: at "APPS.HXC_TIMECARD", line 700
ORA-06512: at "APPS.HXC_TIMECARD", line 1694
ORA-06512: at line 2

 

No provision to enter Contingent Worker Number for loading the timecard data.

Steps:
-------
1. Login to concerned Time entry responsibility

2. Navigate to Time Upload Standard Menu

3. Upload Data file and Initiate Load

4. See the issue/errors

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References

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