Configuring OBIEE to use the Oracle E-Business Suite for
authentication is straight forward and can be completed in a test
environment with only a small amount of effort. It is technically
accomplished through the sharing of the E-Business Suite session cookie.
Further documentation on the specific steps to configure OBIEE to use the E-Business Suite for authentication can be found on Metalink as well as in the OBIEE documentation. A high level summary is as follows:
Further documentation on the specific steps to configure OBIEE to use the E-Business Suite for authentication can be found on Metalink as well as in the OBIEE documentation. A high level summary is as follows:
- Using the BI Admin client tool, modify the RPD file to add a connection to the E-Business Suite database.
- Add an initialization block to the RPD file that calls the E-Business Suite API APP_SESSION.validate_icx_session and then call FND_GLOBAL to collect the variables resp_id, resp_appl_id, security_group_id, resp_name, user_id, employee_id and user_name.
- Edit the OBIEE configuration files authenicationschema.xml and instanceconfig.xml
- Create a menu function to launch OBIEE. You must use the SSWA OracleOasis.jsp$mode=OBIEE
- Populate the system profile option ‘FND: Oracle Business Intelligence Suite EE base URL’ with the url for OBIEE. For example: http://theobieeserver.yourcompany.com:9704
- Upload the modified RPD file using Enterprise Manager and bounce all OBIEE services
