Not Able To Save Changes For Mid Pay Period Hires In Timekeeper ORA-20001: HXC_NO_TIMECARD_ID: N, TIMECARD_ID, -3

(Doc ID 312824.1)

Last updated on APRIL 17, 2018

Applies to:

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

Symptoms

 

You are experiencing an error when trying to enter time for a new hire, who was hired in the middle of a pay period in Timekeeper.

Person Hire Date: 16-May-2005
Period Start Date: 14-May-2005
Period End Date:   27-May-2005

Error:

ORA-20001: HXC_NO_TIMECARD_ID: N, TIMECARD_ID, -3
ORA-06512: at "APPS.FND_MESSAGE", line 126
ORA-06512: at "APPS.HXC_TIMECARD_SUMMARY_PKG", line 339
ORA-06512: at "APPS.HXC_TIMECARD_SUMMARY_API", line 145
ORA-06512: at "APPS.HXC_TIMEKEEPER", line 301
ORA-06512: at "APPS.HXC_TIMEKEEPER_PROCESS", line 4893

The timecard already existed because you created it via your own API which calls the autogen pkg.

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