Date tracked Assignment Change creating Timecard Error: HXC_HXT_DEP_VAL_ORAERR. Tokens: ERROR = ORA-01722: invalid number (Doc ID 1466836.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

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

Symptoms

When attempting to create a timecard utilizing seeded Self Service Responsibility
the following error occurs.

ERROR
-----------------------
 Message not found. Application: , Message Name: HXC_HXT_DEP_VAL_ORAERR. Tokens: ERROR = ORA-01722: invalid number;


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Moved employee from one payroll to another
2. Date tracked back to 05-March-2012
3. Reason: new payroll begins on March 5, 2012
4. Utilize Assignment form and changed payroll hit update
5. Utilize the seeded Self Service Responsibility
6. Create timecard
7. Receive error: Message not found. Application: , Message Name: HXC_HXT_DEP_VAL_ORAERR. Tokens: ERROR = ORA-01722: invalid number;

Changes

 This issue only happens after a date track change has been made to an employee and only affects within 24 hours from the change.

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