selectManyShuttle with prepolulated list : ADF

This post talks about how to use af:selectManyShuttle component. Not only how to use it, but to display already selected set of values as pre populated list out of complete list.


So shuttle component has two tags which are of importance. 

<af:selectManyShuttle value = "selected values" has value attribute which refers to selected values and inside this tag there is <f:selectItems  value="all values". This selectItems tag refers to complete set of list.

Contextual Events - Basic Step by Step : ADF

So contextual events is a powerful event/handler framework which is provided by Oracle ADF. This framework facilitates inter region communication. Contextual Events are used in following type of communication.

• Region to Page Communication.
• Page to Region Communication.
• Region to Region Communication.

We will be implementing Region to Region communication.

Use Case 
We will be creating two regions one page. One region displays an employee form with a button named "fire event". Second region just has an output component. So when first name of an employee is changed and fire button is pressed, the changed value of first name of an employee is shown in second region.This is how first region communicated with second region.

So lets get started

Integrating OBIEE with Oracle WebCenter Spaces

This demonstrates how to integrate OBIEE reports with webcenter spaces.

The Pre-requisites are :-

•  WC Spaces is already installed, configured and up and running  with Database – Universal  ontent Management – Enterprise Manager – WebCenter Spaces.
• OBIEE is already installed, configured, and up and running Database – OBI Enterprise Edition.

After this there is a very nice documentation on the OTN. Follow each and every step and you can see OBIEE reports in your Webcenter Spaces pages.

Here is the link OBIEE-WC Integration.

Happy Learning !!

JHeadstart - Forms2ADF migration

This post will be showing how to install Jheadstart extension in jdev and how to use forms2adf generator tool which comes with Jheadstart to convert oracle forms to ADF Screens.

Below is the file consisting of Oracle forms ,Schema and Xml's converted from oracle forms which are used in this tutorial.

Tutorial Files Download

Install Oracle JHeadstart Using “Check for Updates”

Note: In order to install full version of Jheadstart having forms2adf generator tool, one must be connected to oracle intranet while performing following steps.

Oracle JHeadstart is an Oracle JDeveloper extension (or "plug-in") that you install using JDeveloper's "Check for Updates" functionality.

Run the "Check for Updates" wizard

With JDeveloper 11.1.2 running, choose Help | Check for Updates... from the main menu. Click (Next>)on the Welcome page of the Check for Updates dialog.

Select the Source for Extensions

Ensure that you have selected the Open Source and Partners Extensions update center, then click (Next >).

af:query - Removing Attributes from "Add Fields" dropdown in advance search

Ok sometimes we needed to hide some of the attributes from "Add Fields " in the advance search of the af:query panel component.

Lets do this :-

Prerequisites 
Jdev.
HR Schema.
ADF application with Employees View Object.

ADF - Groovy for Total Sum of a Column in a Table

We will be looking in this article as how we can add Total of a column in a table. Very often we require to have total of a column in a table. For example , we might need total sum of Salary column in the table.

We will be leveraging power of Groovy in accomplishing this task.

So lets see how we can do this.

Use Case :- Add a Total Salary Attribute below Salary column in Employees Table.

Model Project

Considering that we have EmployeesView VO object which is based on Employees EO, go to attributes of VO and click add new attribute. Select "Add new Attribute". It will by default be transient. Give this attribute  name as TotalSal.

ADF : Drag and Drop Between Collections(Tables) - Step by Step

ADF provides ability to Drag and Drop items from one place to another place on the page. This simple tutorial will guide how to achieve this.

Requirements

• JDeveloper 11.1.2.2
• Oracle XE database with HR Schema in place.

Use Case

• Two tables are created on the page. Countries Table and Selected Countries Table.
• Rows are dragged from Countries table and dropped into Selected Countries Table
• Row should get added to the Selected Countries Table when dropped into it.
• Row should be deleted from source Countries table when successfully dropped into destination Selected Countries Table.