Description
In this course, you will :
- Learn how to work with Oracle Visual Builder.
- Oracle Visual Builder is used to create web applications.
- Oracle Visual Builder is used to create web pages.
- Using VBCS, create extensions for Fusion Cloud applications, integration, and so on.
Syllabus :
1. Learn VBCS by building Employee web application
- Create a new Visual Builder application
- Create Business Objects and relationships
- Create Business Objects with Business Diagram
- Create collapsible layout with oj-collapsible element
- Adding fields to accept search parameters within form layout
- Make input field as required and also mark with * symbol
- Add table component to display employee data with basic filter criteria in SDP
- Accepting search criteria from user and filtering employee records in table
- Create JavaScript function to build query parameter for filter criteria
- Modify JavaScript and reset SDP variable
- Add loading pop-up screen with progress bar to a web page
- Modify table column and make field as hyperlink and disable column sortable
- Add dialog to display more details for an employee on click on hyperlink
- (Assignment) Add 2 more fields in dialog and add margin at top of table
- Export data to a CSV file on click of button
- Overview on Shell Page (Root Page) and fragments
- Add Company logo and modify company name in web page header
- Modify button in header and route to YouTube / Google / Web in shell page
- Modify web page footer section
- Stage and Publish Web Application, get live URL
2. Overview on managing application
- How to edit an application post publishing or create new version
- Lock and unlock live web application
- Rename an application
- Duplicate an application
- Delete an application
- Allow anonymous access to application for an user
- Add anonymous user to Business Object's role based security
3. Overview of Business Object in Visual Builder
- Add a row (record) manually
- Create a formula field
- Create Aggregation field
- Create field based on formula with iterator
- Create field based on formula with conditional iterator
- Business Rule : Object Trigger
- Business Rule : Field Trigger
- Business Rule : Object Validator
- Business Rule : Field Validator
- Business Rule : Object Function
- REST API's for Business Object
4. Enhance Employee application to onboard a new employee
- Create a page to input details for a new employee
- Create a object variable and assign the values entered by user
- Create a Submit button and style with app.css file
- Create a event on click of button and insert employee details in Business Object
- Customize Department Select (Single) component with table collection template
- Reset employee details variable on success and add margin top to form layout
- Restrict min and max hire date for selection in UI
- Add navigation list to the shell page
- Add on selection event for navigation list to navigate between the pages
5. Embed Google maps and Google Image
-
Embed Google Map and Google Image in Visual Builder web page
6. Embed Visual Builder Web Page in Oracle SaaS / Fusion Cloud
- Embed Visual builder page in SaaS / Fusion with Page Integration
- Assignment: Embed Employee application in Fusion with customized URL
7. JWT token based authentication between Oracle SaaS (Fusion) and Visual Builder
- Decode JWT token and username and learn to create Pass on value variable
- Use Fusion HCM REST API to authenticate the user
- Hide the navigation list for Unauthorized users by removing HTML elements
8. Enhance Employee application to manage employees
- Create a new employee management page and add navigation
- Add editable table collection to edit details
- Create beforeRowEdit and beforeRowEditEnd events on editable table
- Save employee details edited back to business object
- (Assignment) Styling manage employee page
9. Working with REST API's
-
Display the flags and name of all the countries across the globe with REST API
10. Working with Integration
-
Invoke Integration exposed as REST API over GET / POST http methods
11. Working with SOAP web service
-
Get BIP report data or Invoke any SOAP web service in VBCS with Integration
12. Working with Database (DBaaS / ATP)
-
Fetch data from database (ATP) and populate the details in list view
13. Let's build Mobile Application
- Build your first Mobile application
- Create a Progressive Web App (PWA) and install on Android/ iOS/ other devices
- Customize app name, avatar,..etc
- Add bar charts for departments page
- Remove redundant SDP variables to fetch and store same source data
- Replace Service Data Provider with Array Data Provider variable
- Display more than 1 series in a group while plotting a bar chart
- Customize launcher icon and splash screen images for Android and iOS
14. Use Case 01: Implement Pagination
- (Optional) Build integration to fetch database records in batches
- Add Pagination to table component in Visual Builder application with SDP
- Add Pagination to table component in Visual Builder application with ADP
15. Use Case 02: Working with Files
-
Bulk insertion with CSV file, download, reset, upload to BO
16. Use Case 03: Working with components
-
Validation of form fields
17. Use Case 04: External JavaScript Library
-
Refer any external JavaScript library in VBCS application
18. Mini Project 1 : Leave Application (Integration + Process + Visual Builder)
- Create leave application business object and update details with OIC Integration
- Assignment: Modify integration to selectively update fields in business object
- Build a process application for leave approval use case
- Build Visual Builder page for leave application and to start the process
- Test and validate the project end to end