Preface
Topic Overview
Audience
Documentation Accessibility
Related Documents
Conventions
Getting Started with Application Migrations 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
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
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 Project Page
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
Converting an Oracle Forms Application
How to Convert Your Application
Step 1: Convert Oracle Forms to XML
Converting FormModules, ObjectLibraries, or MenuModules to XML
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 Project Page
Editing Project Details
Reviewing Forms Modules
Reviewing Oracle Reports
Reviewing PL/SQL Libraries
Reviewing Forms Menus
Reviewing Object Libraries
Using Annotations to Track the Conversion Process
Step 6: Generate the Oracle Application Express Application
Setting Up Application Defaults
Creating an Application
Deleting a Migration Project
Oracle Forms Generation Capabilities and Workarounds
Oracle Forms Modules
Overview of Oracle Forms Components
About Generated Applications
Block to Page Region Mappings
List of Values Implementation
Implementing Business Logic
Oracle Reports
PL/SQL Libraries
Forms Menus
Object Libraries
Index