Project/Task Validation error while resubmit the timecard with corrections.
Last updated on MARCH 08, 2017
Applies to:Oracle Time and Labor - Version 22.214.171.124 and later
Information in this document applies to any platform.
****Checked Currency on February 15, 2016****
When attempting to Submit a Projects and Payroll timecard with Change and Late Audit (CLA) turned on,
the following error occurs.
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.
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