Hi All,
I added a Dashboard Prompt in OTBI with Job Codes like LK00259, LK00258 and So on. In the LOV I am seeing the NULL in the choice List along with Job Codes. Right now I am using SQL Result and case statement code in SQL Result. Kindly need help how to remove the NULL values in OTBI Dashboard Prompt.