R12: OIE: Employee Cannot Open FYI Notification When His Approval Notification is Transferred to a Delegate (Doc ID 1288946.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
FYI Notification
Approval Notification
Delegate
Error java.sql.SQLException: Initialization failed

Symptoms

When an approver has a vacation rule defined and an associated employee submits expense report, the approval notification gets transferred to another approver (delegate).  The employee then receives an OIE_PREPARER_TRANSFER workflow notification. When the employee attempts to open the notification the following error occurs.


Error:
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: Initialization failed
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.ap.oie.utility.OIEUtil.stringToNumber(OIEUtil.java:425)
## Detail 0 ##
java.sql.SQLException: Initialization failed
at oracle.sql.NUMBER.<init>(NUMBER.java:298)
at oracle.jbo.domain.Number.<init>(Number.java:316)
at oracle.apps.ap.oie.utility.OIEUtil.stringToNumber(OIEUtil.java:420)

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