Application Diagnostic For Hxt Errors (Doc ID 1348567.1)

Last updated on DECEMBER 20, 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 view a report on the View Execution Results form,
the following error occurs.


Preference Hierarchy Values
EXCEPTION - ORA-01843:
not a valid month
ORA-06512: at line 1
has been raised when calling method
'OTLPersonInfo.displayPreferencefHierarchyValues' when executing
'hxc_preference_evaluation.set_resource_preferences'
java.sql.SQLDataException: ORA-01843: not a valid month
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.hxc.diag.setup.OTLPersonInfo.displayPreferenceHierarchyValues(OTLPersonInfo.java:1096)
at oracle.apps.hxc.diag.setup.OTLPersonInfo.runSupportTest(OTLPersonInfo.java:226)
at oracle.apps.jtf.regress.qatool.base.DiagBase.runTest(DiagBase.java:373)
at oracle.apps.fnd.oam.diagnostics.exec.LegacyJavaTestExecution.runTest(LegacyJavaTestExecution.java:147)
at oracle.apps.fnd.oam.diagnostics.exec.LegacyJavaTestExecution.execute(LegacyJavaTestExecution.java:83)
at oracle.apps.fnd.oam.diagnostics.exec.WorkerThread.run(WorkerThread.java:49)
at java.lang.Thread.run(Thread.java:619)
ACTION - Please log an iTAR (Service Request) for product "Support Diagnostics Project" (ID=1332) to notify support about this issue
Hours Types on Timecard [Top]
ERROR - No default value is defined for preference alternate name
ACTION - Please refer to Oracle Applications online help to define a default value for preference alternate name




The issue can be reproduced at will with the following steps:
1. Application Diagnostics Responsibility
2. Navigate to Diagnose link
3. On the Diagnose Tests formHit the Select Application button
4. Search by: Application Short Name: %HXT%
5. Check the Select box
6. Hit the Select button
7. Click on the Setup (+)
8. Select the Person box to the left
9. Hit the Execute button
10. Request Name: DiagnosticTestForOracle_06022011
11. Responsibility ID: 50460
12. Business Group ID: 81
13. Employee Number: 3881
14. Press the Submit button
15. Page: View Execution Results DiagnosticTestForOracle_06022011
16. Hit the Refresh button
17. Click the icon under View Report to view it.
18. Receive error


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