Stat web client is not display my approvals drop down list for a selected user. The interesting thing is the same user can go to File | Status transfer approvals to do my approval.
There was a trailing space for the STATUSER (USERID column) and CSR_WF_TRNSFR_APPR_LIST (APPROVER_ID column)
1. Query for SELECT * FROM STAT.STATUSER
WHERE USERID='ENTER_PROBLEM_USER_ID'
Check to see if there is trailing space in the USERID column. If there is, then you need to remove the trailing space
2. Query for SELECT * FROM STAT.CSR_WF_TRNSFR_APPR_LIST
WHERE APPROVER_ID='ENTER_PROBLEM_USER_ID'
Check to see if there is trailing space in the APPROVER_ID column. If there is, then you need to remove the trailing space
