5 Replies Latest reply on Feb 14, 2017 7:00 AM by 2725705

OBIEE 12c Act As functionality while integrated with EBS

ather.shaikh Feb 6, 2017 8:23 AM

Dear All,

I am using Oracle EBS and OBIEE 12c Integration, So, I have users login through EBS and grant access for dashboards and analysis using the Roles and Responsibilities of EBS.

All this is working very pefect.

Now, we have further requirement for some users that can access dashboards of limited level by using ACT AS functionality.

I have reached to the point where a user can see the list of users he/she can ACT AS, but when we click on any user from the list, it does not ACT as that user. It keeps the same user login for the first time.

Any idea or suggestion.

Thanks,

1. Re: OBIEE 12c Act As functionality while integrated with EBS

John_K Feb 6, 2017 12:03 PM (in response to ather.shaikh)

I don't believe Act As is supported when using EBS authentication, primarily because you would need to go back and reinitialize your EBS session. I.e. you might have an initblock which does:

Select organization_id from hr_organization_units.

As that is a secure view, it is dependent on your EBS context (i.e. your user_id, resp_id, and so on). So you couldn't run that "Acting As" someone else.
Like Show 0 Likes(0)

Actions
2. Re: OBIEE 12c Act As functionality while integrated with EBS

ather.shaikh Feb 7, 2017 5:59 AM (in response to ather.shaikh)

Hi ORA-01033,

I understand that and that's why i raised this question on the community.
We need to implement only 4 or 5 user for this. is there any we can do this.

Thanks,
Ather
Like Show 0 Likes(0)

Actions
3. Re: OBIEE 12c Act As functionality while integrated with EBS

2725705 Feb 13, 2017 10:01 AM (in response to ather.shaikh)

Hello,

We are getting issue while accessing the OBIEE from EBS . we are getting Obiee login page instead of direct dashboard page.
Could you please share your experience on this issue
Like Show 0 Likes(0)

Actions
4. Re: OBIEE 12c Act As functionality while integrated with EBS

ather.shaikh Feb 14, 2017 6:36 AM (in response to 2725705)

What i understand that you did not set the configuration files updated.
authenticationschema.xml should have these
<AuthenticationSchema name="EBS-ICX"
<SchemaKeyVariable source="cookie" forceValue=”EBS-ICX”
<RequestVariable source="cookie" type="auth" nameInSource="DEV" biVariableName="NQ_SESSION.ICX_SESSION_COOKIE" />
if it is OBIEE 12c then you have mentioned following as well.
<RequestVariable source="constant" type="auth" nameInSource="ssi" biVariableName="NQ_SESSION.SERVICEINSTANCEKEY" />
Like Show 0 Likes(0)

Actions
5. Re: OBIEE 12c Act As functionality while integrated with EBS

2725705 Feb 14, 2017 7:00 AM (in response to ather.shaikh)

Hi Shaikh,

We have followed all the steps and modified config files as per Oracle documents, what ever steps you mentioned above all are taken care of.
Please let me know any other solution
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.