8 Replies Latest reply: Feb 4, 2013 1:10 AM by Hani RSS

    Allow schema HR to select from fnd_profile_option_values

    Hani
      Hi

      I try to create alert on table that already on HR schema, the problem is when i create the alert it will create invalid trigger on database because HR schema not allow to select from fnd_profile_option_values table, i try to give permission from APPSYS schema to HR schema and create synonym but also the user HR not allow to create synonym, so what is the best scenario must do when create alert reflect table not on APPS schema.

      Thanks