Using a sequence in a Parameter(LOV) is giving error while scheduling a BIP report
Hi,We are using a sequence in a parameter (list of values select statement) to get an unique id, it is further passed as a value to my package.function.
When we are scheduling the Report to execute immediately, it is throwing error as " oracle.xdo.servlet.data.DataException: Invalid parameters requested."
When we check the Log file, we found that two values were generated for the same Parameter ( Example : 100 when submitting and 101 while job started executing)
We think that it is trying to validate the newly generated value with the submitted value and hence it is raising the error.
0