FreeLists / oracle-l / RE: Oracle Applications Database Connections

["Hameed, Amir" <Amir.Hameed@xxxxxxxxx>]

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Reidy, Ron
        Sent: Thursday, March 01, 2007 11:37 AM
        To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
        Subject: RE: Oracle Applications Database Connections
        
        

        Is the app configured to use SSO using OID?

         

        
________________________________


        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
        Sent: Thursday, March 01, 2007 9:35 AM
        To: oracle-l@xxxxxxxxxxxxx
        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.