SQL Language (MOSC)

MOSC Banner

ORA-01722 when passing date from Application

edited Sep 8, 2014 4:16AM in SQL Language (MOSC) 2 commentsAnswered ✓

Hi all.

I'm having an issue passing a date parameter from Oracle eBS via a concurrent request into an sql script within an XML Data Template.

The parameter in eBS has been setup with a Validation Value Set of: FND_STANDARD_DATE

The token is P_DATE.

When I look at the log, i see:

All Parameters: P_DATE="2014/09/05 00:00:00"

So, I am assuming that is the parameter and format being passed into my sql.

Within my XML Data Template, I have the following:

<parameter name="P_DATE" dataType="date"/>

and

AND to_char(creation_date, 'DD/MM/YYYY') = to_char(:p_date, 'DD/MM/YYYY')
Tagged:

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