Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 5.0

1 Getting Started with Application Migration Workshop

• 1.1 Understanding How to Migrate a Microsoft Access Application
  • 1.1.1 About Migrating a Microsoft Access Application
  • 1.1.2 Preparation Checklist for Migrating Microsoft Access Applications
  • 1.1.3 Analyzing Your MDB File in Microsoft Access
  • 1.1.4 About the Microsoft Access Migration to Oracle Application Express Forum
• 1.2 Understanding How to Convert an Oracle Forms Application
  • 1.2.1 About Creating an Oracle Forms Application
  • 1.2.2 Preparation Checklist for Converting Oracle Forms Applications
• 1.3 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 Determining Whether to Convert or Build an Application from Scratch
• 2.4 Understanding What an Oracle Application Express Application Conversion is Not
• 2.5 Understanding the Key Differences with Oracle Application Express
  • 2.5.1 About Stateless Web Applications
  • 2.5.2 About Evaluating User Interface Design
  • 2.5.3 About Business Logic Replication
• 2.6 Creating an Oracle Application Express Migration Project
  • 2.6.1 About Data Structures
  • 2.6.2 About Creating a Project

3 Migrating a Microsoft Access Application

• 3.1 How to Migrate a Microsoft Access Application
  • 3.1.1 About the Process of Migrating a Microsoft Access Application
• 3.2 Exporting Microsoft Access Metadata
  • 3.2.1 About Downloading the Exporter Tool
  • 3.2.2 Exporter Tool System Requirements
  • 3.2.3 Downloading the Exporter Tool
  • 3.2.4 Exporting Your Metadata
• 3.3 Migrating the Microsoft Access Database to Oracle
  • 3.3.1 Migrating the Database to Oracle
  • 3.3.2 Verifying If Generated DDL Executes Against the Appropriate Instance
• 3.4 About Creating a Workspace and Adding Oracle Application Express Users
• 3.5 Creating a Migration Project
• 3.6 Reviewing Retrieved Objects
  • 3.6.1 About Reviewing Retrieved Objects
  • 3.6.2 Reviewing Retrieved Tables
  • 3.6.3 Reviewing Retrieved Queries
  • 3.6.4 Reviewing Retrieved Forms
  • 3.6.5 Reviewing Retrieved Reports
  • 3.6.6 Reviewing Database, Module, and Pages Information
• 3.7 Generating an Oracle Application Express Application
  • 3.7.1 About Generating the Oracle Application Express Application
  • 3.7.2 Setting Up Application Defaults
  • 3.7.3 Generating an Application
• 3.8 Deleting a Migration Project

4 Converting an Oracle Forms Application

• 4.1 How to Convert Your Application
  • 4.1.1 About the Process of Converting Oracle Forms
• 4.2 Converting Oracle Forms to XML
  • 4.2.1 Converting FormModules, ObjectLibraries, or MenuModules to XML
    • 4.2.1.1 About the Forms2XML Conversion Tool
    • 4.2.1.2 Using the Forms2XML Conversion Tool From a Command Line
    • 4.2.1.3 Using the Forms2XML Conversion Tool in a Java Program
  • 4.2.2 Converting a PL/SQL Library
  • 4.2.3 Converting an Oracle Report to XML
• 4.3 About Creating a Workspace and Adding Oracle Application Express Users
• 4.4 Uploading Database Objects into the Schema Associated with Your Workspace
• 4.5 Creating a Conversion Project
• 4.6 Reviewing and Editing Forms Metadata
  • 4.6.1 Understanding the Application Migrations Page
    • 4.6.1.1 Using the Project Page
    • 4.6.1.2 Uploading Additional Files
  • 4.6.2 Editing Project Details
  • 4.6.3 Reviewing Forms Modules
    • 4.6.3.1 Viewing an Imported FormModule
    • 4.6.3.2 Viewing Object Metadata and Selecting Specific Objects
    • 4.6.3.3 Understanding Viewing and Selecting Blocks
    • 4.6.3.4 Viewing and Selecting Items
  • 4.6.4 Reviewing Oracle Reports
    • 4.6.4.1 Viewing Reports
    • 4.6.4.2 Selecting Reports to Include
  • 4.6.5 Reviewing PL/SQL Libraries
    • 4.6.5.1 About Annotations
    • 4.6.5.2 About Audit
  • 4.6.6 Reviewing Forms Menus
    • 4.6.6.1 Viewing Form Menus
    • 4.6.6.2 Viewing a Summary of Forms Menus
    • 4.6.6.3 Viewing Form Menu and Program Unit Details
  • 4.6.7 Reviewing Object Libraries
    • 4.6.7.1 About Annotations
    • 4.6.7.2 About Audit
    • 4.6.7.3 Viewing an Uploaded Object Library
  • 4.6.8 Using Annotations to Track the Conversion Process
    • 4.6.8.1 Why Use Annotations?
• 4.7 Generating the Oracle Application Express Application
  • 4.7.1 About Generating the Oracle Application Express Application
  • 4.7.2 Setting Up Application Defaults
  • 4.7.3 Creating an Application
• 4.8 Deleting a Migration Project

A Oracle Forms Generation Capabilities and Workarounds

• 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 About Generated Applications
    • A.1.2.1 About Support for JavaScript and Ajax
    • A.1.2.2 About Default Form Capabilities
    • A.1.2.3 About Primary Key Assumptions
  • A.1.3 Understanding Block to Page Region Mappings
    • A.1.3.1 About Block to Page Region Mappings
    • A.1.3.2 About Single Record Blocks
    • A.1.3.3 About Tabular Forms
    • A.1.3.4 About Master Detail Blocks
    • A.1.3.5 About Non-Database Block
  • A.1.4 About List of Values Implementation
  • A.1.5 Implementing Business Logic
    • A.1.5.1 About Implementing Business Logic
    • A.1.5.2 About Processes
    • A.1.5.3 About Computations
    • A.1.5.4 About Validations
• A.2 About Oracle Reports
• A.3 About PL/SQL Libraries
• A.4 About Forms Menus
• A.5 About Object Libraries

Index