When user tried to click prompt table,it showing No matching values were found,However even if we given proper prompt table.For example if you give DEPT_TBL as prompt table for department field its showing No matching values were found.Seems to be prompt table issue.But actually its related to component buffer.
Solution : Actually for the delivered prompts the particular page has field called SETID which gets loaded into component buffer when user selected it.Based on the SETID the prompt table values get populated.This is because SETID is a higher level key field in tables like DEPT_TBL, LOCTATION_TBL etc.Since we trying to access second level key field which is department or location we have to specify higher level key.Once it got loaded into component buffer,it will display the values for prompt table based on given SETID.So keeping the SETID field in the page will help to display the prompt values.
