1/38

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 5.1
  • Deprecated and Desupported Features
  • Other Changes

1 Getting Started with Application Migration Workshop

• 1.1 Understanding How to Convert an Oracle Forms Application
  • 1.1.1 About Creating an Oracle Forms Application
  • 1.1.2 Preparation Checklist for Converting Oracle Forms Applications
• 1.2 About the Oracle Application Express Forum

2 Overview of the Migration Process

• 2.1 Why Migrate to Oracle Application Express?
• 2.2 Before Starting the Conversion Process
• 2.3 About the Benefits of Using a Migration Project
• 2.4 Understanding the Key Differences with Oracle Application Express
  • 2.4.1 About Stateless Web Applications
  • 2.4.2 About Evaluating User Interface Design
  • 2.4.3 About Business Logic Replication
• 2.5 Creating an Oracle Application Express Migration Project
  • 2.5.1 About Data Structures
  • 2.5.2 About Creating a Project

3 Converting an Oracle Forms Application

• 3.1 How to Convert Your Application
  • 3.1.1 About the Process of Converting Oracle Forms
• 3.2 Converting FormModules, ObjectLibraries, or MenuModules to XML
  • 3.2.1 About the Forms2XML Conversion Tool
  • 3.2.2 Using the Forms2XML Conversion Tool From a Command Line
  • 3.2.3 Using the Forms2XML Conversion Tool in a Java Program
• 3.3 Converting Oracle Forms to XML
  • 3.3.1 Converting a PL/SQL Library
  • 3.3.2 Converting an Oracle Report to XML
• 3.4 About Creating a Workspace and Adding Oracle Application Express Users
• 3.5 Uploading Database Objects into the Schema Associated with Your Workspace
• 3.6 Creating a Conversion Project
• 3.7 Reviewing and Editing Forms Metadata
  • 3.7.1 Understanding the Application Migrations Page
    • 3.7.1.1 Using the Project Page
      • 3.7.1.1.1 Viewing Project Details
      • 3.7.1.1.2 Utilizing Interactive Reports
      • 3.7.1.1.3 Upload File, Create Application, and Run Application Buttons
      • 3.7.1.1.4 About Associated Application
      • 3.7.1.1.5 Tasks List
      • 3.7.1.1.6 Completion Status Region
    • 3.7.1.2 Uploading Additional Files
  • 3.7.2 Editing Project Details
  • 3.7.3 Reviewing Forms Modules
    • 3.7.3.1 Viewing an Imported FormModule
    • 3.7.3.2 Viewing Object Metadata and Selecting Specific Objects
    • 3.7.3.3 Understanding Viewing and Selecting Blocks
      • 3.7.3.3.1 About Block Details
      • 3.7.3.3.2 About Annotations
      • 3.7.3.3.3 About Application Express Page Query
      • 3.7.3.3.4 Relation Details
      • 3.7.3.3.5 Block Items
      • 3.7.3.3.6 Block Triggers
      • 3.7.3.3.7 About Audit
    • 3.7.3.4 Viewing and Selecting Items
      • 3.7.3.4.1 About Item Details
      • 3.7.3.4.2 About Annotations
      • 3.7.3.4.3 About Audit
  • 3.7.4 Reviewing Oracle Reports
    • 3.7.4.1 Viewing Reports
      • 3.7.4.1.1 Report Details
      • 3.7.4.1.2 About Annotations
      • 3.7.4.1.3 About SQL Query
      • 3.7.4.1.4 About Data Items
      • 3.7.4.1.5 About Summary Items
      • 3.7.4.1.6 About Audit
    • 3.7.4.2 Selecting Reports to Include
  • 3.7.5 Reviewing PL/SQL Libraries
    • 3.7.5.1 About Annotations
    • 3.7.5.2 About Audit
  • 3.7.6 Reviewing Forms Menus
    • 3.7.6.1 Viewing Form Menus
      • 3.7.6.1.1 About Annotations
    • 3.7.6.2 Viewing a Summary of Forms Menus
    • 3.7.6.3 Viewing Form Menu and Program Unit Details
      • 3.7.6.3.1 About Form Menu Details
      • 3.7.6.3.2 About Annotations
      • 3.7.6.3.3 About Program Unit Details
      • 3.7.6.3.4 About Audit
  • 3.7.7 Reviewing Object Libraries
    • 3.7.7.1 About Annotations
    • 3.7.7.2 About Audit
    • 3.7.7.3 Viewing an Uploaded Object Library
      • 3.7.7.3.1 About Annotations
      • 3.7.7.3.2 About Audit
  • 3.7.8 Using Annotations to Track the Conversion Process
• 3.8 Deleting a Migration Project

A Comparing Oracle Forms to Oracle Application Express Components

• A.1 Understanding Oracle Forms Modules
  • A.1.1 About Oracle Forms Components
    • A.1.1.1 Alerts
    • A.1.1.2 Blocks
    • A.1.1.3 Canvases
    • A.1.1.4 Coordinates
    • A.1.1.5 Editors
    • A.1.1.6 List of Values
    • A.1.1.7 Program Units
    • A.1.1.8 Property Classes
    • A.1.1.9 Record Groups
    • A.1.1.10 Triggers
    • A.1.1.11 Visual Attributes
    • A.1.1.12 Windows
  • A.1.2 Understanding Block to Page Region Mappings
    • A.1.2.1 About Single Record Blocks
    • A.1.2.2 About Tabular Forms
    • A.1.2.3 About Master Detail Blocks
    • A.1.2.4 About Non-Database Block
  • A.1.3 About List of Values Implementation
  • A.1.4 Implementing Business Logic
    • A.1.4.1 About Implementing Business Logic
    • A.1.4.2 About Processes
    • A.1.4.3 About Computations
    • A.1.4.4 About Validations
  • A.1.5 About Oracle Reports
  • A.1.6 About PL/SQL Libraries
  • A.1.7 About Forms Menus
  • A.1.8 About Object Libraries

Index