EBS Customizations (MOSC)

MOSC Banner

ORA-01830 after changing date format to yyyy-mmm-dd

edited Mar 22, 2012 5:14AM in EBS Customizations (MOSC) 2 commentsAnswered
I changed the date format at the user level on the user preferences page.

The default was dd-mmm-yyyy and it is now yyyy-mmm-dd.

Since then, I get the following error when my one of my custom OAF pages tries to load (many other custom pages work fine as do Oracle-supplied pages):

ORA-01830: date format picture ends before converting entire input string

Through debug I have confirmed that the error occurs when the vo.initquery is executed.

I tried the following already and got the same result:
making the data type on the VO columns = 'Date'
making the data type on the VO columns = 'String'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center