Showing Parameters passed in the URL in a page – Oracle ADF

In ADF Application we can read the parameters passed in the URL and display them as an output text using a simple EL (Expression language).


Sample Jspx page:


Page in browser:

2If your requirement is to show the URL passed in parameter data in the input text field and if there is no parameter data passed then show it as an input text field, then you can use below given EL which is having the ternary condition.

<af:inputText value=”#{param.dept eq null? bindings.DepartmentId.inputValue: param.dept}” />

Browser output when URL:


Browser output when URL:



This post is intended to show how the requirement can be fulfilled with the help of EL.


Invoke a WebService with the Inserted Rows data of Excel sheet in ADF-DI:

In ADF-DI you don’t have any direct option available to get the control over all the inserted rows to invoke WS (Web Service). So you must implement it with the help of programmatic approach.

First what you need to understand is, If you want to upload 100 records of data from Excel sheet to DB, first you must set a property [InsertBeforeRowActionID : ‘CreateInsert‘] which means before reading each row of data, a new empty row object is created and the data of that row is stored into that row object cache. The same thing happens for all the rows. Once all the rows of Excel sheet are read, the cached data has to be committed to DB. So set the property [CommitBatchActionID: Commit] which inserts the cached data to DB.

The above properties must be set to upload data to DB from Excel sheet. To achieve this your page definition file must contain the bindings [tree binding, Commit, CreateInsert bindings]

To get the Handle over the Excel sheet data, you must set below proprieties.
Property [InsertBeforeRowActionID : ‘eachRowInvokeAM‘] which is being used to Invoke a custom method where current row data can be read and stored to a List. This will repeat for all the rows.
Then set the property [SuccessActionID : afterAllRowsInvokeAM] for a ribbon command ‘Update‘. This triggers the custom method ‘afterAllRowsInvokeAM’ after successful Insert/Update to DB. In this custom method, you can work with the list which has the data of all rows inserted in the Update operation. Using this data you can Invoke a Web Service.

You must write your custom methods in AMImpl class. ADF12c supports only AMImpl class methods, where as ADF11g supports AMImpl & VOImpl class methods to invoke.

Eg: Let’s take an example, where we insert a record to Departments table. And after all the rows got inserted to DB from ADF-DI Excel sheet a webservice should be invoked with the inserted data as input. For this set the below properties.

InsertBeforeRowActionID : ‘CreateInsert’
InsertBeforeRowActionID : ‘eachRowInvokeAM’
InsertRowEnabled: True
CommitBatchActionID: Commit
RibbonCommand- Update -> SelectActionSet -> ActionOptions -> SuccessActionID : afterAllRowsInvokeAM

Custom methods given above are [‘eachRowInvokeAM’, ‘afterAllRowsInvokeAM’] are mehtods created in AMImpl class .
Another class also created ‘Dept’ which is a Pojo class with the column names as variables and having parameterized constructor.
In the AMImpl class, a list is created of type ‘Dept’ pojo class. And the parameterized constructor is being invoked to insert the department type object to the list. Two custom methods are created in it [‘eachRowInvokeAM’, ‘afterAllRowsInvokeAM’] and are exposed and then added to the page definition file as method bindings. During each row insert ‘eachRowInvokeAM’ will be invoked and that row data in inserted to the List. Once the commit operation is susccessful another method ‘afterAllRowsInvokeAM’ will be invoked where the list data is read and used as input to Invoke the webservice.

The page definition file should be:


Excel properties should be:



package model;



import java.util.ArrayList;
import java.util.List;

import model.common.AppModule;

import oracle.jbo.Row;
import oracle.jbo.server.ApplicationModuleImpl;
import oracle.jbo.server.ViewLinkImpl;
import oracle.jbo.server.ViewObjectImpl;

