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
Scripting on this page enhances content navigation, but does not change the content in any way.