Technology Stack - EBS (MOSC)

MOSC Banner

Format mask Issue with Date Parameter in Reports

edited Jun 26, 2013 10:07PM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓
Hello friends,

I have a PO date from and PO Date to parameters in my report.the validation is FND_STANDARD_DATE.

I have a condition in my report which is

AND trunc(h.creation_date,'MON-DD-RR HH24:MI:SS') between nvl(:po_date_from ,trunc(h.creation_date,'MON-DD-RR HH24:MI:SS')) and nvl(:po_date_to,trunc(h.creation_date,'MON-DD-RR HH24:MI:SS'))

Iam picking Creation_date from po_headers_all h.my report builder parameters has date datatype and format mask as MON-DD-RR HH24:MI:SS.

The report is erroring out with the following message.

Kindly Advise

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