1/9
Contents
Title and Copyright Information
Preface
Topic Overview
Audience
Documentation Accessibility
Related Documents
Conventions
1
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
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
Scripting on this page enhances content navigation, but does not change the content in any way.