My Oracle Support Banner

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 DECEMBER 03, 2019

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

To view full details, 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 a vibrant support community of peers and Oracle experts.