Tuesday, December 12, 2017

OAF Attachment : Making an attachment mandatory

You want user to mandatorily add an EBS OAF attachment before moving ahead. We cannot use queries to retrieve if attachment is added because attachments are not yet committed in database.

In such scenario you do a mandatory (required) check for attachment table, link and inline attachment:

Wednesday, December 6, 2017

OAF Attachment Disable File or Url or Short text attachment

In Oracle EBS OAF Attachments you can disable different attachment types like File, URL, Short text, Long Text using the following code in processRequest of your controller:

Sunday, November 12, 2017

OAF attachment - set insert allowed update allowed and delete allowed programatically

In Oracle EBS OAF attachment we can set "Insert Allowed", "Update Allowed" and "Delete Allowed" properties of an entity map programmatically in process request of controller:

Thursday, August 24, 2017

Oracle EBS 12.2.5 - Open navigator on mouse click rather than mouse over

Recently we upgraded to EBS 12.2.5 and one of the features in the new release is navigator. When you mouse over on a menu or responsibility there is a delay of 1.5 sec and hence user found it very slow to open a menu. So, if you are keeping your mouse on a menu item for 1.5 sec then only it will go and retrieve the functions and sub menus.

Saturday, April 15, 2017

Oracle EBS OAF attachment to be updated / deleted by creator only

Have you ever got a requirement in Oracle EBS FND attachments where in multiple users can add an attachment of the same category but only the person who has created it can delete or update it.

 For others delete and update column will be disabled. I achieved it recently in OAF by creating a custom DataBoundValueVIewObject class and associating it with update and delete icons of the attachment table. Since attachment table is a seeded region, I had to extend its controller to associate custom DataBoundValueVIewObject with update and delete icons.

  1. Create a custom DataBoundValueViewObject (xxOADataBoundValueViewObject ) class:

Tuesday, July 26, 2016

Oracle Workflow Tips and Tricks - hide default action history and show custom action history, customizing notifications, hiding buttons, recall functionality

I am here by going to discuss on a few of the tricks and scenarios related to Oracle Workflow. If you think we cannot do much with the limitations of the workflow then you are going wrong. There are ways we can play with a workflow notification. 

(1) Hide default Action History and show your custom Action History region

 At times you feel like hiding default Action History region and show your own action history from your custom table in OAF region being displayed inside Workflow message. There are two ways you can do that:

(a) In OAF region controller : You can use the below lines to hide Oracle default Action History        region:

Tuesday, October 13, 2015

Oracle EBS - finding function id ( function_id ) for the current form for the logged in user in pl/sql

We might get a requirement where you want to show same form function twice under a responsibility with different names and showing different data.

Let`s say the data being displayed comes from a View.

Thursday, May 7, 2015

Oracle MAF : Upload an image from camera or library

This blog is to share my experience in implementing a very common requirement - attach a photo by integrating with device camera or photo library and then passing the photo  as Base64-encoded string.

STEP 1: Enable camera plugin in your maf-application.xml

Friday, September 12, 2014

Oracle MAF : Creating Select One Choice from a webservice (REST with JSON output)

This post is to show how we can create a select one choice from a REST service with JSON output.
This example is using RESTServicesAdapter. Using that programmatically you can call a REST service and you can manipulate response as per need.

STEP 1: Create a REST Connection

Wednesday, September 3, 2014

Oracle MAF Skinning

I tried two ways of doing skinning in MAF -
1. skin-addition -> skin-addition tag adds a new stylesheet to the existing skin
2. skin -> skin tag is used to define a new skin or to customize existing skin for particular OS or device.

Note: maf-config.xml file under Application Resources -> Dscriptors -> ADF META-INF contains the default skin family. That skin family will be applied to the application.

1. <skin-addition>