Thanks for your reply.
There might be too many parameters so the requirements is to have some type of multi selection (a list of all the parameters where the user can search and pick the ones to be included to the parameter).
I would think that there is a way..
Just a thought..
Whenever you run the report, store all the parameters in "temp table". Pass that param_id to the report that you are calling.
In the report get the parameters from the temp table or table that you stored.
Sample Param table:
param_id param_name value
1 start_date jan 1 2012
1 end_date dec 31 2012
1 state_code AL
1 state_code CA
Interesting thought. Thanks!
I actually just found out this article: http://oraclecafe.wordpress.com/2012/09/16/multiple-value-select-in-oracle-apps-concurrent-program-parameter/
I think that Oracle should had added this functionality to concurrent requests out of the box, specially with all the direction of moving EBS transactional reporting to BI Publisher.