Order Management - EBS (MOSC)

MOSC Banner

Passing date parameter

edited Mar 20, 2013 6:08PM in Order Management - EBS (MOSC) 4 commentsAnswered
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 :

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