Before 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.

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)
Stage
the Application
In this section you will learn how to stage the application, so that other users can test its behavior.
- Log in to Oracle Visual Builder Cloud Service.
- In the Home page, click the
icon for HR Application and select Stage.
Description of the illustration vbcsap_t1_s2.png - In the Stage HR Application 1.0 dialog box, select Populate
Stage with Development data and click Stage.
Description of the illustration vbcsap_t1_s3.png Description of the illustration vbcsap_t1_s3b.png - In the Home page, click the STAGED link.
Note the icon of the application has changed.
Description of the illustration vbcsap_t1_s4.png Description of the illustration vbcsap_t1_s4_result.png
Update
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.
- In the Home page, click HR Application.
Description of the illustration vbcsap_t2_s1.png - If you are not there already, click the
icon and select Page Designer.
Description of the illustration vbcsap_t2_s2.png - Click the page menu and select Create Department.
- Drag and drop a Combo Box component to the
Create Department page below the Location field.
Description of the illustration vbcsap_t2_s4.png - 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
Description of the illustration vbcsap_t2_s5.png icon to save the field. The Manager field is also added to the Department business object.
- Label:
- Click the page menu and select Edit Department.
- Open the Data palette.
Description of the illustration vbcsap_t2_s7.png - Drag the Manager field to the Edit
Department page below the Location field.
Description of the illustration vbcsap_t2_s8.png - Click the page menu and select Departments.
- Select the Departments table and open the Data tab
in Table Properties Inspector.
Description of the illustration vbcsap_t2_s10.png - Click the Table Columns edit
icon.
- In the Select Table Columns dialog box, drag the Manager
field to Table Columns and click
Done.
Description of the illustration vbcsap_t2_s12.png - The Manager field is now added to the
Departments table.
Description of the illustration vbcsap_t2_s13.png
Restage
the Application
Note: You only need to do this step if you have made the changes in Step 2.
- Click the
icon and select Stage.
Description of the illustration vbcsap_t3_s1.png - Select Keep existing data in Stage, then
click Stage.
Description of the illustration vbcsap_t3_s2.png - Click the
icon and select Home.
- On the Home page, click the STAGED link,
then click the Departments tab.
Description of the illustration vbcsap_t3_s4.png
Import
Data Into Your Application
- 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. - In the Home page, click HR Application.
Description of the illustration vbcsap_t4_s2.png - Click the
icon and select Data Designer.
Description of the illustration vbcsap_t4_s3.png - Click the Data Manager tile.
Description of the illustration vbcsap_t4_s4.png - Click the Database menu and select Staging.
Description of the illustration vbcsap_t4_s5.png - Click Import from File.
Description of the illustration vbcsap_t4_s6.png - 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.Description of the illustration vbcsap_t4_s7.png - 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.
Description of the illustration vbcsap_t4_s8.png
View
the Staged Application
- Click the
in the top-left corner and select Home.
Description of the illustration vbcsap_t5_s1.png - Click the STAGED link.
Description of the illustration vbcsap_t5_s2.png - The staged application now shows the data from the imported
files. When you are done, you can close this tab or window.
Description of the illustration vbcsap_t5_s3.png