My Oracle Support Banner

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

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.