My Oracle Support Banner

Java Error When Click Create Expense Report Button In Internet Expenses (after inadvertently setting profile option, OIE: Grace Period to Yes) (Doc ID 2196055.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.


click Create Expense report button and receive the error

"...Exception Details.
oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at
...## Detail 0 ##
java.lang.NullPointerException at
uctureCode( at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at

Note, at Site level, a user inadvertently set OIE:Grace Period to 'yes'
instead of a numeric value. When changing OIE:Grace Period back to numeric
value - the error no longer happens.

Client observed " is interesting that there is no value set or
validation on this profile option and it allows a text/alpha value to be
entered in what should be a numeric only field..."

Oracle Support set OIE:Grace Period to 'yes' and encountered the error
"..Exception Details. oracle.apps.fnd.framework.OAException:
oracle.jbo.SQLStmtException: JBO-27122:..
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow..."


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.