When User Clicks On Worklist Notification Error "ORA-01840: input value not long enough" (Doc ID 2038957.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Self-Service Human Resources - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.
"ORA-01840: input value not long enough"

"ORA-06508: PL/SQL: could not find program unit being called"

Symptoms



When attempting to open any For Your Information (FYI) Notification or For Action Notification (FYA) from the Work List or Actions awaiting Your Attention function the following error occurs.

The item can be a new transaction or old transaction which was created prior to RUP 8

For FYI notifications

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

 

Exception Message:

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLDataException: ORA-01840: input value not long enough for date format
ORA-06512: at "APPS.HR_UTIL_MISC_SS", line 1169
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.per.common.CommonUtils.setEffectiveDate(CommonUtils.java:377)
at oracle.apps.per.selfservice.review.webui.NtfReviewCO.processRequest(NtfReviewCO.java:153)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)

## Detail 0 ##
java.sql.SQLDataException: ORA-01840: input value not long enough for date format
ORA-06512: at "APPS.HR_UTIL_MISC_SS", line 1169
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)

 


For FYA notifications:

The changes were not applied because ORA-06508: PL/SQL: could not find program unit being called

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Employee logs into the application.
2. Open up any Notification from their worklist or opens an item from All Actions awaiting your Attention
3. Error message is generated

 

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