Passing date parameter
Hi..
I'm a newbe using Oracle e bussiness suite 12 and developing report use Oracle Report Builder 10.1.2.0.2.
I have a problem with passing date parameter from oracle report builder to oracle application.
I set the user parameter :
name = date_start
data type = date
width = 11
input mask = DD MON RRRR
on sql query :
TRUNC(OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE) >= TO_DATE((:date_start),'DD-MM-YYYY HH24:MI:SS')
on application, i set the value to : FND_STANDARD_DATE
when i run it on my EBS application, i entry : 01-JAN-2013
but the result was "Completed error"
and the error log was :
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
0