Why is the element LOV empty on the element entries form when using a Secure User

If you have run all the secure user processes and the secure user can access appropriate employees but when they try to access the LOV of the element entries form, there is nothing in the LOV.

Have you created synonyms for each secure user for the HR_LOOKUPS object. You need to  drop the synonym for each secure user. You should now be able to access the elements LOV.

The following tables are accessed by the element entries LOV (sql stmt):

• PAY_ELE_CLASSIFICATION_RULES
• PAY_ELEMENT_SETS,
• PAY_ELEMENT_TYPE_RULES
• PAY_INPUT_VALUES_F
• HR_LOOKUPS
• PAY_PAYWSMEE_ELEMENTS_LOV

Verify that the secure has grants to all these objects.

select * from dba_tab_privs where table_name =
and object_type = 'SYNONYM' ;

In this case, there was a public synonym for HR_LOOKUPS but also had individual synonyms owned by each of the secure users (not HR_SECURE_USER but the secure user names created). That means that the system was using the synonym, within their own schema not the public one.

After dropping the synonym you can now access the LOV;

SQLPLUS> drop synonym schema.synonym name