Project ONE CLICK

1
Project ONE CLICK
Oracle Single Sign-On Sridhar
Gangapuram Manager, Oracle Applications
(Phoenix) Roger Raj Sr. Technical Director
(Oracle)
12/26/2006
2
Agenda

• Project Goals and Objectives
• Previous Architecture
• Current Architecture
• Oracle Modules
• Project Cycles
• Challenges
• Details of Technology Architecture
• How Does Windows Native Authentication Work ?
• Other Technology Elements
• ONE CLICK Integration Road-Map
• ONE CLICK Demo
• QA

3
Project Goals and Objectives

• Goals
• Implement Oracle Apps Single Sign-on
• Implement Discoverer Single Sign-on
• Objectives
• On ONE CLICK get into Oracle Apps
• On ONE CLICK get into Oracle Discoverer

4
Previous Architecture
Forms Server 9i version
Linux Server Oracle Apps Components
Reports Server 9i version
Discoverer Server 4i Version
Essbase Server
Optio Reporting-Fax Server
APRO EFT Server
Oracle SFDC Reporting Server
Hyperion Server
5
Current Architecture
S I N G L E S I G N O N
Linux Server SSO
Linux Server Oracle Apps Components
Portal
DBI
OID
Forms Server 9i version
Reports Server 9i version
Microsoft AD
Oracle SFDC Reporting Server
Optio Reporting-Fax Server
APRO EFT Server
Essbase Server
Hyperion Server
6
Oracle Modules
Oracle Modules Oracle Modules Oracle Modules Oracle Modules
Finance Distribution Human Resources Reporting
Accounts Receivables Order Management Human Resources Oracle Discoverer
Accounts Payables Inventory Optio
Purchasing
Fixed Assets
Cash Management
General Ledger


7
Project Cycles
IT
CRP1
IT Business
CRP2
CRP3
IT Business
UAT
IT Business
IT
MOCK
IT Business
GO-LIVE
8
Challenges

• Business Test Cases
• Business SOX Controls ? 250 plus
• Apps Functionality ? All Modules
• Custom Reports ? 100
• Interfaces ? 10 in/out bound interfaces
• Customer Facing Documents ? 20
• Regions ? 4 Major Regions
• IT Test Cases
• IT SOX Controls ? 50 plus
• 10G Patching
• EUL Patching
• Oracle and AD Integration
• Hardware ? New 10G Linux Server

9
Details of Technology Architecture

• ONE CLICKs Integration with Windows Native
  Authentication
• AD session created on login
• Oracle 10g AS can use this information
• Kerberos enables session verification
• Similar to Windows Exchange server
• No more login challenges!
• Fully compliant with SmartCards or Common Access
  cards
• Session is controlled by MS-Windows Kerberos
• Userids/passwords are controlled by MS-AD

10
How Does Windows Native Authentication Work ?
11
Other Technology Elements

• Oracle 10g Application Server
• Single sign-on component
• Oracle Internet Directory for Users Id and
  groups
• 10g Discoverer Drake version
• Allows capture of single sign-on id
• Users CLIENT_IDENTIFIER
• No need to create and manage DB users (as in the
  past releases)
• Tied to a web-based implementation
• No client tools need to be installed on desktops!

12
ONE CLICK Integration Road-Map

• Make sure desktops are on XP-SP2 or above
• Install 10g Application Server
• Install 11i EBS 3.2 rollup patch (now 4.0 is
  available)
• Make 11i a partner to 10gAS
• Install Windows Native Auth support for 10gAS
• Modify discoverer work pages to work with SSO-id
• Test, document and migrate to production!

13
ONE CLICK Demo
Oracle Applications
Oracle Discoverer
End Result is USERS are HAPPY !
14
QA
A