Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Applications Database Connections

RE: Oracle Applications Database Connections

From: Hameed, Amir <>
Date: Thu, 1 Mar 2007 12:15:23 -0500
Message-ID: <>

I am assuming that you are using release 11i of Oracle Apps. The APPLSYS.FND_USER table contains information on the application accounts. All application accounts connect to the database via the APPS database schema. So, you will be authenticated to the apps via FND_USER but the application will make connection to the database via database schema APPS.
Oracle apps does not come pre-configured with SSO and OID. You will need to find appropriate documents on Metalink to implement that.

[] On Behalf Of Reidy, Ron

	Sent: Thursday, March 01, 2007 11:37 AM
	Subject: RE: Oracle Applications Database Connections

	Is the app configured to use SSO using OID?




[] On Behalf Of Mercadante, Thomas F (LABOR)
	Sent: Thursday, March 01, 2007 9:35 AM
	Subject: Oracle Applications Database Connections




	I've inherited an Oracle Applications/Forms & Reports system
here. We need to move it all to a new set of servers.          

        I've been looking within Oracle Portal itself and have one simple question.          

        How does the application know which Oracle Account to log into? Is there connect information stored someplace that ties a portal page to a specific Oracle Account/Password & connect string? It's hidden pretty good from what I can see.          

        Thanks for any clues.         


        This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.                   

        This electronic message transmission is a PRIVATE communication which contains information

        which may be confidential or privileged. The information is intended to be for the use of the individual

        or entity named above. If you are not the intended recipient, please be aware that any disclosure,

        copying, distribution or use of the contents of this information is prohibited. Please notify the sender

        of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),

        and then delete it from your system.         

Received on Thu Mar 01 2007 - 11:15:23 CST

Original text of this message