Clicking On Attachment Link In SSHR Email Notification Gives Error: ORA-01840: input value not long enough for date format (Doc ID 2583404.1)

Last updated on MAY 24, 2024

Applies to:

Symptoms

On : 12.2 HRMS RUP10 version, Workflow,Approval,Common Funct

When attempting to click on the Attachment links for any HRSSA related transactions from email notifications,
the following error occurs.

ERROR
-----------------------
## Detail 0 ##
java.sql.SQLDataException: ORA-01840: input value not long enough for date format
ORA-06512: at "APPS.HR_UTIL_MISC_SS", line 1172
ORA-06512: at line 1

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit any HR related transaction that needs approval with attachment (Example: Submit a Leave of Absence)
2. Approver receives an email and opens it.
3. In the Notification there is a Attachment link with file name, click on it shows ORA-06512 Error.

IMPORTANT NOTE:
1. Open the same notification from Worklists using Oracle Application Home page - No Error.
2. Issue happens for all HRSSA transaction while opening the attachment from email.
3. When the approver approves the notification the transaction gets committed without any issue , its only while opening the attachment from email gives error.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.