Hi Venkat, Please find the query related to division parameter and I want to know whether administrator as user must be there in that related DB or not necessary to access lov values. SELECT DISTINCT MER.DIVISION_NAME FROM SEC_USER SU, SEC_USER_GROUP SG, FILTER_GROUP_MERCH FGM, MERCHANDISE_HIER_V MER WHERE SU.USER_SEQ =…

Hi Venkat, I'm providing the screenshot for your reference when I select division it is not displaying any values and the same happening for the rest of parameters. BI Version: Oracle BI Publisher 11.1.1.9.0 Thank you, Sonu Upadhya.

Hi Sandeep, Actually for that parameter i'm passing as (:xdo_user_name) to access for the particular users.But I want to know whether the administrator should be there in related DB as application_user so as to display lov_values for admin user. Thanks, ---Sonu

Hi Kavitha, Thanks for the reply ! We have raised an SR to support, it seems to be some bundle patches are missing. We are working on it. Thank you so much for your inputs.