3.7.3 Reviewing Forms Modules

From the Project page you can browse the objects included in your uploaded Oracle FormModule XML file (for example, myForm_fmb.xml).

3.7.3.1 Viewing an Imported FormModule

To view an imported FormModule:

  1. From the Application Migrations page, click the project name.
  2. Click the Edit icon to the left of the XML file name (for example, myForm_fmb.xml).

    The Form Details page appears.

  3. To delete an imported FormModule, click Delete.
  4. To download the files associated with this project, click Download.

Example 3-1 About Annotations

Use Annotations to track the overall status of form components within the conversion process.

See Also:

"Using Annotations to Track the Conversion Process"

3.7.3.2 Viewing Object Metadata and Selecting Specific Objects

To review object metadata:

  1. From the Application Migrations page, click the project name.
  2. Click the number under the column for the appropriate object type. Alternately, click the File Name to view a report describing the component.

    Clicking a number displays a listing of the object type.

  3. To include blocks, items, and LOVs select the Include check box adjacent to the object name and click Apply Changes.
  4. To view details about a specific object, click the object name or Edit icon.

3.7.3.3 Understanding Viewing and Selecting Blocks

To review blocks:

  1. From the Application Migrations page, select the project name.
  2. Click the link under the Blocks column.

    A listing of blocks appears.

    Tip:

    To displays columns not displayed by default, click the Actions menu and select Select Columns.

  3. To edit a block name, enter a new name in the Title field and click Apply Changes.
  4. To include a specific object in your conversion select the Include check box adjacent to the object name and click Apply Changes.
  5. To view details about a specific object, click the Name link.

    The Block Details page appears. The sections that follow describe each section of the Block Details page.

See Also:

"Using Interactive Reports" in Oracle Application Express End User's Guide.

3.7.3.3.1 About Block Details

Lists the details about the block.

3.7.3.3.2 About Annotations

Use Annotations to track the overall status of the object within the conversion process.

See Also:

"Using Annotations to Track the Conversion Process"

3.7.3.3.3 About Application Express Page Query

Oracle Forms can be based on database blocks which correspond to database tables or views. The enhanced query builds a query based on the database block and database item metadata, and extends it with block level post-query trigger source to show derived columns

Enhanced Query is the original query with the POST-QUERY logic included. Original Query is generated from the data source item (table) underlying the block and the columns that are referenced on that block

To specify the type of query to use:

  1. Select one of the following from the User Query list:

    • Custom Query

    • Enhanced Query

    • Original Query

  2. If you select Custom Query, enter the appropriate syntax in the Custom Query field.

  3. Click Apply Changes.

3.7.3.3.4 Relation Details

Only displays if a relationship was identified for the block in the XML file. This section displays the information on that relationship.

3.7.3.3.5 Block Items

Displays the items in the block. Click the Edit icon associated with the item to view item details.

3.7.3.3.6 Block Triggers

Lists the block-level and item-level triggers associated with the block. Click Edit icon to view additional trigger details.

3.7.3.3.7 About Audit

Display or hide the Audit section at the bottom of the page to view details about the object creation and last update dates.

3.7.3.4 Viewing and Selecting Items

To review items:

  1. From the Application Migrations page, click the project name.
  2. Click the link under the Items column.

    A listing of items appears. Click the Actions icon on the Search bar to view additional information which is not visible in the default report.

  3. To edit an item label, enter a new name in the Item Prompt field and click Apply Changes.
  4. To include a specific object in your conversion select the Include check box adjacent to the object name and click Apply Changes.
  5. To view details about a specific item, click the Item Name link.

    The Item Details page appears. The sections that follow describe each section of the Item Details page.

3.7.3.4.1 About Item Details

Lists the details about the item.

3.7.3.4.2 About Annotations

Use Annotations to track the overall status of the object within the conversion process.

See Also:

"Using Annotations to Track the Conversion Process"

3.7.3.4.3 About Audit

Display or hide the Audit section at the bottom of the page to view details about the object creation and last update dates.