There is strange problem.I am using cascading prompt.
When i click values for first prompt it shows some default values (which was selected for last time login for other user) for second prompt.
It may be undesirable in your case, but not wrong. It’s by design. Default behavior is that the LOV (which is stored locally on the workstation) retains its contents between uses, saving the time and database resources required to refresh the LOV. You have two choices … train your users to refresh it themselves as needed, or change the properties in Designer so that the LOV is automatically refreshed each time it is used.