I have a report that run succesfully with or without parameters filled in 6i. In Oracle applications the report runs successfully if the parameters were not filled and gives no data if any of the parameters were filled.
Please notice that the same value sets are used in other reports successfully.
Any Idea?
is the value set used in ur custom report is predefined?
if it so, can u check with the "ID" under TABLE value set.
check whether any values is entered in the "ID" if it so, then ur parameter in apps, will return only the value that will be generated thru "ID" and not thru "VALUE"