Oracle by Example brandingStaging an Application in Oracle Visual Builder Cloud Service

section 0Before You Begin

This tutorial shows you how to stage an application. This tutorial takes approximately 15 minutes to complete.

This is the first tutorial in the Staging and Publishing an Application module. Read the tutorials sequentially.

Background

Oracle Visual Builder Cloud Service is a visual development tool for creating web and mobile applications by simply dragging and dropping user interface (UI) components onto a page. You can create business objects with the click of a button, and you can add data by importing CSV files or XLS spreadsheets to your application. You don't need any programming experience to develop an application.

In this series of tutorials, you will stage and publish the Human Resources (HR) application that you created in the Create your first application module.

The images in this tutorial sequence show the standalone version of Oracle Visual Builder Cloud Service. If you are using the Oracle Integration Cloud version, you will see an additional menu at the top of each page that lets you switch between Visual Builder and Integration Cloud.

Top menu
Description of the illustration vbcs_oic_menu.png

What Do You Need?

  • Access to Oracle Visual Builder Cloud Service
  • A supported browser (see Known Issues for Oracle Application Builder Cloud Service for more information)

section 1Stage the Application

In this section you will learn how to stage the application, so that other users can test its behavior.

  1. Log in to Oracle Visual Builder Cloud Service.
  2. In the Home page, click the Action menu icon for HR Application and select Stage.
    Home page action menu
    Description of the illustration vbcsap_t1_s2.png
  3. In the Stage HR Application 1.0 dialog box, select Populate Stage with Development data and click Stage.
    Stage Application dialog
    Description of the illustration vbcsap_t1_s3.png
    The application takes a few minutes to stage.
    Stage Application dialog progress bar
    Description of the illustration vbcsap_t1_s3b.png
  4. In the Home page, click the STAGED link. Note the icon of the application has changed.
    Staged application on Home page
    Description of the illustration vbcsap_t1_s4.png
    The staged application opens in a new browser tab or window. The tables are populated with the data from Development. When you are done, you can close this tab or window and return to the Home page.
    Staged application
    Description of the illustration vbcsap_t1_s4_result.png

section 2Update the Schema (optional)

You can update your application, and test it by restaging after you make a change. If you don't want to try this right now, skip this and Step 3, and move to Step 4.

Note: After you stage or publish the application, if you make any updates to business objects or the schema of the Development or the Staging database, you will need to stage the application again before you publish it.

  1. In the Home page, click HR Application.
    Staged application on Home page
    Description of the illustration vbcsap_t2_s1.png
  2. If you are not there already, click the Main menu icon and select Page Designer.
    Main menu
    Description of the illustration vbcsap_t2_s2.png
  3. Click the page menu and select Create Department.
  4. Drag and drop a Combo Box component to the Create Department page below the Location field.
    Dragging combo box to page
    Description of the illustration vbcsap_t2_s4.png
  5. Enter the following values in the pop-up box:
    • Label: Manager
    • Business Object: Department (automatically selected)
    • Business Object Field: New (automatically selected)
    • Field Name: ref2Manager (automatically populated)
    • Field Data Type: Reference (automatically selected)
    • Reference Business Object: Employee (automatically selected)
    • Default Displayed Field: Name
    Combo box pop-up dialog
    Description of the illustration vbcsap_t2_s5.png
    Click the OK icon to save the field. The Manager field is also added to the Department business object.
  6. Click the page menu and select Edit Department.
  7. Open the Data palette.
    Data palette
    Description of the illustration vbcsap_t2_s7.png
  8. Drag the Manager field to the Edit Department page below the Location field.
    Dragging field to page
    Description of the illustration vbcsap_t2_s8.png
    The field is automatically added as a drop-down list.
  9. Click the page menu and select Departments.
  10. Select the Departments table and open the Data tab in Table Properties Inspector.
    Departments table Data tab
    Description of the illustration vbcsap_t2_s10.png
  11. Click the Table Columns edit Edit icon.
  12. In the Select Table Columns dialog box, drag the Manager field to Table Columns and click Done.
    Select Table Columns dialog
    Description of the illustration vbcsap_t2_s12.png
  13. The Manager field is now added to the Departments table.
    Departments table
    Description of the illustration vbcsap_t2_s13.png

section 3Restage the Application

Note: You only need to do this step if you have made the changes in Step 2.

  1. Click the Main menu icon and select Stage.
    Main menu
    Description of the illustration vbcsap_t3_s1.png
  2. Select Keep existing data in Stage, then click Stage.
    Stage Application dialog
    Description of the illustration vbcsap_t3_s2.png
  3. Click the Main menu icon and select Home.
  4. On the Home page, click the STAGED link, then click the Departments tab.
    Staged application on Home page
    Description of the illustration vbcsap_t3_s4.png
    The staged application opens with the existing data. The new Manager field has been added. Close the staged application and return to the Home page.

section 4Import Data Into Your Application

  1. Because you made a change to the application schema, the new Manager field is empty. Right-click this link and download the HR_Application-Stage_2.zip file. The zip file contains CSV files of all business objects of the updated HR Application schema.
  2. In the Home page, click HR Application.
    Staged application on Home page
    Description of the illustration vbcsap_t4_s2.png
  3. Click the Main menu icon and select Data Designer.
    Main menu
    Description of the illustration vbcsap_t4_s3.png
  4. Click the Data Manager tile.
    Data Manager tile
    Description of the illustration vbcsap_t4_s4.png
  5. Click the Database menu and select Staging.
    Database menu
    Description of the illustration vbcsap_t4_s5.png
  6. Click Import from File.
    Import from File tile
    Description of the illustration vbcsap_t4_s6.png
  7. In the Confirm Import Data dialog box, click Upload a File. Select the HR Application-Stage 2.zip file, click Open, and then click Import.
    Confirm Import Data dialog
    Description of the illustration vbcsap_t4_s7.png
  8. In the Import from File dialog box, click OK. If you skipped Steps 2 and 3, you'll see warnings, but you can ignore them.
    Import from File dialog
    Description of the illustration vbcsap_t4_s8.png

section 5View the Staged Application

  1. Click the Main menu in the top-left corner and select Home.
    Main menu
    Description of the illustration vbcsap_t5_s1.png
  2. Click the STAGED link.
    Staged application on Home page
    Description of the illustration vbcsap_t5_s2.png
  3. The staged application now shows the data from the imported files. When you are done, you can close this tab or window.
    Staged application
    Description of the illustration vbcsap_t5_s3.png