Hani wrote:Please post the details of the application release, database version and OS.
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.
Hani wrote:Can you please post the steps you followed in details?
Application release: 12.1.3
Yes i try to do it from APPS user, but after create alert and do action its give me ORA-04098