Forum Stats

  • 3,826,315 Users
  • 2,260,624 Discussions
  • 7,896,888 Comments

Discussions

unable to connect database from discoverer plus/viewer

ora_learner36
ora_learner36 Member Posts: 424 Blue Ribbon
edited Mar 25, 2019 4:57AM in Discoverer

Hi All,

Hope all are doing good.

I need your help to connect a EBS database named 'DEV'  from oracle BI discoverer plus and Viewer.

We are able to connect production and test EBS databases from discoverer plus and viewer and this was done by senior and unfortunately he left the job. So, i am totally new to Oracle BI discoverer.

Kindly, guide me to connect DEV EBS database from discoverer plus/viewer.

Your help will be appreciated.

Thanks in advance.

Discoverer= 11g

Best Answer

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Mar 20, 2019 7:15AM Answer ✓

    Hello,

    First of all you need to have an entry in the tnsnames.ora file for the database.  Then you need to copy / ftp the .dbc file from the EBS server to the Discoverer Server.  See the "Using Discoverer..." notes below for location, naming, etc.

    The default type of logon to Discoverer Plus / Viewer is Standard Mode (OracleBI Discoverer), which uses a Database login.  You will need to change that to be Apps Mode (Oracle Applications), which uses an EBS user login.

     

    Here is the Discoverer documentation:

      http://docs.oracle.com/cd/E28280_01/nav/pfrd.htm

    Here are some Notes that may be helpful:

    Note 1073963.1 - Using Discoverer 11.1.1 with Oracle E-Business Suite Release 11i

    Note 1074326.1 - Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12

    Note 1380591.1 - Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12.2

    Note 353605.1  - DBC File Naming Conventions for Discoverer Connections to Oracle Applications 11i and R12

    Note 1951454.1 - Unable To Connect To EBS Release 12 Database Using Discoverer After Changing APPS User Password

    Regards,

    Sharon

Answers

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Mar 20, 2019 7:15AM Answer ✓

    Hello,

    First of all you need to have an entry in the tnsnames.ora file for the database.  Then you need to copy / ftp the .dbc file from the EBS server to the Discoverer Server.  See the "Using Discoverer..." notes below for location, naming, etc.

    The default type of logon to Discoverer Plus / Viewer is Standard Mode (OracleBI Discoverer), which uses a Database login.  You will need to change that to be Apps Mode (Oracle Applications), which uses an EBS user login.

     

    Here is the Discoverer documentation:

      http://docs.oracle.com/cd/E28280_01/nav/pfrd.htm

    Here are some Notes that may be helpful:

    Note 1073963.1 - Using Discoverer 11.1.1 with Oracle E-Business Suite Release 11i

    Note 1074326.1 - Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12

    Note 1380591.1 - Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12.2

    Note 353605.1  - DBC File Naming Conventions for Discoverer Connections to Oracle Applications 11i and R12

    Note 1951454.1 - Unable To Connect To EBS Release 12 Database Using Discoverer After Changing APPS User Password

    Regards,

    Sharon