I'm submitting a concurrent program using FND_REQUEST.SUBMIT_REQUEST in pl/sql.
The parameters of the concurrent program are attached to value sets and have default values.
I want to give the values of those parameters alone, which do not have a default value while submitting the request from pl/sql.
That does not seem to work. Is there any way I can get the default values of the parameters to kick in, when I submit from pl/sql?
Edited by: user451773 on Dec 3, 2012 5:05 AM
Edited by: user451773 on Dec 3, 2012 5:06 AM
You will have to code a "pre-stage" for this..... aka.... a function that will call your conc.req.
the FND_REQUEST.SUBMIT_REQUEST will require you to provide all parameters needed to start the conc.req. This is also what is happening when you start it via forms. So, you will have to code something that checks which parameters are given by you and for the ones not given check the LOV configuration and query the default value.
This is how you can resolve this. It will need some additional coding.
So, that would mean, I need to pick up the default values by querying the FND tables. I understand there's no easy way to do it, as in a FND function.
Also, how about if I want to use the value set attached to a parameter for deriving the ID value of a parameter (if I'm passing only the meaning), is there any easy way to do that?
Thanks a lot!
One last related question:
Some parameters have a default value like 'SELECT entity_name, entity_id FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$FLEX$.FND_MO_REPORTING_LEVEL'.
In this case, the parameter in question is corresponding to the 'entity_name' column in the above select statement. (i.e. varchar2)
So, can I assume that the second column selected (i.e. entity_id) would correspond to the ID column value of the valueset attached to the parameter?
My doubt basically is, how can we assign a select statement, selecting two different values, as the default value for one parameter.
Please let me know if you need further details on this example.