Project/Task Validation error while resubmit the timecard with corrections. (Doc ID 1135823.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Time and Labor - Version 11.5.10.2 and later
Information in this document applies to any platform.
****Checked Currency on February 15, 2016****

Symptoms

When attempting to Submit a Projects and Payroll timecard with Change and Late Audit (CLA) turned on,
the following error occurs.

ERROR
-----------------------
Project/Task Validation error. Contact your support representative

This issue happens only while the scenario below..

a. CLA is ON with OTLR functionality enabled.
b. Time Entry Rules defined to validate the entries while submission.
c. Submit the Timecard in order it violates the Time Entry Rules.
d. Now make the corrections to the timecard and submit. Now you get the below errors....

1. Project/Task Validation Error
2. The OTLR error is: Unable to determine task_id from task_number: 19
3. Message not found Application: HXC. Message Name: HXC_CUI_ERROR. Tokens: CUR_ERROR_CODE = CUI_COMPONENT
4. oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502:
PL/SQL: numeric or value error
ORA-06512: at "APPS.HXC_ALIAS_UTILITY", line 907
ORA-06512: at "APPS.HXC_ALIAS_UTILITY", line 3578
ORA-06512: at "APPS.HXC_ALIAS_TRANSLATOR", line 151
ORA-06512: at "APPS.HXC_TIMECARD", line 28
ORA-06512: at "APPS.HXC_TIMECARD", line 473
ORA-06512: at "APPS.HXC_TIMECARD", line 847
ORA-06512: at line 2

Issue only occurs if the OTLR is enabled. If the OTLR is not enabled then it
works fine with out any issues.


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