Oracle Forms 6I Forms Tutorials by lqz91615

VIEWS: 1,254 PAGES: 76

More Info
									OAUG Connection Point 2005
Applications Technology Stack SIG
                 ATS SIG
• Leadership Team
  – Elke Phelps, President/Coordinator
  – Srini Chavalis, Vice President/Co-Coordinator
  – Paul Jackson, Program Director
  – Ron “Skip” Cole, Membership Director
  – Andrea Buckman, Financial Coordinator
  – Adrienne Garrett, Meeting Coordinator
• Oracle Liaison
  – Nadia Bendjedou
                  ATS SIG
• Mission Statement
  – The general purpose of the ATS SIG is to
    inform and educate our members on current
    and future components of the Oracle
    Applications Technology Stack
• Membership Registration
  – http://atssig.oaug.org
• List Server
  – http://aqslists.com/archives/atssig.html
OAUG Connection Point 2005
 11.5.10 Applications Technology Stack
        Learning Objectives
• As a result of this presentation, you will
  be able to:
  – Identify the components of the 11.5.10
    Applications Technology Stack
  – Upgrade the components of the 11.5.10
    Applications Technology Stack
  – Identify key new features of the 11.5.10
    Applications Technology Stack
Applications Technology Stack
• What is the Applications Technology Stack?
  –   Applications Technology Family Pack (ATG_FP)
  –   RDBMS
  –   iAS
  –   Forms and Reports (Developer) 6i
  –   Discoverer
  –   Jinitiator
  –   J2SE (JDK)
  –   OJSP
  –   JDBC
  –   Developer 6i Client
Applications Technology Stack
• How can the Applications Technology
  Stack be upgraded?
  – By using Rapid Install + applying patches
    • MetaLink Note 289786.1
  – By applying patches
  – Note:
    • Some components of the ATS might be upgraded
      by a Maintenance Pack, but generally the MP only
      updates application code
    • As identified in the 11.5.10 MP ReadMe, MetaLink
      Note 259484.1, minimum versions of the ATS are
      required for the 11.5.10 MP
        11.5.10 ATS Components
Component                      Version        MetaLink Note
Technology Stack Family Pack   11i.ATG_PF.H   284086.1
Jinitiator                     1.3.1.18       124606.1
JDBC                           9.2.0.5        164317.1
OJSP                           1.1.3.5.1      132604.1
8.0.6 Client                   8.0.6.3
iAS                            8.1.7.4 RSF    146468.1
Forms                          Patchset 16    125767.1
J2SE (JDK)                     1.4.2          246105.1
RDBMS                          9.2.0.5
        11i.ATG_PF.H Components
Component                      Version        MetaLink Note
Technology Stack Family Pack   11i.ATG_PF.H   284086.1
Applications Object Library    11.FND.H       258325.1
CRM Applications Foundation    11i.JTA.F      258282.1
Techstack                      11i.TXK.B      258338.1
XML Publisher                  11i.XDO.H      258332.1
Common Application Calendar    11i.CAC.B      258280.1
e-Commerce Gateway             11i.EC.G       258329.1
Common Modules                 11i.AK.G       258327.1
Alert                          11i.ALR.G      258311.1
User Management                11i.UMX.H      258281.1
           11i.FND.H Components
Component                     Version     MetaLink Note
Applications Object Library   11.FND.H    258325.1
Applications Manager          11i.OAM.H   258330.1
WorkFlow                      11i.OWF.H   268085.1
Applications Framework        11i.FWK.H   275874.1
CRM Technology Foundation     11i.JTT.E   258331.1
  Applying the
ATG Family Pack
                 11i.ATG_PF.H
• Technology Stack Family Pack
  – 11i.ATG_PF.H
  – Patch 3438354
  – MetaLink Note 284086.1

