Reviewing Retrieved Reports

Next, review the reports retrieved from the Microsoft Access export. Application Migration identifies invalid reports and lists additional information, such as the report's source type and source name.

After you update the reports, select the ones you want to include in the migration. To include a report, the source of the report must have a status of Valid.

To review retrieved reports:

1. From the project page, click Reports.

   The Reports page appears, showing the status of the objects ready for migration.

   
   Description of the illustration acmg_rpt_pg.gif
   
   

   For each Microsoft Access report, the Reports page shows the following information, if available:

   • Source type:

     • Table

     • Query - The Oracle view that was migrated from the Microsoft Access query.

     • SQL Query - The original Microsoft Access SQL query that the Microsoft Access form is based on. Note that this query has not been parsed by the Oracle Migration Workbench. Therefore, you might must edit it to make it valid Oracle SQL syntax.

     • Nothing - The report has no underlying source type.

   • Source name

   • Status of the report: Valid or Invalid. The source of the report must have a status of Valid before you can select it for migration.

     A report's status is based on two factors: status of its underlying source object and inclusion of the source object in the migration. Specifically, a report has a status of valid if either one of these situations exists:

     • Its Source Type object (table, query, or SQL query) is valid, and it has been included in the migration. Its check box is enabled and can be selected.

     • Its Source type object has a status of valid, but the source object was not included in the migration. Its check box is disabled.

     A report has a status of invalid if either one of these situations exists:

     • No Source Type is listed. Its check box is disabled.

     • Its Source Type object (table, query, or SQL query) is invalid. Its check box is disabled.

2. To run a bulk process that attempts to compile all invalid SQL queries, click Attempt to compile invalid SQL queries at the bottom of the page.

   Using this option can validate some SQL queries that show a status of invalid. Note that SQL queries from Microsoft Access forms are not loaded into the Oracle Migration Workbench and are therefore not parsed.

3. To edit a SQL query:

   1. On the Reports page, click the SQL Query link you want to edit.

   2. Click Validate to find the invalid part of the SQL query.

   3. Update the query and validate it.

   4. When it is validated, click the project name breadcrumb.

   5. To include the validated query, click Reports on the project page to go to the Reports page. Then select the newly validated SQL query in the left column and click Apply Changes.

4. To edit a query:

   1. On the Reports page, click Query for the report you want to edit.

   2. Click Compile to find the invalid part of the query.

   3. Click Access Query to review the initial query and compare it to the converted query.

   4. Update the query and recompile it.

   5. When it is validated, click the Queries breadcrumb.

   6. To include this validated query, select it in the left column on the Queries page and click Apply Changes.

5. To review details about a report, click the link in the Access Report column.

6. To include reports in the migration, select them in the left column.

7. Click Apply Changes to save your selections.