Transcript EBS SIG - ATSSIG Home

EBS Applications
Technology Stack
Comparison
EBS Applications Technology
Leadership Team
Oracle Open World
October 2009
Rapid Install Versions
11.5.10
12.0.0
12.0.4
12.1.1
Oracle 10.1.2
AS Forms &
Reports
N/A
10.1.2.0.2 10.1.2.2
Oracle 10.1.3
AS OC4J
N/A
10.1.3.0.0 10.1.3.0.0 10.1.3.4
Oracle 9i AS
Forms &
Reports
1.0.2.2.2
8.0.6
Home
N/A
N/A
N/A
Oracle 9i AS
Jserv
1.0.2.2.2
8.1.6
Home
N/A
N/A
N/A
Database
9.2.0.5
10.2.0.2
10.2.0.3
11.1.0.7
10.1.2.3
R11 Architecture – Components
Application Tier
Database Tier
8.0.6 ORACLE_HOME
8.1.7 ORACLE_HOME
APPL_TOP
COMMON_TOP
10gR2 or 11g DB
ORACLE_HOME
R12 Architecture – Components
Application Tier
Database Tier
10.1.3.x
ORACLE_HOME
10.1.2.x
ORACLE_HOME
APPL_TOP
COMMON_TOP
INSTANCE_HOME
10gR2 or 11g DB
ORACLE_HOME
EBS Applications Technology
SIG Board

Oracle Application Server ( 11.5.10 )




Media installs 9iAS 1.0.2.2.2
Latest patches are iAS Rollup 3 (2674529) and
iAS Rollup 4 (3072811)
Uses JServ technology
466890.1 - Script to find Apache, Java, Jinitiator,
Forms version and JVM details for Oracle EBusiness Suite 11i
EBS Applications Technology
SIG Board

Oracle Application Server ( 11.5.10 )



Separate 10g AS install can be used for
SSO/OID/Portal/Discoverer/Webcache
functionality
233436.1 - Installing Oracle Application Server
10g with Oracle E-Business Suite Release 11i
mod_plsql is available
EBS Applications Technology
SIG Board

Oracle Application Server ( R12.0.x )





Media installs 10gAS 10.1.3.0
Latest patch is 10gAS 10.1.3.4 (454811.1 Upgrading to the Latest OracleAS 10g 10.1.3.x
Patch Set in Oracle E-Business Suite Release 12)
Uses OC4J technology
468311.1 - Script to find Apache, Java, JRE,
Forms version for Oracle E-Business Suite R12
mod_plsql not available
EBS Applications Technology
SIG Board

Oracle Application Server ( R12.1.x )





Media installs 10gAS 10.1.3.4
Currently 10.1.3.4 is the latest patchset
Uses OC4J technology
468311.1 - Script to find Apache, Java, JRE,
Forms version for Oracle E-Business Suite R12
mod_plsql not available
EBS Applications Technology
SIG Board

Oracle Application Server ( for all releases )




Need to apply iAS CPU patches as applicable
362851.1 - Guidelines to setup the JVM in Apps
Ebusiness Suite 11i and R12
601736.1 - Script To Check The Techstack
Component Versions (Forms, Http Server, JDK,
Framework, Database, etc)
235307.1 - E-Business Suite Diagnostic Tools
FAQ and Troubleshooting Guide for Release 11i
and R12
Java Requirements
Application Node
R11i



Latest certified 1.6.0_02+ for 11i (per certification matrix
for Linux x86)
300482.1 - Overview of Using Java with Oracle EBusiness Suite Release 11i
401561.1 - Using JDK Version 6 with Oracle E-Business
Suite 11i, Releases 11.5.10 & 11.5.9
R12


Latest certified 1.6.0_07+ for 12.1 (per certification
matrix for Linux x86)
455492.1 - Using Latest Update of Java 6.0 with Oracle
E-Business Suite Release 12
418664.1 - Overview of Using Java with Oracle EBusiness Suite Release 12
JRE Requirements
Client (desktop)
R11i


Latest certified - JRE 1.6.0_03 or later
Note 285218.1 - Recommended Browsers for Oracle EBusiness Suite 11i
R12.1


Latest certified - JRE 1.6.0_03 or later
389422.1 - Recommended Browsers for Oracle EBusiness Suite Release 12
* Safari and Firefox users, check docs for certification
version
JInitiator
JInitiator

761159.1 Oracle Corporation Product Obsolescence Desupport Notice
Error Correction Support (ECS): 31-JAN-2010
Extended Support (ES): 31-JAN-2013
Java Troubleshooting
Troubleshooting Tips/Guides


760250.1 - Diagnosing Forms Mouse Focus Problems
Using JRE
http://blogs.oracle.com/stevenChan/2009/07/tips_debug
ging_sun_jre_forms_focus.html
Updating JRE plug ins


290807.1 - Upgrading Sun JRE (Native Plug-in) with
Oracle Applications 11i for Windows Clients
393931.1 - Upgrading JRE Plugin with Oracle
Applications R12
RDBMS Versions
11.5.10
12.0.0
12.0.4
12.1.1
10.2.0.4
11.1.0.7
10.2.0.2
10.2.0.2
10.2.0.3
Max RDBMS 10.2.0.5
11.1.0.7
10.2.0.4
11.1.0.7
10.2.0.4
11.1.0.7
10.2.0.4
11.1.0.7
Rapid Install
9.2.0.5
10.2.0.2
10.2.0.3
11.1.0.7
MetaLink
Note
10g,362203.1
11g,452783.1
467778.1
403339.1
761570.1
Min RDBMS
Database Support







