New EBS Role in OBIEE
731932Feb 7 2011 — edited Apr 28 2011Hi all,
I have an odd situation. We are currently using EBS in our authentication process. When the user signs on the session initialization block goes out to EBS and pulls in the roles for the user. These roles are then used in the RPD and the webcat to determine what subject areas and dashboards the user has access to.
We recently set up a new group/role in EBS. We are trying to use the new group/role in OBIEE. However it isn't working. The error message says that they have an "Unresolved table: "Financials - AP Transactions W&R". (HY000)". This is the new subject area that corresponds with the group/role.
I have tried to bounce the BI and Presentation servers.
I have verified that the users are setup in EBS, and the group in question is coming into the RPD in the initialization block and is stored in the session variable.
I have verified that the group has access to the subject area in the RPD.
I have verified that the group has access to the dashboards in question in the webcat.
I have verified that the group has access to the shared folders where the dashboard reports are stored.
I can see the data fine using an older group/role.
I don't know where else to look. The group worked fine in the test environment, but when I moved to the production environment it quit working.
Help!
B