• Prerequisites
  –   Oracle Applications Release 11i
  –   Oracle RDBMS 8.1.7.4 (minimum requirement)
  –   Oracle iAS 1.0.2.2.2 + RUP 4 (3072811)
  –   Applications DBA, 11i.AD.I.1
       • Patch 4038964, MetaLink Note 233044.1
       • New Features
          – Maintenance Mode (adadmin)
                  11i.ATG_PF.H
• Prerequisites (continued)
   3036401   HZ    Trading Community Mini-Pack 11i.HZ.L
   2614213   AME Approval Management Engine
   3412795   XDO AD Splice Patch for XML Publisher
   3178291   HZ    Trading Community Consolidated RUP V3

• Run the Validation Script
   – tkxValidateRollup.sh (UNIX)
   – txkValidateRollup.cmd (Windows)
   – Review output of validation script for additional
     prerequisite requirements
• Apply the ATG_PF.H Patch
  Upgrading the
Technology Stack
   Components
      Jinitiator, JDBC, & OJSP
• JInitiator 1.3.1.x
   – MetaLink Note 124606.1
   – Interoperability Patch 4085551
• JDBC 9.2.0.5
   – Included in 11i.TXK.B
• OJSP 1.1.3.5.1
   – http://[your web server] /OA_HTML/test.jsp
   – Patch 3973396
• 8.0.6.3 Client
   – Patch 1227566
             iAS to 8.1.7.4 RSF
•   iAS Version is 1.0.2.2.2 + RUP 4
•   Upgrade the 8.1.7 client files in the iAS Home
•   Set ORACLE_HOME=iAS_HOME
•   Patches to apply:
       2376472   8.1.7.4 RSF
       3966092   MLR fixes to bugs on top of 8.1.7.4
       3169446   security update for alert #62
       3789326   patch delivers the mod_security module
       3789413   updates to soap.jar
       4193395   Oracle Critical Patch Update April 2005
       4213052   Oracle Critical Patch Update April 2005
  Forms 6.0.8.24 (Patchset 16)
• MetaLink Note 125767.1
• Patchset 16, Patch Number 3596539
• Interoperability Patch Number 3392966
• Download Additional Developer 6i Patches
  – Platform dependent
• Oracle Critical Patch Update April 2005
  – Patch 3281229
 Overview of
New Features
      11i.FND.H New Features
• Single Sign-On & OID Integration
  – MetaLink Note 233436.1 & 261914.1
• Introduction of the new Oracle Applications
  Tablespace Model (OATM)
• Forms Personalization
  – MetaLink Note 279034.1
     11i.OAM.H New Features
• Monitoring Key Business Flows
• Applications Dashboard Configuration & Alerting
• Oracle Forms Runaway Process Detection
  (Forms Patchset 16 is required)
• Advanced Configuration Wizards
• System Cloning
• Extended Concurrent Processing Performance
  Charts
• Enhanced E-Business Suite Web Server
  Monitoring
  OA Framework New Features
• OA Framework 5.10
  – MetaLink 275874.1 & 269138.1
  – http://<hostname>:<port>/OA_HTML/OAInfo.jsp
• JVM Sizing
  – Default for JDK 1.4.2 is 128MB-512MB
  – One JVM per every 75-100 users, One JVM per CPU
• JServ Session timeout
  – <= 30 minutes <= ICX Timeout
  – zone.properties: session.timeout
  – Profile option: ICX: Session Timeout
  OA Framework New Features
• JDBC Connection Pool Parameters
  –   Parameters located in the DBC File
  –   MetaLink Note 278868.1 (soon to be available)
  –   FND_JDBC_BUFFER_MIN
  –   FND_JDBC_BUFFER_MAX
  –   FND_JDBC_BUFFER_DECAY_INTERVAL
  –   FND_JDBC_BUFFER_DECAY_SIZE
        Implementation Hints
• Use ADMERGE
• Apply the latest consolidated rollup patch
   – 11.5.10 Consolidated Update (CU1) for ATG
     Product Family, Patch 4017300