public class AppModuleImpl extends ApplicationModuleImpl implements AppModule {

/* Custom Code */
List dept = new ArrayList();
public void eachRowInvokeAM(){
System.out.println("Entered before Upload..");
System.out.println("row count:"+getDepartmentsView1().getRowCount());
Row r = getDepartmentsView1().getCurrentRow();

int deptId = Integer.valueOf(r.getAttribute("DepartmentId").toString());
String deptName = r.getAttribute("DepartmentName").toString();
int locId = Integer.valueOf(r.getAttribute("LocationId").toString());
int mgrId = Integer.valueOf(r.getAttribute("ManagerId").toString());

//adding current row to list
dept.add(new Dept(deptId, deptName, locId, mgrId));

public void afterAllRowsInvokeAM() {
System.out.println("after Insert success..");
System.out.println("rows inserted:"+dept.size());
for(int i=0; i< dept.size(); i++){
System.out.println("Now Invoking WebService");
try {
http_client();  // Invoke Webserive method
} catch (Exception e) {

public static void http_client() throws Exception {
System.out.println("Invoke service using direct HTTP call with Basic Auth");
String payload =
"\n" +
" \n" +
" \n" +
" \n" +
" INR\n" +
" USD\n" +
" \n" +
" \n" +

httpPost("" + "?invoke=", payload);
private static String httpPost(String destUrl, String postData) throws Exception {
URL url = new URL(destUrl);
HttpURLConnection conn = (HttpURLConnection)url.openConnection();
if (conn == null) {
return null;
conn.setRequestProperty("Content-Type", "text/xml; charset=UTF-8");

//byte[] authBytes = authStr.getBytes("UTF-8");
//String auth =;
// conn.setRequestProperty("Authorization", "Basic " + auth);

System.out.println("post data size:" + postData.length());

OutputStream out = conn.getOutputStream();
OutputStreamWriter writer = new OutputStreamWriter(out, "UTF-8");

System.out.println("connection status: " + conn.getResponseCode() +
"; connection response: " +

InputStream in = conn.getInputStream();
InputStreamReader iReader = new InputStreamReader(in);
BufferedReader bReader = new BufferedReader(iReader);

String line;
String response = "";
System.out.println("==================Service response: ================ ");
while ((line = bReader.readLine()) != null) {
response += line;

return response;

package model; public class Dept { int DepartmentId; String DepartmentName; int LocationId; int ManagerId; public Dept(int DeptId, String DeptName, int LocId, int MgrId) { //super(); this.DepartmentId = DeptId; this.DepartmentName = DeptName; this.LocationId = LocId; this.ManagerId = MgrId; } public void setDepartmentId(int DepartmentId) { this.DepartmentId = DepartmentId; } public int getDepartmentId() { return DepartmentId; } public void setDepartmentName(String DepartmentName) { this.DepartmentName = DepartmentName; } public String getDepartmentName() { return DepartmentName; } public void setLocationId(int LocationId) { this.LocationId = LocationId; } public int getLocationId() { return LocationId; } public void setManagerId(int ManagerId) { this.ManagerId = ManagerId; } public int getManagerId() { return ManagerId; } } 

Your Excel in Design Time:


Your Excel at run time:


After Click on Ribbon button ‘Upload’, all the rows inserted to DB and also a web service is invoked at back end.


Hope the post is Informative!

ADF Desktop Integration – showing table data in Excel workbook

This post explains how to to display table data in the Excel sheet using ADF Desktop Integration.

We’ll be discussing below items

  • Installing ADF- DI extension
  • Creating ADF Application
  • Working with Excel workbook

Installing ADF- DI extension:

Prerequisites: Before proceeding with ADF-DI extension installation first your system should have below soft wares installed, otherwise you end up getting an error when you try to install ADF-DI extension.

  • Microsoft .NET Framework 4
  • Microsoft Visual Studio 2010 Tools for Office Runtime
  • MS Office [I’ve used 2013 version]

Now go to JDeveloper -> ‘Tools’ -> Install ADF Desktop Integration.

Creating ADF Application:

  • Create Fusion Web Application (ADF). Application Name: ADFApp2, project names (keep default as model and viewcontroller)
  • Right click on Model project and create ‘Business Components from Tables’, crete DB connection and select ‘Departments’ table. Drag this table to right pane for updatableVO.
  • Right click on ViewController project and create JSPX page (dept.jspx)
  • Drag and drop the Deaprtments datacontrols from datacontrol section on to the dept.jspx page as table. (which will creates deptPagDef.xml file and along with tree binding in it)
  • Right click on viewcontroller project and create Microsoft Excel Workbook from client tier. (give Name: dept-DT)




Working with Excel workbook:

  • Double click on the excel file and it’ll prompt to select a page definition file from the available all page definition files in the project. Select view_deptPageDef file and click OK.


  • You can see a tree binding (DepartmentsView1) under Binidngs section of the Excel workbook.


  • Drag and drop the tree binding onto the cell and select ‘ADF Read-only Table’ -> OK.


  • It’ll open workbook properties window, there just click on OK. (we’ll configure it later)


  • Now you can see all the tree bindings in the Excel file.


  • in Jdev Right click on ViewController project -> project properties -> Java EE Application -> set ‘Java EE WebContext Root’ as ‘departments’ -> ok.



  • In excel work book click on worksheet properties and configure there to display data.

Worksheet properties -> Events […] -> Add -> StartUp -> ActionSet -> Actions […] -> Add button (Component Action) -> select Download -> OK -> OK -> OK.







  • In Jdev Right click on dept.jspx page and click on Run.
  • In excel workbook under oracle ADF menu tab, click on Run.


  • You can see the table data in the excel sheet as below. After review click on Stop and close the excel.


Hope You enjoyed the post!

In future will come up with more posts related to ADF-DI ‘update records in excel and upload to DB’ , ‘WebService Integration’ etc.

Disable few items in Select One Choice LOV in Oracle ADF

This post covers how to disable certain items in selectOneChoice LOV based on certain condition.

Existing code:

<af:selectOneChoice value="#{bindings.DepartmentId.inputValue}" 
shortDesc="#{bindings.DepartmentId.hints.tooltip}" id="soc1">
<f:selectItems value="#{bindings.DepartmentId.items}" id="si1"/>

Replace with:

<af:selectOneChoice value="#{bindings.DepartmentId.inputValue}" 
shortDesc="#{bindings.DepartmentId.hints.tooltip}" id="soc1">
<af:forEach items="#{bindings.DepartmentsView1.rangeSet}" var="list">
<af:selectItem label="#{list.DepartmentName}" id="si1" value="#{list.DepartmentId}"
disabled="#{list.DepartmentId eq 10 or list.DepartmentId eq 20 or list.DepartmentId eq 30}"/>





Using Partial Triggers in Oracle Applications Cloud, Oracle Fusion Applications

This post explains how can we refresh a component when another component value is changed. You must be already aware that this can be achieved easily in ADF code by (a) setting the partial Triggers property of target component to the ID of source component & (b) setting the autoSubmit property of source component to ‘true‘.

But in Oracle Applications Cloud, Oracle Fusion Applications we won’t be having access to the source code and we need to implement it from the browser itself using customization feature.

partial triggers property is available for customization, but we need to find the ID of the source component which is not displayed anywhere to us. So to get the ID of the source component click on F12 (browser Inspect Element) then navigate to the source component and click on it. You can find the ID of that component over there.

What ever discussed above, let’s see step by step.

  • Login to Oracle Applications Cloud


  • You’ll be taken to the home page.


  • Select the sandbox if not selected any from the ‘Manage Sandboxes’ link (you can create a new sandbox also and its mandatory to select one sandbox before we proceed doing the customization to the application)


  • After selecting sandbox, click on ‘Set as Active’


  • Now navigate to the page where you wanted to do customization (eg: like in Order Management -> Orders on Hold page). Here let’s take a requirement that on selecting some value in ‘Hold Name’ LOV, the ‘Release comments’ component should display some custom message.


  • Now click on Inspect element (F12) and click on source attribute to find the ID of it. Copy the ID  [if source and destination components present inside same parent component then the last part if ID will be sufficient].


  • Click on Customize Pages link which you can get from user drop down.


  • Go to the Structure tab  and click on required component to customize


Note: If component is present inside a popup then click on button which brings the popup and in the component structure scroll down little where you can see multiple popups. Click on each popup and edit and read the ‘popup fetch listener’ property to understand why that popup is being used and check it is the correct one that we need to edit. After you find required popup if the content inside that is not visible, then set the ‘Content Delivery’ property from ‘lazyUncached’ to ‘Immediate’, then the content inside popup will be available to edit.

  • Click on source component -> If any popup comes select Edit -> Click Edit icon or right click on component at source code and click on Edit -> Set the ‘autoSubmit’ property to ‘true’


  • Click on Destination component and click on Edit and set the ‘partialTriggers’ to the ID which we copied earlier. [don’t set the entire path of ID, if source and destination components present inside same parent component then the last part if ID will be sufficient]. For the Value property set the EL logic as [#{bindings.HoldNameHeader.inputValue eq ‘CUSTOM HOLD’? ‘This is a custom Hold.’: bindings.HoldReleaseComments.inputValue] which means when ever ‘CUSTOM HOLD’ is selected in the LOV then below target component shows the message as ‘This is a custom Hold.’, and whenever other value is selected it won’t show any message and user can enter text over there. 


  • Now close the customization and you are ready to test. Select ‘CUSTOM HOLD’ from Hold Name LOV, then Release Comments shows the message as ‘This is a custom Hold‘. If you select other value then input text will be empty and editable. Now exit from the sandbox.


Hope you enjoyed the post 🙂


AM Service Interface (Expose ADF BC as web services/ service Enabled data objects SDOs)

PART – 1:
AppModule Service Interface webservice genearation [Expose ADF BC as SDOs service enabled daat objects]:
-> create ADF application with business components (EO, VO, AM)
-> write two custom methods in AppModuleImpl class and expose those methods to Client Interface.
-> double click AM -> Service Interface tab -> you can see three sections ‘service Interface for custom methods’, ‘service interface for view instances’, ‘Genearated files for Service interface’.
-> select required methods/view Instances of datamodel in respective sections. When you select a view instance, operations for that view isntance are displayed jsut beside to it and we can select what operations to enable for the view instance [oeprations as ‘update’ to edit the record of that view instance, ‘Find’ to retrieve the records from that view instance, Create, Delete, Merge, GetByKey, Process, etc..].
-> After selection, under AM a folder named ‘service interface’ will be created which contains webservice artifacts [,, AppModuleService.wsdl, AppModuleService.xsd]
-> Deployment: create deployment profile for ‘[Business Components Service Interface]’. deploy [check Model projetc is checked and under which both ‘common’, ‘middletier’ selected for integrated weblogic, and only ‘middletier’ selected for deployment on servers]
-> Test the webservices from Weblogic EM console like the same way you test SOA webservices.
Sample custom methods which you can expose in AM:
public void updateSalary(Number employeeId, Number salary){
Key key = new Key(new Object[] {employeeId});
Row row = this.getEmployeesView1().getRow(key);
row.setAttribute(“Salary”, salary);

catch(Exception ex){
// The above methods accepts EmpId, Salary as input and updates the salary for the given EmpId in DB
Note: we need Oracle web services manager to define the security policy for AppModule Webservices(according to documentation B31974-05 section 11.2.13). So need to license Oracle SOA suite cos webservices manager comes under SOA suite. So without using SOA, if you want to expose webservice from ADF business components you can not proivde security to them.
These exposed websrevices will creates new AM configuration and uses AppModule pool for DB connection when invoked.

For secured WS you can check this post – This is about ADF Mobile, but Web Service part is about secured AM Web Service
====================================================== ======================================================
====================================================== ======================================================
====================================================== ======================================================
PART – 2:
In above we have exposed the ADF Business component services as webservice (service enabled data objects/SDO).
Now we can consume those ADF BC services from SOA applicaiton or from another ADF application also.
Now we are discussing on How to consume remote ADF BC services[AM methods, VOs] which are exposed as webservice in other ADF applicaiton.

Create a new ADF applicaiton. [In this applicaiton we create Service Enable Entity Objects, whcih means EOs are created based on SDOs (service enabled objects)]
create Entity object-> when creating EO uncheck defalut datasource selection ‘DB schema object’, check ‘Service Interface’, give the WSDL URL and select the Service ViewInstance from dropdown.
Run the AM, now you can create a record, update record, delete record.
EO based on remote VO exposed though webservice (Service enabled EOs) will be similar to EO based on DB. But Joins doesn’t work for this EO when you create EO based on VO exposed as webservice.
We can declare Business Events on Service-Enabled Entity Objects, it works same as declared on normal Entity Object.
You can see the attributes but you can see the query, as this EO will get data dynamically as this is based on webservice.
So this is how you can crete a EO from a VO based on remote applicaiton which is exposed through webservice.
Deployment: Here first you need to add the ‘applnname_common.jar’ library of exposed applicaion to this consuming applicaiton.
Give the service connection information in connectons.xml. Now you can deploy and test from EM console.
Note: The operations which you select for a view isntance during exposing AM, those will only be available for applications when consuming them.
====================================================== ======================================================
====================================================== ======================================================
====================================================== ======================================================
PART – 3:
Creating Business Event and subscribing to that event in Oralce SOA.
Busieness Events allows the loose coupling. Busieness Events can be created from ADF BC or from SOA.
These Business Events can be subscribed in SOA composite using Mediator.



-> Oracle ADF Functional Patterns and Best Practices

-> Customizing and Personalizing an Application

-> Oracle Fusion Applications


ADF Customization

================== Customization: ========================

-> Oracle ADF allows us to create customizable web applications.
-> customizable applications means there will be one base application. On top of that application we develop multiple versions of application using multiple customizable layers and their contexts.
-> One customization layer can have multiple customization contexts (values)
-> At a time only one customizable layer value (context) will be applied on the base application (we can give one cust layer as default in properties file). Note that all the customization layers can be applied but only one context from each layer.
-> We select one customizable layer’s context from the ‘customization context window’ and we can work on the base application.
-> Similarly we can select another customizable layer’s context and work on the base application. Here you need to note that the customizations that you have done in one customizable layer’s context won’t appear in other customizable layer’s context.
Customization layers could be: ‘industry’. ‘site’Customization contrexts could be (need to input like below in proeprties file) industry=financial #industry=healthcare #site=remoteoffices site=headquarters So from the above settings if we run the application industry cust layer’s financial context will be applied on base appln along with site cust layer’s headquarters context.
How to do it? ‘Open Jdeveloepr with Default Role’
-> prerequisite: create one sample ADF web applicaiton.
-> 1) Create Customization Layers in ‘customizationLayerValues.xml’ file (which is present under <JDEVELOPER_HOME>/jdeveloper/jdev) This applies to all applications.If you want to aplly these customization layers to only this applicaiton then open adf-config.xml and udner the MDS tab, click on the link ‘Configure Design Time customizations’ which creates a file ‘customizationLayerValues.xml’ under ApplicaitonResources -> MDS DT  [Create cust layers as ‘site’, ‘industry’]
-> 2) Now define the Customization Contexts for each customization layer. So create a proeprties file ‘customization.proeprties’ under the modal project and give entries like below. industry=financial #industry=healthcare #site=remoteoffices site=headquarters

-> 3) Now create the customization class for each Customization Layer. [SiteCC, IndustryCC]. paste the belwo code into these class files. These classes will pick up the properties file and applies the customization layer’s context on the base applicaiton.
-> 4) Now defiene the created customization classes in adf-config.xml file under MDS tab.
-> 5) right click on viewContrller project -> ADF View -> check ‘Enable Seeded customizations’.
-> 6) Now work on Taskflows and UI. #So far we discussed about base applicaiton. #Now we disucss how to customize this base appln.
-> 7) Close Jdev and Reopen with ‘Fusion  apps developer Role/ Fusion apps Admstr Customization Role’ to start customization.
-> 8) First open with ‘Fusion  apps developer Role’ and create a ‘Fusion Apps customization application’. Name: XxCustomizationDemoApplicationpackage prefix: com.oracleDeployed EAR: baseAppln.earNext  -> Project Name: XxCustomizationDemoProject -> FinishThe created application contains Project ‘XxCustomizationDemoProject’ and folders under it are ‘Appln sources’,’Resources’,’Web content’.The base applicaton war files are available under ‘Application Resources ->  customizable Archive -> Base Appln Archive’.
-> 9) Now close and Reopen jdev with ‘Fusion apps Admstr Customization Role’.Now select the customization layer and its context. These latyers and their contexts are defined in the base application.For Fusion SCM we have the below cust layers.Global -> value/context: GlobalSite -> value/context: Site
-> 10) Under Application Resources -> customizable Archive -> Base Appln Archive ->  Right click and for the jspff page/ taskflow (that should present in base applicaiton).Now under  ‘Base Appln Archive’ you can see only filtered files. Right click on that file and click on ‘customize’ option.It’ll promt to Add library. click on Add Library. When you do this under the project a folder ‘ADF Library Customizations’ will be created. And under this folder you see the page/taskflow which you selected to customize. [Note: the page/taskflow will be maintained its full path as in base applicaiton under the ‘ADF Library Customizations’ folder]-> Now you can customize the jsff page. [its not editable and only properties can be modified from property inspector]when you customize any component, under the project a folder ‘ADF Library Customization Sources’ will be created. Under this folder you can see the page which you customized with XML extension (eg: Invoicecreate.jsff.xml) The original full path of the page wil be maintained and under that path again few folders will be created (mdssys -> cust -> Global/Site (cust layer) -> GLOBAL/SITE (cust context) -> Invoicecreate.jsff.xmlFor any New component (jsff page, taskflow, VO etc) you need to switch to ‘Fusion  apps developer Role’.

-> Let’s take an example. Create a base application with ‘EmplApp’ and create business comopnents (EmployeeEO, DeptEO, LocationEO, EmployeeVO, AM). -> Now create a view (employees.jsf) and display the Employee details like a form.So far we have developed the base application.

-> Now suppose our requirement is one customizable layer (LocationLayer) we want to show employee details as table with attributes only related to location.->  Now suppose our requirement is one customizable layer (DepartmentLayer) we want to show employee details as table with attributes only related to department.
-> To fulfill above requirement first we need to close jdev. And reopen with customization role.

-> Now right click on viewcontroller project and select ADF View -> Enable Seeded customizations.

-> Give entries of the requried customization layers in the customizationLayerValues.xml file (which is present under <JDEVELOPER_HOME>/jdeveloper/jdev) This applies to all applications. If you want to aplly these customization layers to only this applicaiton then open adf-config.xml and udner the MDS tab, click on the link ‘Configure Design Time customizations’ which creates a file ‘customizationLayerValues.xml’ under ApplicaitonResources -> MDS DT

-> Now we created customization layers, so we need to define them in the proeprties file. create a properties file in the Modal project ‘customization.proeprties’.  In the properties file define the different contexts to a single cutomization layer.