I have a requirement Like this
1)Need to add new parameter to select calendar or fiscal
2)If you were running for date 8-april-2016
if the user selects calendar - you want to use april 1 to april 30 to return data
if the user selects fiscal - you want to use march 28 may 1 (period APR-16) to return data.
we are using Oracle application 12.2.1 .
here what need to do.