petwir Thanks. I understand that but our use case is a bit different here. Let me make it clear for you all.
Having said that we have one primary promptset placed under the prompts tab of the workflow, which will make the user to select the customer in drop down list(Image attached). Then the next prompt element loads up the existing environments for the selected customer dynamically. In short,the user will apparently select the customer and its source and target environments in the first promptset. Upon submission, the workflow gets started and then the promptset of the first task in the workflow is supposed to be popped up with the respective customer environment details(DB,APP, etc). In the task properties of the task, we have used SEC_SQL variables which will take inputs of the first promptset values,run the query and gives back the desired value. The second promptset is just like "verify and submit page",just to let the user to confirm the details(read-only)and then the job gets started from thereon This has been working good as expected, but I don't understand why it started behaving different by not showing up the second promptset. Unless we don't submit the second promptset, the job will never get started.
Hope you understand it better now and it seems like a bug based on my understanding. Because when I delete the first task in the workflow and placed it back in the same position and modified the promptset values in the task properties. Surprisingly,it started working fine after replacing the same object again. :p Sometimes simple workarounds will do the trick. I am curious to know the reason behind it.
https://us.v-cdn.net/5019921/uploads/editor/kz/508fg2iwggo0.jpg" width="904">https://us.v-cdn.net/5019921/uploads/editor/i3/uowmcp1nm1a1.jpg" width="894">
https://us.v-cdn.net/5019921/uploads/editor/i5/anv3qjepa5a8.jpg" width="1297">
Thanks,
Srujan.