Question on EBS/OBIEE integration and security
I am configuring EBS R12/OBIEE 11g integration via the passing cookie and url process as defined in the integrator guide and several Metalink notes. I believe I have successfully autheticated for the EBS user via the steps outlines. In my case, I am using a R12 Vision DB and a random user CMOORE. My questions are as follows:
1) When I navigate to OBIEE via the EBS link for CMOORE, I see a "Access Prohibited, you are not currently authorized to use OBIEE dashboards..etc". Does this imply that I need to create a user CMOORE in OBIEE (even though I am using external table authentication)? How exactly is the :Authorization" being done in this case. For instance, I want to alllow CMOORE to see ALL dashboard content (same as a superuser). How would i resolve this error and see the dashboards?
2) My second question is..suppose a user navigates from EBS to OBIEE...what are the steps to navigate back to EBS? Is this done through the Actions in 11g and the same cookie information? Is there a note or doc for this setup?
3) Suppose I do NOT want to log into EBS first..I just want OBIEE users to navigate to EBS (possibly via Action Framework). Is this possible?? For instance, I see a OBIEE reports with invoice ID 123 that seems to be questionable..I want to navigate to EBS to that specific invoice transaction. Has anyone done this before..(successfully not theoretically)?
Thanks.