Monday 14 November 2016

ORA-01861: literal does not match format string

While developing XML Publisher Reports, when parameters are selected as FND_STANDARD_DATE, when used this in Data Template, it is converted as String, so we have to convert it back to date format.

you may use fnd_date.canonical_to_date(:xx_param) 


No comments:

Post a Comment