• Apply the associated Help files for each mini-
  pack (review MetaLink Notes)
• Apply the Diagnostics Support Pack
   – MetaLink Note 167000.1
        Implementation Hints
• Apply 4137960 to fix issues with AD.I and
  AD.I.1
  – Includes 4075349 to correctly update patch version
    in fnd_product_installations
• Apply 4175764 to correct cloning issues
• Apply 3090563 to correct workflow issues
• Apply 4244339 to fix reprint issue
       Additional MetaLink Notes
Subject                                             MetaLink Note
Oracle E-Business Suite Release 11i Info Center     112552.1
Release Content Documents, 'About' Documents, and   163400.1
Features Matrix Documents
11i Maintenance Procedures                          289791.1
11i Maintenance Utilities                           289790.1
Installing Oracle Applications:                     289786.1
A Guide to Using Rapid Install
Applications System Administration                  267897.1

eTRM Version 11.5.10                                112552.1
Why Upgrade to 11i10
 11i10+ Technology Highlights
• 11i with Oracle Database 10g
• Leveraging AS 10g Capabilities
• Business Process Management
    • Leveraging AS 10g Integration Platform
• XML Publisher
• Usability and Extensions
• Administration & Management
      11i with
Oracle Database 10g
  11i with Oracle Database 10
• Oracle Applications 11i (version 11.5.9
  and version 11.5.10)

• Oracle Database 10g Release 1 (version
  10.1.0.4)

• Metalink: 282038.1
Leveraging AS 10g
    Capabilities
Leveraging AS 10g Capabilities
• Oracle Application Server 10g has been certified with
  Oracle E-Business Suite Release 11.5.8 and higher, for
  use of Oracle Internet Directory 9.0.4.1, Portal 9.0.4.1,
  Single Sign-On 9.0.4.1, and Discoverer 9.0.4.1.

• The certified architecture supports the deployment of
  Oracle Application Server 10g on a stand-alone server,
  connecting to one or more Oracle E-Business Suite
  Release 11i instances.

• Documentation for this configuration is published in
  Metalink Notes 233436.1 and 261914.1. Access to the
  patches required by this configuration is being managed
  through an Early Adopter Program to ensure the success
  of all customers.
           Leveraging AS 10g
          Share enterprise systems



           AS 10g Discoverer
                                   AS 10g Identity Management




AS 10g WebCache E-Business Suite
                                              AS 10g Portal




          E-Business Suite
                                   AS 10g Integration Services
Third-Party Identity Management
-Windows Native Authentication                                                 –Sun ONE/iPlanet
-Entrust, IBM, RSA, Netegrity, Oblix, Sun, Thor, and others                    –Microsoft Active Directory
- X.509v3 Digital Certificates                                                 –LDIF/DIP
-Other SSO systems
                              Third-Party SSO                                Third-Party LDAP
                                                                             Directory
   Delegates
    SSO to                                                 Synchronization


                                                                                 Identity Mgmt
                                                                                 Repository (OID)
                              OracleAS 10g
                              Identity Management (SSO)
  End
  User
                              E-Business Suite
                              Oracle9i Application Server 1.0.2.2.2
                                                                                 E-Business
                                                                                 Suite Database
Business Process Management
 Leveraging AS 10g Integration Platform
Business Process Management
                         Today!
       Applications




                                              Business Event System (BES)
         Forms        Self Service   Custom



                      Workflow Engine                                       Third Party
                                                                            Systems




        Repository
AS 10g Integration Platform
         Advantages of BPEL
– Standards-based process orchestration
  • Industry standard language: BPEL
– Move towards Service Oriented Architecture
– Standards-based connectivity to
  heterogeneous applications
     – JCA, JMS, WS etc.
