Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

fnd_user_resp_groups

user476771Dec 2 2008 — edited Dec 3 2008
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2008
Added on Dec 2 2008
3 comments
1,313 views