Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c Act As functionality while integrated with EBS

Received Response
21
Views
5
Comments
ather.shaikh
ather.shaikh Rank 3 - Community Apprentice
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

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,

Answers

  • John_K
    John_K Rank 5 - Community Champion

    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.

  • ather.shaikh
    ather.shaikh Rank 3 - Community Apprentice

    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

  • 2725705
    2725705 Rank 2 - Community Beginner

    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

  • ather.shaikh
    ather.shaikh Rank 3 - Community Apprentice

    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" />

  • 2725705
    2725705 Rank 2 - Community Beginner

    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