AS 10g Integration Platform
    BPEL Integration – Now!




                                        Provider
   Applications




                                          Web
    Forms       Self Service   Custom

                                                                            BPEL Server




                                        Business Event System (BES)
                                                                      Oracle Application Server
                Workflow Engine




                                                                               Third Party
   Repository                                                                  Systems
AS 10g Integration Platform
    BPEL Integration – Now!
– Whitepaper: Oracle E-Business Suite to
  BPEL and Back in 3 Easy Steps
  • http://www.oracle.com/technology/products/applic
    ations/integration/BPEL-BES4Apps.zip
– Leverage Business Event System
  • Asynchronous invocation of BPEL processes
  • Asynchronous invocation of business logic in E-
    Business suite from BPEL
– Sample code
    Related OAUG Session

• Extending Your E-Business Suite
  Investment Using Oracle Integration
  – Jeff Hutchins, Tuesday at 10am, Room: Grapevine 2/3
XML Publisher
 XML Publisher
moving from these…
… to these
         XML Publisher Concept

  Separate data / layout / translation
                                            EFT
                                            EDI
Data Logic
                                            Fax
Layout
                        XML
                      Publisher   Report
Translation            Engine              E-Mail
                                  output


More flexibility                           Printer

Reduced maintenance
    Related OAUG Session

• Oracle XML Publisher - Enterprise
  Reporting and Delivery Platform
  – Tim Dexter, Tuesday at 5pm, Room: Dallas 5-7
Personalization and
     Extension
Personalization and Extensions
           What is new in 11i10?
• Forms Applications
  – Forms Personalization (new)


• Oracle Applications Framework
  – Enhanced User Interface
  – Enhanced Personalization
  – Extension and Customization
    Forms Personalization
       All customers desire to:
• Remove fields, buttons, tabs, etc.
• Re-label fields, buttons, tips to match their terminology
• Change the default value of fields
• Navigate from one form to another, passing context
• Add additional business logic/practices/messages
• Do any of the above for only a particular user or
  responsibility
• Do any of the above only if certain conditions are true.
• Do all of the above in a upgradeable manner without
  writing code, and without violating support agreements
       Your wish is granted!
Oracle Applications Framework
• Enhanced User Interface
• Enhanced Personalization
• Extension and Customization
Oracle Applications Framework
     Enhanced User Interface
Oracle Applications Framework
         Enhanced User Interface

• User Interface Interactivity Enhancements
• Advanced User Interface Components
• Denser Look
 Oracle Applications Framework
     Enhanced Personalization in OAF
• Your personalizations are added on top:
   – UI definition overlays
   – Saved user views
   – WYSIWYG on-line Personalization
• Admin Level Personalization
   – Function, Location, Site, Organization and
     Responsibility
• User Level Personalization
   – User Views
Enhanced Personalization
  Admin Level Personalization

               • Visual experience for
                 Configurable Pages
               • Descriptive for accessibility
                 and non-configurable pages
     Enhanced Personalization
           Admin Level Personalization



- Tailor text for labels, prompts, and tip messages
- Hide/Show components
- Reorder components
- Restrict query results
- Add new items: buttons, links, choice lists, images, transient &
  updatable fields, LOVs, Flexfields, etc.
- Tailor graphs & charts
- Seed end-user views
- etc…
Enhanced Personalization
  Admin Level Personalization
Enhanced Personalization
  Admin Level Personalization
                -   Create and save a search
                -   Tailor table column titles
                -   Hide/Show columns
                -   Reorder columns
                -   Number of rows
                -   Add data filters
                -   Change sorting order
User Level Personalization
   Example: Projects Module
 Oracle Applications Framework
              Extensibility with OAF
• Extending & Creating Business Objects with OAF
   – New application/module, New page, New attribute
   – Extend/Override defaults & validations

• Integrated Development Environment (IDE)
  available known as the “Oracle JDeveloper OA
  Extension”

• Resources include:
   – Developer’s Guide and Standards
   – Tutorials, Javadoc, Samples Library, Online Help
   More Information on OAF

