Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

element entries form LOV Secure user
0
Posted

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

0

AnswerIf you have run all the secure user processes and the secure user can access appropriate employees but when they try to access the LOV off 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 = Verify that a public synonym exists for the object select * from dba_objects where object_name = and object_type = ‘SYNONYM’ ; In this case, there was a public synonym for HR_LOOKUPSbut also had individual synonyms owned by each of the secure users (not HR_SECURE_USER

Related Questions

  • Is there a secure form within Wolfhome that I can use to purchase and sell Wolfhome Deltas to another Wolfhome user?
  • What happens when the user logs in using the IndustrialSQL In element?
  • Does the end user have to complete the EUU form in English?
  • What is your question?

    *Sadly, we had to bring back ads too. Hopefully more targeted.

    Experts123