10g R2 database is part of EBS R12 technology stack
10g R2 database is certified to run with EBS R12.1.1
The latest certified 10g R2 database release - 10.2.0.4 with EBS
R12
Premier Support ends for database version 10g R2 on 7/31/2010
Extended support fees waived until 7/31/2011
10g R2 Terminal Patch Set is 10.2.0.5 (Projected to be released
in 2009)
Oracle Metalink Note 454616.1 - Export/Import Process for
Oracle E-Business Suite Release 12 Database Instances Using
Oracle Database 10g Release 2
Database Support






Oracle Database 11g Release 1 (11.1.0.7.0) is certified, on all
Certified E-Business Suite Platforms, on R12 (12.0.4).
Oracle Database 11g Release 1 (11.1.0.7.0) is part of EBS
R12.1.1 technology stack
Premier support for 11.1.0.6 database ends in October 2009
Oracle Metalink Note 735276.1 - Interoperability Notes EBusiness Suite R12 with Oracle Database 11gR1 (11.1.0)
Oracle Metalink Note 466649.1 - Using Oracle 11g Release 1
Real Application Clusters and Automatic Storage Management
with Oracle E-Business Suite Release 12
Oracle Metalink Note: 741818.1 - Export/Import Process for
Oracle E-Business Suite Release 12 Database Instances Using
Oracle Database 11g Release 1
11g Database – New Features


Access Control List (ACL) : Introduced support for ACL which
is a new feature in 11g database
Oracle Advanced Compression
 Comprehensive set of compression capabilities to help
organizations reduce costs, while maintaining or improving
performance.
 Reduces the storage footprint of databases through
compression of structured data (numbers, characters) as
well as unstructured data (documents, spreadsheets, XML
and other files).
 Provides enhanced compression for database backups
and also includes network compression capabilities for
faster synchronization of standby databases.
Database Initialization
Parameters with EBS


Metalink Note 216205.1 - Database
Initialization Parameters for Oracle
Applications Release 11i
Metalink Note 396009.1 - Database
Initialization Parameters for Oracle
Applications Release 12
OID/SSO with R11i




Metalink Note 233436.1
Install OAS Identity Management Infrastructure
10.1.4.0.1 and upgrade to 10.1.4.3
Install EBS SSO 10g Integration Patch 6117031
Register EBS Instance with OID/SSO




Default Registration
Manual Registration (Appendix A)
Install applicable EBS Product Family SSO Patches
Diagnostic tests are available through the “CRM
HTML Administration” responsibility
OID/SSO with R12




Metalink Note 376811.1
Install OAS Identity Management Infrastructure
10.1.4.0.1 and upgrade to 10.1.4.3
No EBS patching required unless running EBS on
AIX (patch 5855635)
Register EBS Instance with OID/SSO



Default Registration
Manual Registration (Appendix A)
Diagnostic tests are available through the “CRM
HTML Administration” responsibility
OID/SSO Support Dates

Premier Support for SSO+OID 10.1.4.2 ends
November 2009
AD Utilities features and
enhancements

AutoConfig: Parallel Run Option


The “Parallel Run” feature enables AutoConfig to
be executed simultaneously across multiple nodes
EBS instance
AutoConfig: Profiler

Consolidated HTML report of an AutoConfig run



Source and target location of each template
Time consumed to instantiate/execute individual
template scripts
Execution report for each template script
AD Utilities features and
enhancements

AutoConfig: Enhanced Check Config Tool


The Check Config tool (adchkcfg) is used to identify the
potential changes that would take effect on an EBS customer
instance during the next AutoConfig run. The tool has been
enhanced to report important database updates, generate a
text report for database changes, and offer improved
readability of reports.
AutoConfig: Support for Oracle Database 11g
Features

AutoConfig has been enhanced to support the use of Access
Control Lists and other Oracle Database 11g features.
AD Utilities features and
enhancements

Rapid Install




Ability to store base environment configuration in Oracle EBS
database
Multiple Domain Support for database and middle tier
Read-Only Shared File System Support – appl_top,
common_top, tech stack homes can be deployed on a readonly shared file system
Rapid Clone

Added RAC support for ASM and features to expand RAC
system by adding a node to existing RAC cluster
Applications Object Library features and
enhancements

Identity Management Integration
 User Name Enhancements


On Demand User Creation


User name changes in EBS are automatically
synchronized to Oracle ID
AOL now supports a mode in which EBS user
account is automatically created for SSO users
when they first visit a page in EBS
Automatic Linking Of User Accounts

EBS accounts are automatically linked to existing
accounts with the same user name in OID
Applications Object Library features and
enhancements

Security


New File System Layout
 EBS code tree is free of configuration, log and
output files and can be mounted in a read-only
mode at runtime (when not patching)
Schema Passwords

The base product schemas are locked except
during patching
Tasks to complete to ease R12
upgrade








Upgrade database to 10g R2 or 11g R1
Convert tablespaces to OATM model
Evaluate impact of R12 on customizations and extensions
Introduce BI Publisher and JDeveloper
Integrate Discoverer Server Release 10g with EBS 11i
Configure Oracle iAS Release 10g for external apps (SSO,
OID, Portal) and integrate with EBS 11i
Position for high availability and scalability
Evaluate and complete platform change based on ROI