BI Publisher (MOSC)

MOSC Banner

Using a sequence in a Parameter(LOV) is giving error while scheduling a BIP report

edited Dec 4, 2013 2:41AM in BI Publisher (MOSC) 3 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center