1/10

Contents

Title and Copyright Information

Preface

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

Changes in This Release

• Changes in Oracle Application Express Release 4.2

1 Getting Started with Application Migration Workshop

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

3 Migrating a Microsoft Access Application

• 3.1 How to Migrate a Microsoft Access Application
• 3.2 Export Microsoft Access Metadata
• 3.3 Migrate the Microsoft Access Database to Oracle
  • 3.3.1 Verifying If Generated DDL Executes Against the Appropriate Instance
• 3.4 Create a Workspace and Add Oracle Application Express Users
  • 3.4.1 Creating a Workspace Manually
  • 3.4.2 Creating Oracle Application Express Users
  • 3.4.3 Logging In To Your Oracle Application Express Workspace
• 3.5 Create a Migration Project
  • 3.5.1 About the Application Migrations Page
    • 3.5.1.1 Utilizing Interactive Reports
• 3.6 Review Your Retrieved Objects
  • 3.6.1 Reviewing Retrieved Tables
  • 3.6.2 Reviewing Retrieved Queries
  • 3.6.3 Reviewing Retrieved Forms
  • 3.6.4 Reviewing Retrieved Reports
  • 3.6.5 Reviewing Database, Module, and Pages Information
• 3.7 Generate the Oracle Application Express Application
• 3.8 Deleting a Migration Project

4 Converting an Oracle Forms Application

• 4.1 How to Convert Your Application
• 4.2 Convert 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 Create a Workspace and Add Oracle Application Express Users
  • 4.3.1 Creating a Workspace Manually
  • 4.3.2 Creating Oracle Application Express Users
  • 4.3.3 Logging In To Your Oracle Application Express Workspace
• 4.4 Upload Database Objects into the Schema Associated with Your Workspace
• 4.5 Create a Conversion Project
• 4.6 Review and Edit Forms Metadata
  • 4.6.1 About the Application Migrations Page
    • 4.6.1.1 Understanding 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 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 Generate the Oracle Application Express Application
  • 4.7.1 Setting Up Application Defaults
  • 4.7.2 Creating an Application
• 4.8 Deleting a Migration Project

A Oracle Forms Generation Capabilities and Workarounds

• A.1 Oracle Forms Modules
  • A.1.1 Overview of 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 Primary Key Assumptions
  • A.1.3 Block to Page Region Mappings
    • A.1.3.1 Single Record Block
    • A.1.3.2 Tabular Form
    • A.1.3.3 Master Detail Blocks
    • A.1.3.4 Non-Database Block
  • A.1.4 List of Values Implementation
  • A.1.5 Implementing Business Logic
    • A.1.5.1 Processes
    • A.1.5.2 Computations
    • A.1.5.3 Validations
• A.2 Oracle Reports
• A.3 PL/SQL Libraries
• A.4 Forms Menus
• A.5 Object Libraries

Index