Project/Task Validation error while resubmit the timecard with corrections.

Last updated on MARCH 08, 2017

Applies to:

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