This discussion is archived
8 Replies Latest reply: Feb 3, 2013 11:10 PM by Hani RSS

Allow schema HR to select from fnd_profile_option_values

Hani Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points