Passing Dates to Oracle Reports

on

Problem

You want to pass a date parameter to Oracle reports, it's sometimes not clear what the current format mask settings are for an environment.

Solution


Set your concurrent program to use seed value set FND_STANDARD_DATE



Let your report accept a 20 character long field.



Now use standard function FND_CONC_DATE.STRING_TO_DATE(:p_begin_gl_date)
This, as the name suggests, will convert your parameter back to a date so that you can use it in your reports.

Acknowledgement

http://oracleappssolutiions.blogspot.co.uk/2014/08/how-to-handle-date-parameter-for-value.html
https://community.oracle.com/thread/2404083?tstart=0

Comments

Post a Comment