• OA Framework and Overview
  – Mark Sullivan, Tuesday at 3:45, Room: San Antonio 4-6

• Visual and Declarative J2EE Development
  with Oracle Jdeveloper 10g and Oracle ADF
  – Jacobi or Regis Louis, Wednesday at 5pm, Room:
    Dallas 5-7

• OA Framework at the Demoground
  – Bill Sawyer
Administration and
   Management
Administration and Management
With Oracle Applications Manager (OAM)
• Built directly into Oracle E-Business Suite 11i
• Provides features for monitoring,
  administration, troubleshooting,
  maintenance, and configuration management
• Required for managing certain aspects of
  Oracle E-Business Suite 11i.9+
Enterprise Manager Integration

         Enterprise Manager 10g
              Grid Control
                     Grid Control Plug-in for
                      Oracle Applications



     Oracle               Oracle                   Oracle
   Applications         Applications             Applications
   Manager 11i          Manager 11i      …       Manager 11i


  E-Business Suite    E-Business Suite          E-Business Suite
     System 1            System 2                  System N
Administration & Management

                        « Grid Monitoring »
                         with Grid Control


  Summary Information   Detailed Information and
    with Grid Control   Administration with OAM
Grid Control Plug-in for EBS

• Adds new management target types to Grid
  Control:
    –   Oracle Applications System
    –   Forms Listener for Oracle Applications
    –   Reports Server for Oracle Applications      iAS 1.0.2.2
    –   HTTP Listener for Oracle Applications
    –   JServ for Oracle Applications
    –   Discoverer Server for Oracle Applications


• Adds new Grid Control console pages
• Links Grid Control to Oracle Applications
  Manager
             Availability
• Available via OracleMetaLink as an “Oracle
  Applications Manager” patch
  – Linux: 4289612
  – Solaris: 4288879


• Remaining Tier 1 platform release dates TBD

• No additional license required
                 Compatibility
• Enterprise Manager 10.1.0.3

• Provides basic monitoring support for Oracle
  Applications 11i.3 and higher

• Provides greater levels of functionality as Oracle
  Applications 11i technologies are upgraded
    –   Oracle Applications Manager
    –   iAS Patchset 4
    –   Forms Patchset 16
    –   WebCache
   Optional: E-Business Suite
     Interoperability Patch
• Optional patch for E-Business Suite 11i

• Unlocks additional metrics, user interface
  elements, and links to Oracle Applications
  Manager within Grid Control

• Prerequisites:
   – OAM.G (included in 11.5.9)
   – OAM.G Rollup A
                     Applications Technology
                            Roadmap


These slides is intended to outline our general product direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or
functionality, and should not be relied upon in making a purchasing decision.
              Technology Stack for R12
    • 10g Database in Rapid Install
    • 9iAS 1.0.2.2.2




These slides is intended to outline our general product direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or
functionality, and should not be relied upon in making a purchasing decision.
                                  Project Fusion
    • The next step in Oracle Applications and
      technology, embracing a service oriented
      and standards-based information
      architecture
    • About fusing processes, people, and
      products to leverage the best parts from
      each of the components

These slides is intended to outline our general product direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or
functionality, and should not be relied upon in making a purchasing decision.
                                  Project Fusion
    • Architecture
          – Service-Oriented Architecture
          – Global Single Schema
          – Embedded Business Intelligence
    • Technology will include
          – Oracle Database 10g
          – Oracle Fusion Middleware

These slides is intended to outline our general product direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or
functionality, and should not be relied upon in making a purchasing decision.
        Fusion Platform Focus Areas
    •    Development Framework
    •    Process and Integration
    •    Life cycle Management
    •    Reporting & Analytics




These slides is intended to outline our general product direction. It is intended for information purposes only,
and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or
functionality, and should not be relied upon in making a purchasing decision.
Q&A
Thank You!

								
To top