ORA-01722 when passing date from Application
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')