cancel
Showing results for 
Search instead for 
Did you mean: 

Universe on Oracle EBS

Former Member
0 Kudos

Hi Experts,

We are trying to create relational universe in IDT with Oralce Client.

  1. Can we use Oracle 10g relational connection to access the tables of Oracle Ebusiness Suite?
  2. Do we have to necessarily create connection with Oracle EBS Settings as shown in the attached snapshot.
    1. Kindly also help in filling the required parameter in attached snapshot, we have tried POSSIBLE options for this but its giving error (snapshot is attached)

If we create universe with oracle EBS option, then how can we map the logic of oracle EBS on our universe. I use the word LOGIC, because currently, the report given to us by client is coming from Oracle EBS directly through report builder. We are able to get the table names and some PL/SQL code behind that report design. How can we map PL/SQL LOGIC in IDT universe. How to do that?

Any help would be highly appreciated.

Regards

Ayaz

Accepted Solutions (0)

Answers (2)

Answers (2)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

please refer to the Data Access guide here (page 79 onwards): http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_data_acs_en.pdf

and section

8.2.3.4 Login parameters for Oracle EBS connections

in the IDT guide here: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_info_design_tool_en.pdf

Regards,

H

Former Member
0 Kudos

Woww ... i am guessing I am the FIRST PERSON having this issue

Kindly reply, if any one has this issue before.

Regards

Ayaz