PLL files to. PLD text files. REX , and. A workspace is a virtual private database allowing multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private.
Each workspace has a unique ID and name. An Oracle Application Express administrator can create a workspace manually within Oracle Application Express Administration Services or have users submit requests. Oracle Application Express Administration Services is a separate application for managing an entire Oracle Application Express instance.
Extensive Oracle documentation is available for broadening your knowledge of database concepts and objects. To learn more, see Oracle Database Concepts.
To view a specific documentation library go to:. In a default installation, this number is These defaults are correct at the time of the writing of this document. In Password, enter the Oracle Application Express administrator account password you specified when you installed Oracle Application Express. A Workspace ID must be a positive integer greater than For Identify Administrator, enter the Workspace administrator information and click Next.
Username - Enter the username used to log in to the system. Restrictions include:. First Name - Enter the first or given name to further identify the user optional. Last Name - Enter the last or family name to further identify the user optional.
Default Schema - Specify the default schema used for data browsing, application creation, and SQL script execution. User is an administrator - Specify if this user should have workspace administrator privileges. Administrators are given access to all components. Additionally, they can manage user accounts, groups, and development services.
Components may not be available if they are switched off by Instance Administrators. User is a developer - Specify if this user should have developer privileges.
Account Availability - Select Locked to prevent the account from being used. Select Unlocked to allow the account to be used. Select Yes to require the user to change the password immediately after logging in the first time. Once you create a workspace, you must log in to it using your login credentials that is, the workspace name, user name, and password.
In a web browser, navigate to the Oracle Application Express Login page. By default, Oracle Application Express installs to the following location:. Depending on your setup, you might be required to change your password when you log in for the first time.
In order to start the conversion process, the database objects associated with your Oracle Forms application must reside in the same database as Oracle Application Express. If the database objects associated with your Oracle Forms application do not reside in the same database as Oracle Application Express, you must upload them. The Create Migration Project wizard appears. The steps included in the wizard appear in a flowchart on the left of the page.
Project Name - Enter a unique name. The project name must be unique to your current workspace and should not contain any white spaces. Schema - Select the schema that contains the database schema objects associated with the Oracle Forms application you want to convert. The default schema is the schema associated with your workspace. If multiple schemas are associated with your workspace, all associated schemas appear in the select list, arranged in alphabetical order. When this situation exists, select the schema associated with the Oracle Forms you want to upload.
FMB files to. XML format. The library must be in text format. PLLs to. MMB files to. OLB files to. To add more files, click Upload Another File and repeat the previous steps until all files appear on the Confirm page. Next, use the Project pages to review and edit form attributes and track the manual conversion process.
If a column does not apply to the uploaded file, a 0 displays. A single block can be mapped to a region in Oracle Application Express. A region is an area on a page that serves as a container for content. Each page can have any number of regions. You control the appearance of a region through a specific region template. These blocks can be based on any of the following block data source types: table; procedure; transactional trigger; or subquery.
Blocks included in the DB Blocks count are not control blocks. Note that the associated Database Block property is set to Yes. Triggers - Displays a count of all form-level, block-level and item-level triggers associated with the uploaded FormModule XML file. Program Units - Displays the number of schema objects that enable you to access and manipulate database information.
Many pages in Application Migration Workshop display as interactive reports. You can customize the appearance of these pages using the Search bar at the top of each page. Use the Search bar to create custom searches and customize and filter the information that appears on the page. Select columns to search icon - Resembles a magnifying glass. Click this icon to narrow your search to specific columns.
To search all columns, select All Columns. Text area - Enter case insensitive search criteria wildcard characters are implied and then click Go. Upload File - Add files to your conversion project. See "Uploading Additional Files". Create Application - Create an Oracle Application Express application based on the components included in your conversion project. Note this button only appears after you generate an application.
The Associated Application only displays after you create an application. This region displays application name, number of application pages, last update date, and the user who performed the updates.
Click the application name to link to the Application home page within Application Builder. See "Editing Project Details".
About Forms Conversion links to a page that explains how to convert Oracle Forms applications. See "Setting Up Application Defaults". Components - Lists the number of components that have been uploaded to the project. Completed - Displays a count of components within the conversion process that have been reviewed and have been marked as Complete. Percent Complete - Lists percent of components which have been marked as Complete. MMB file to. To add more files, click Upload and Upload Another and repeat the previous steps until all files appear on the Confirm page.
On the Project page, click the Edit icon to access the Project Details page. The Edit icon resembles a small yellow pencil.
Under Project Details, edit the project name, database schema, specify an associated application, or enter an optional description. Under Component Applicability, specify whether to include specific components in your conversation project. Select Yes or No adjacent to each component type. Use Annotations to track the overall status of form components within the conversion process. Click the number under the column for the appropriate object type.
Alternately, click the File Name to view a report describing the component. To edit a block name, enter a new name in the Title field and click Apply Changes. To include a specific object in your conversion select the Include check box adjacent to the object name and click Apply Changes.
The Block Details page appears. The sections that follow describe each section of the Block Details page. Tracks the overall status of the object within the conversion process. 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 meta data, and extends it with block level post-query trigger source to show derived columns.
Original Query is generated from the data source item table underlying the block and the columns that are referenced on that block. If you select Custom Query , enter the appropriate syntax in the Custom Query field. Only displays if a relationship was identified for the block in the XML file. This section displays the information on that relationship. Displays the items in the block.
Click the Edit icon associated with the item to view item details. Lists the block-level and item-level triggers associated with the block. Click Edit icon to view additional trigger details. Display or hide the Audit section at the bottom of the page to view details about the object creation and last update dates.
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. To edit an item label, enter a new name in the Item Prompt field and click Apply Changes. The Item Details page appears. The sections that follow describe each section of the Item Details page. Use Annotations to track the overall status of the object within the conversion process. Lists each item in the report. Click the Edit icon adjacent to a specific item to display the Data Item Details page.
Lists the summary columns associated with the report. These columns perform a computation on another column's data for example, sum, average, count, minimum, maximum, and percent total.
Display or hide the Audit section at the bottom of the page to view details about the creation and last update dates. PLD and update annotations. However, the files are imported to enable you to review and track them. XML and update annotations. Use Annotations to track the overall status of form within the conversion process. Edit icon - Depending on the Module Type, clicking this icon displays a details page describing the selected menu or program unit. Main Menu - Specifies the name of the individual menu in the Forms Menu that functioned as the main or starting menu at runtime.
Assignee - Displays the person responsible for an object as specified within the Annotations for the object. Tags - Lists tags created to describe the object as specified within the Annotations for the object. Notes Snippet - Displays a snippet of the Notes specified within the Annotations for the object.
A details page appears. Clicking the Edit icon on the Forms Menus page displays a details page. Under Menu Items, click the Edit icon to view details or track the status of a specific menu item.
Use Annotations to track the overall status of an object within the conversion process. The top of the page displays the program unit name, type, and the actual program unit text if applicable. XML and update the annotations.
However the files are imported to enable you to review and track them. On the Workspace home page, click the Applications Migrations link on the right side of the page. To view details about a specific attribute, click the Edit icon. A Details page appears.
Most detail pages that describe a specific object include an Annotations section. Use these fields to determine whether an object should be included in the conversion, assign a priority, track status, assign the object to specific individual, or create notes and tags. Applicable - Tracks whether the object is applicable within the context of the generated Oracle Application Express application. Select Yes or No.
The initial value is determined by the applicability default settings for that component or trigger defined on the Project Details page. Notes Snippet - Displays a snippet of the Notes specified within the Annotations for the object. A details page appears. Clicking the Edit icon on the Forms Menus page displays a details page. Under Menu Items, click the Edit icon to view details or track the status of a specific menu item.
Use Annotations to track the overall status of an object within the conversion process. The top of the page displays the program unit name, type, and the actual program unit text if applicable. XML and update the annotations. However the files are imported to enable you to review and track them. Most detail pages that describe a specific object include an Annotations section.
Use these fields to determine whether an object should be included in the conversion, assign a priority, track status, assign the object to specific individual, or create notes and tags. Applicable - Tracks whether the object is applicable within the context of the generated Oracle Application Express application.
Select Yes or No. The initial value is determined by the applicability default settings for that component or trigger defined on the Project Details page. Complete - Track if the conversion is complete. The values defined in Applicable and Complete are used in determining the percentage complete.
All the Applicable and Complete values can be changed for a block at one time from the Bulk Changes page. Because Oracle Forms have many separate components, it is important to evaluate whether functionality in the original application is either not required or has been replicated in the Oracle Application Express application. Given that the initial design only incorporates a percentage of the required functionality, you can use these fields as a reminder of what must be implemented post-generation.
After you have reviewed and updated the Oracle Forms metadata within your conversion project, you now need to generate the application in Oracle Application Express. When creating an application, a home page is defined by default. You have the option to create additional blank pages so that you can include blank pages or reports and forms on other tables as part of your application.
You can then choose which user interface theme your application should be based on. By default, the application uses one level of tabs. As a shortcut, you can also set some application defaults. These defaults are used whenever you create new applications. On the right side of the project page, click Set Application Defaults in the Tasks list. For information, click Help or click the item label. Clicking the item label opens a separate window describing the item and its options.
Create Application - Choose a creation method. Select Based on Migration Project. Rename a page. Select home page navigation. Click the Home link. The Page Definition appears. Under Navigation, select one of the following:. To display an image on a parent page, click the Page Name link. Scroll down to Page Icon. Select and image from the list list or click the Find icon flashlight to view additional options. Repeat this step for each parent page. If you do not explicitly select an image for a page, the default image displays for that page.
Note that for the image to appear in your application, you must have selected either Vertical Images List or Horizontal Images List for the Home page navigation.
To add additional pages to the application, scroll down to the Add page section. Select a page type and click Add Page. To learn more about each page type, click item Help. Note that the new page appears at the bottom of the list in the Selected Application Objects section.
A theme is a collection of templates that define the layout and style of an application, including buttons and pages. To preview the application, click Run Application. Then, log in using your Oracle Application Express workspace credentials.
To customize your application, scroll down to the Developer toolbar and click Edit Application. You might want to do the following customizations immediately after you generate your application:. Rename the application. Each application has a unique ID, but the conversion project name becomes the application name by default. To more easily identify an application, you might want to change its name to something more meaningful by editing the application attributes.
Change the authentication scheme. By default, the authentication scheme is Application Express authentication. You can change this by editing the application attributes. When you delete a migration project, you delete only the metadata associated with the migration project. Deleting a migration project does not delete or impact applications you have generated from the project or any objects, such as tables or views, in the schemas associated with your workspaces.
On the project page, click Delete Project from the Tasks list on the right. If the generated XML tags are not in English then the file will fail to load. The following table displays a few examples of the changes the tool makes to the name of the file being converted: File name before conversion File name after conversion myForm. The command has the following syntax: frmf2xml [options] file1 [ file Forms2XML [options] file1 [ file The default value NO generates property value names as before.
The tool will stop processing and return the message: If the file file already exists. For example Step 2: Create a Workspace and Add Oracle Application Express Users A workspace is a virtual private database allowing multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private.
On the Login page: In Username, enter admin. Click Login. Tip: If the Oracle Forms application schema exists in the current database, select it. If it does not exist in the current database, follow the steps outlined in "Step 3: Upload Database Objects into the Schema Associated with Your Workspace". Click Manage Workspaces. The Manage Developers and Users page appears. Click Create. Tip: To learn more about a specific attribute, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark.
Logging in to Your Oracle Application Express Workspace Once you create a workspace, you must log in to it using your login credentials that is, the workspace name, user name, and password. Step 3: Upload Database Objects into the Schema Associated with Your Workspace In order to start the conversion process, the database objects associated with your Oracle Forms application must reside in the same database as Oracle Application Express.
To upload database objects associated with your workspace: Create a DDL script. To create a conversion project: Log in the workspace you created for your conversion project as described in "Logging in to Your Oracle Application Express Workspace". On the Application Migrations page, click Create Project. Enter the project details: Project Name - Enter a unique name. Type - Select Forms. Description - Enter a meaningful description for this project.
Note that you must upload the converted Oracle FormModule file first. The Confirm page appears. To add more files, click Upload Another File.
To upload a file, specify the following: File Type - Select the appropriate file type. File - Click Browse and locate the file your want to upload.
Click Upload. Review the project details, and click Finish. The project page appears. Step 5: Review and Edit Forms Metadata Next, use the Project pages to review and edit form attributes and track the manual conversion process.
Percent Complete - Lists percent of components which have been marked as Complete. You can review Forms attributes and track manual conversion by clicking the links on this page. About the Search Bar A Search bar appears at the top of the page.
Description of the illustration search. Search Field - Displays a text field in the search bar in which to enter search criteria. Rows - Displays a select list to select the number of rows to display per page. About the Tasks List The Tasks box displays on the right side of the page and displays the following links: Delete Project deletes the current project. About the Completion Status Box A Completion Status box displays on the right side of the page listing the total number of components, completed components, and percent complete.
Uploading Additional Files To add files to your conversion project: Go to the Project page: On the Workspace home page, click the Applications Migrations link on the right side of the page. Click a project name. The Project page appears. On the Project page, click Upload File. Review the file details, and click Finish.
Modifying Component Applicability Defaults Use the Applicability section to specify whether to include specific components in your conversation project. Description of the illustration applicability. The Form Details page appears. To delete an imported FormModule, click Delete. To download the files associated with this project, click Download.
About Annotations Use Annotations to track the overall status of form components within the conversion process. To view details about a specific object, click the object name or Edit icon.
Viewing and Selecting Blocks To review blocks: Go to the Project page: On the Workspace home page, click the Applications Migrations link on the right side of the page. Click the project name. Click the link under the Blocks column. To view block details information, click the Name link.
To view details about a specific object, click the Name link. About Block Details Lists the details about the block. About Annotations Tracks the overall status of the object within the conversion process. 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 meta data, 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: Select one of the following from the User Query list: Custom Query Enhanced Query Original Query If you select Custom Query , enter the appropriate syntax in the Custom Query field.
Click Apply Changes. Block Items Displays the items in the block. Block Triggers Lists the block-level and item-level triggers associated with the block.
About Audit Display or hide the Audit section to view details about the object creation and last update dates. Click the link under the Items column. To view details about a specific item, click the Item Name link. About Item Details Lists the details about the item. To view the Report Details page: Go to the Project page: On the Workspace home page, click the Applications Migrations link on the right side of the page.
The Report Details page appears. To delete the report, click Delete. To download the report, click the Download link. The sections that follow describe the Report Details page. Report Details Lists details about the current report. About Annotations Use Annotations to track the overall status of the object within the conversion process.
About Data Items Lists each item in the report. About Summary Items Lists the summary columns associated with the report. About Audit Display or hide the Audit section to view details about the creation and last update dates. Selecting R eports to Include Use the Reports page to select reports for inclusion in the conversion process. To view the Report page: Go to the Project page: On the Workspace home page, click the Applications Migrations link on the right side of the page.
The Reports page appears. To include a report, select the check box and click Apply Changes. To delete the library, click Delete.
To download the library, click the Download link. The Edit Imported Form Menu page appears. To delete the MenuModule, click Delete. To download the MenuModule, click the Download link. About Annotations Use Annotations to track the overall status of form within the conversion process. To view the Forms Menus page: Go to the Project page: On the Workspace home page, click the Applications Migrations link on the right side of the page. The Forms Menus page appears and displays the following information: Edit icon - Depending on the Module Type, clicking this icon displays a details page describing the selected menu or program unit.
Name - Display the name of the menu module. Module Name - Displays the name of the module. To view module details, click the Edit icon adjacent to the menu name. About Annotations Use Annotations to track the overall status of an object within the conversion process. About Program Unit Details The top of the page displays the program unit name, type, and the actual program unit text if applicable.
0コメント