upgrade 11.5.10 - FND_USER_RESP_GROUPS

user476771 Sep 28, 2008 1:23 AM

We are upgrading our system to 11.5.10.

There is a report that is based on a custom folder that includes applysys.FND_USER_RESP_GROUPS.

In the upgraded version, the table is now a view with owner apps.

If we use the new view, we are getting a start_date of 01/01/1000 and a blank field for internal_location.

Has anyone encountered this and can give suggestions as to what we can do?

Thanks.
Leah

1. Re: upgrade 11.5.10 - FND_USER_RESP_GROUPS

Rod West Sep 29, 2008 2:22 AM (in response to user476771)

Hi,

In 11.5.10 the responsibilities user set up was moved to the workflow tables. The view FND_USER_RESP_GROUPS does not give the full details anymore.

You need to use either the FND_USER_RESP_GROUPS_ALL or FND_USER_RESP_GROUPS_DIRECT view.

Rod West
Like Show 0 Likes (0)

Actions
2. Re: upgrade 11.5.10 - FND_USER_RESP_GROUPS

user476771 Oct 2, 2008 2:18 AM (in response to Rod West)

Thank you very much. I used fnd_user_resp_groups_all.

Leah
Like Show 0 Likes (0)

Actions
3. Re: upgrade 11.5.10 - FND_USER_RESP_GROUPS

Yacouba Jun 20, 2013 8:30 AM (in response to user476771)

the FND_USER_RESP_GROUPS or FND_USER_RESP_GROUPS_ALL are stand for what exactely?
Like Show 0 Likes (0)

Actions
4. Re: upgrade 11.5.10 - FND_USER_RESP_GROUPS

Michael Armstrong-Smith Jun 20, 2013 3:05 PM (in response to Yacouba)

Hello
FND_USER_RESP_GROUPS_ALL lists all users and against all responsibilities they ever had even if they no longer have them.

FND_USER_RESP_GROUPS lists only the users who have current, active responsibilities

All you need to do is SELECT * from each and you will see the difference.

Best wishes
Michael
Like Show 0 Likes (0)

Actions
5. Re: upgrade 11.5.10 - FND_USER_RESP_GROUPS

Yacouba Jun 20, 2013 3:08 PM (in response to Michael Armstrong-Smith)

Thansk a lot MichaelArmstrong-Smith
Like Show 0 Likes (0)

Actions

Go to original post