My Oracle Support Banner

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

Last updated on FEBRUARY 17, 2019

Applies to:

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


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.

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


To view full details, 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 a vibrant support community of peers and Oracle experts.