Creating Data Control & Task flow in Webcenter Portal Builder

Prerequisite – Webcenter portal and Webcenter Spaces should be installed and there schemas as well.

Database should be installed in database. For this sample demo –I created sample tables in Webcenter schema .

You can connect to database using creating new connection

→ Please find attached script and execute in the database.

→ Open the link – http://localhost.silbury:8888/webcenter (Might be localhost for you)

→ Go to Shared Asset

→ Go to Data Control – Create

→ Click continue.

→ Select WebCenterDs – enter password- enter sql query as below in screenshot

→ Click Create.And make available for using in catalog .

→ Now Click on Taskflow -Create

→ Make task flow available

→ Click on Edit and Integration

→ Click open Data Control

→ Click Open EmployeeDC

→ Add Employee DC

→ Click On as Table

→ Click on default next and then create. Table will be there in Taskflow. Click Save then Close.

→. Now click on Portals on top Menu -< Create Portal

->Click Create

→ Click View your portal

→ Edit you page as below to add content

→ Click Open on UI components

→ Click Open On task Flows

→ Add Employees and save.

→ Click Save and then click on View Portal

→ This is final portal

→ Can Create more page like this.

→ If you want to navigate back to Data control or change query or add new task flow -click on edit page then Administer Portal

→ There you can edit data control and task flows.

Watch Video here

Happy learning with Vinay Kumar

creating a basic skeleton to invoke an AM in Java Class in Oracle ADF

Here is a very cool way of quickly creating a basic skeleton to invoke an AM :

1) Create a Test java class.

2) Inside the mail class, type in keyword ‘bc4jclient’ :

package model;

public class Class1 {
public Class1() {

public static void main(String[] args) {
Class1 class1 = new Class1();


3) Press Ctrl + Enter.4) Voila!! A small skeleton to invoke AM gets created:

package model;

import oracle.jbo.*;
import oracle.jbo.client.Configuration;
import oracle.jbo.domain.*;
import oracle.jbo.domain.Number;

public class Class1 {
public Class1() {

public static void main(String[] args) {
Class1 class1 = new Class1();

String amDef = "test.TestModule";
String config = "TestModuleLocal";
ApplicationModule am = Configuration.createRootApplicationModule(amDef, config);
ViewObject vo = am.findViewObject("TestView");
// Work with your appmodule and view object here
Configuration.releaseRootApplicationModule(am, true);

Creating new row of view object in ADF | Techartifact

Requirment – Creating new rows through the view object

Solution-Create a new view row by calling createRow() on the view object as shown in the following code snippet:

/**The createEmployee is a custom method defined in application
* module implementation class.

public void createEmployee () {
//Get the view object
ViewObject employee= findViewObject("EmployeeVO");
// Create a row and fill in the columns.
Row row = employee.createRow();
row.setAttribute("Name", "Vinay");
row.setAttribute("EmpId", 1);
//Insert row in to the default row set

You can also use createAndInitRow(AttributeList initVals) on the view object to create a new view row. This API allows you to initialize the row with an attribute list.