DISCOVERER Administrator, -Desktop: Identify connection DB-Instance after logon - update

mrigg

This question (DISCOVERER Administrator, -Desktop: Identify connection DB-Instance after logon ) posted by @LPNO  is now archived, but in case the OP or anyone else is still interested, I found a better answer.

There is a function SYS.DATABASE_NAME that returns the connection name.  I was able to register it in Discoverer Administrator and use it in reports.  Wish I'd found that sooner!

sbeck-Oracle

Hello,

To begin with, you should not be using a Database login to administer an Apps Mode (EBS) EUL.  You should be using sysadmin or other user.    The EUL schema should only be used to create the EUL and provide Admin privileges to an EBS user.  Nothing else ever.

Two things you can do.  First is to give the EUL schema unique name (eg. PRODEUL_US, TESTEUL_US).

Second, when giving Discoverer Administration access to an EBS user, provide a unique EBS name existing only in "that" EUL.  Example:  the default (as seen in the using Discoverer with EBS Note 1073963.1 Note 1074326.1 and Note 1380591.1) is sysadmin.  In the production EBS system create ProdSysadmin and in the test EBS system create TestSysadmin.

Use of the different EBS user to administer the EUL can be an issue if you move workbooks from one EUL to the other.  On Admin import of the eex file, be sure to select the option to only take ownership of workbooks if the owner does not exist. 

Either of these methods will show in Help / About Discoverer.   The preferred method is the first, unique EUL schema names.  This is because the only place that references the actual EUL name is Preferences Server.  It is not used by Plus, or Viewer in the connection process.

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

 

Regards,
Sharon

mrigg

Was that reply directed at me?  I was just trying to update an earlier discussion that had been archived (link in original post).  User LPNO was trying to find a way to display the database connection within Discoverer Desktop or Admin (if I understood the question correctly).  I found a function that worked for me and wanted to pass on the info.  I'm not sure if LPNO is working with EBS; I'm not familiar with it.  Maybe I confused things by putting a screen shot of the original message in my post.

sbeck-Oracle

I missed the last line in the "repost".   But I can tell you LPNO is using EBS.  The default name of an EBS EUL is EU_US.  Thank you for your response regarding the function.