fnd_user_resp_groups
We upgraded our system to 11.5.10.
With your previous help, I changed the table applsys.fnd_user_resp_groups to apps.fnd_user_resp_groups_all in sql statements.
We have a report that is based on three tables. One of them is the above table. Therefore, I defined a new folder in the administrator that is based on apps.fnd_user_resp_groups_all and applied the necessary joins. However, I cannot just change the fields and conditions in the report with the new table since there is an error because of the two joins (ambiguity). If I remove the joins of the old table then I cannot open the report.
Is there any way that I can avoid rewriting the whole report? In other words, ideally what I would like to do is to go into the report and change each condition, one by one, to use the same field from the new table and also change the old data point field in the report to the new one. In this way I can leave most of the report the way it is and just change what must be changed.
Is this possible?
Thanks.
Leah