Dashboard Prompt:filter code is unchecked and set up the Limit Value by, the selection does not work

Cecilia Huang

I am having an issue with the Dashboard Prompt. For example, if I set up a Project Manager (PM) prompt and uncheck the filter code on the More tab in the Options section, it is supposed to pass the PM's name (not ID). However, after I unchecked the filter code and set up the limit value by the Profit Center, the selection of the PM prompt defaulted to the "All Column Values" instead of selective values. The only way to make it work is to check on the Filter code or clear the Limit value By. It looked like the combination of the unchecked Filter code and the Limit Value was causing the issue. I checked the log file. The log file showed the where clause as PM_Employee_number = Selective PM Name. It did not switch to PM_Name when the filter code was unchecked. I have logged an SR with Oracle. No solution yet