RE: Oracle Applications Database Connections

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 1 Mar 2007 13:10:15 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08BBF@EXCNYSM0A1AJ.nysemail.nyenet>

Amir,

Not Oracle Applications. It's an Oracle Forms & Reports application developed under Oracle Application Server.

Tom

From: Hameed, Amir [mailto:Amir.Hameed_at_xerox.com] Sent: Thursday, March 01, 2007 12:15 PM
To: Ron.Reidy_at_arraybiopharma.com; Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org
Subject: RE: Oracle Applications Database Connections

Tom,

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.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reidy, Ron

	Sent: Thursday, March 01, 2007 11:37 AM
	To: Thomas.Mercadante_at_labor.state.ny.us; oracle-l_at_freelists.org
	Subject: RE: Oracle Applications Database Connections

	Is the app configured to use SSO using OID?

	 

	


________________________________



	From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F (LABOR)

	Sent: Thursday, March 01, 2007 9:35 AM
	To: oracle-l_at_freelists.org
	Subject: Oracle Applications Database Connections

	 

	All,

	 

	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.

Tom

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 01 2007 - 12:10:15 CST