Contents

Title and Copyright Information

Preface

• Topic Overview
• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with Application Migration Workshop

• About Migrating a Microsoft Access Application
  • Preparation Checklist for Migrating Microsoft Access Applications
  • Analyze Your MDB File in Microsoft Access
  • About the Microsoft Access Migration to Oracle Application Express Forum
• About Converting an Oracle Forms Application
  • Preparation Checklist for Converting Oracle Forms Applications
  • About the Oracle Application Express Forum

2 Overview of the Migration Process

• Why Migrate to Oracle Application Express?
• Before Starting the Conversion Process
• Evaluating Whether to Convert or Build an Application from Scratch
• Understanding What Oracle Application Express Application Conversion is Not
• Key Differences with Oracle Application Express
  • Stateless Web Applications
  • Evaluating User Interface Design
  • About Business Logic Replication
• Creating an Oracle Application Express Migration Project

3 Migrating a Microsoft Access Application

• How to Migrate a Microsoft Access Application
• Step 1: Export Microsoft Access Metadata
• Step 2: Migrate the Microsoft Access Database to Oracle
  • Verifying If Generated DDL Executes Against the Appropriate Instance
• Step 3: Create a Workspace and Add Oracle Application Express Users
  • Creating a Workspace Manually
  • Creating Oracle Application Express Users
  • Logging In To Your Oracle Application Express Workspace
• Step 4: Create a Migration Project
  • About the Application Migrations
    • Utilizing Interactive Reports
• Step 5: Review Your Retrieved Objects
  • Reviewing Retrieved Tables
  • Reviewing Retrieved Queries
  • Reviewing Retrieved Forms
  • Reviewing Retrieved Reports
  • Reviewing Database, Module, and Pages Information
• Step 6: Generate the Oracle Application Express Application
• Deleting a Migration Project

4 Converting an Oracle Forms Application

• How to Convert Your Application
• Step 1: Convert Oracle Forms to XML
  • Converting FormModules, ObjectLibraries, or MenuModules to XML
    • About the Forms2XML Conversion Tool
    • Using the Forms2XML Conversion Tool From a Command Line
    • Using the Forms2XML Conversion Tool in a Java Program
  • Converting a PL/SQL Library
  • Converting an Oracle Report to XML
• Step 2: Create a Workspace and Add Oracle Application Express Users
  • Creating a Workspace Manually
  • Creating Oracle Application Express Users
  • Logging In To Your Oracle Application Express Workspace
• Step 3: Upload Database Objects into the Schema Associated with Your Workspace
• Step 4: Create a Conversion Project
• Step 5: Review and Edit Forms Metadata
  • About the Application Migrations Page
    • Understanding the Project Page
    • Uploading Additional Files
  • Editing Project Details
    • Modifying Component Applicability Defaults
  • Reviewing Forms Modules
    • Viewing an Imported FormModule
    • Viewing Object Metadata and Selecting Specific Objects
    • Viewing and Selecting Blocks
    • Viewing and Selecting Items
  • Reviewing Oracle Reports
    • Viewing Reports
    • Selecting Reports to Include
  • Reviewing PL/SQL Libraries
    • About Annotations
    • About Audit
  • Reviewing Forms Menus
    • Viewing Form Menus
    • Viewing a Summary of Forms Menus
    • Viewing Form Menu and Program Unit Details
  • Reviewing Object Libraries
    • About Annotations
    • About Audit
  • Using Annotations to Track the Conversion Process
    • Why Use Annotations?
• Step 6: Generate the Oracle Application Express Application
  • Setting Up Application Defaults
  • Creating an Application
• Deleting a Migration Project

A Oracle Forms Generation Capabilities and Workarounds

• Oracle Forms Modules
  • Overview of Oracle Forms Components
    • Alerts
    • Blocks
    • Canvases
    • Coordinates
    • Editors
    • List of Values
    • Program Units
    • Property Classes
    • Record Groups
    • Triggers
    • Visual Attributes
    • Windows
  • About Generated Applications
    • Primary Key Assumptions
  • Block to Page Region Mappings
    • Single Record Block
    • Tabular Form
    • Master Detail Blocks
    • Non-Database Block
  • List of Values Implementation
  • Implementing Business Logic
    • Processes
    • Computations
    • Validations
• Oracle Reports
• PL/SQL Libraries
• Forms Menus
• Object Libraries

Index