Reporting - EBS (MOSC)

MOSC Banner

How to specify data parameter in my rdf for Oracle R12.2

edited Jun 27, 2025 8:18PM in Reporting - EBS (MOSC) 21 commentsAnswered

Good day ,

I have developed a report that extracts receipts between a FROM and a TO date. The line of code in my where statement is as follows:

WHERE TO_CHAR(RECEIPT_DATE, 'DD-MON-YYYY') >= trunc(FND_CONC_DATE.string_to_date(:p_from_date))

and TO_CHAR(RECEIPT_DATE, 'DD-MON-YYYY') <= trunc(FND_CONC_DATE.string_to_date(:p_to_date))

When I run the code in TOAD it returns data correctly. When I run the code out of the rdf it returns the data correctly. I enter the parameter values as 01-DEC-2006 to 31-DEC-2006 as an example.

The concurrent program parameters for date has been defined using FND_DATE_STANDARD

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