Oracle JDeveloper 12c Installation Issues

Recently I tried installing Oracle JDeveloper 12.2.1.3 and it took me a while to install it. I came across a number of issues. Previously Oracle used to provide us with exe files which were easily installable but from now onwards I am seeing lot of issues because of java. These issues might come while installing other Jdeveloper versions as well like 12.1, 12.2, etc.

OAF Attachment : Make an attachment mandatory

at times you want to make an EBS OAF attachment mandatory for user. We cannot use queries to retrieve if attachment is added by the user or not because attachments are not yet committed to database.


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

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:

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:

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.

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:
   
   
   
   

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:

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.

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

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
---------------------------------------------

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>

Oracle MAF - Disabling Landscape mode

Recently I had a requirement for disabling landscape orientation.
Frank and Chris suggested me below and it worked for me:

iOS
--------
For iOS on the deployment profile. 
Select Application --> Application Properties --> Deployment --> select iOS profile and and click on edit. Select device orientations. And there you will find option for enabling/disabling portrait/landscape modes for iPhone and iPad.

Oracle MAF - Using Panel Group Layout - wrap

In Oracle MAF one new option has been provided for the attribute "layout" of panelGroupLayout. It is very useful. I will give you a scenario: you want to create a contact us section where by you will want the text, followed by phone numbers(which should be clickable and should open phone dial on clicking) and email(clicking on which a write message of your default mail should open).

For such scenario you can use panel group layout with layout property set to wrap and inside it you can use output text and golinks to serve the purpose.

Oracle MAF - Issues, Tips and Tricks

Hi All,

I have built a mobile application using Mobile Application Framework released in July 2014.
In the mobile app I have done integration using REST services with JSON output. And the user will fill some forms and will send attachments from camera and library. The user can see history and I have used a pie chart as well for historical data.

Here is some of the issues, tricks which I learnt and I am sharing the same:

*********************************************************************************

ISSUES, TIPS & TRICKS:

*********************************************************************************
1.

[11:29:47 AM] Checking state of Android Debug Bridge server...
[11:29:47 AM] Android Debug Bridge server already running.
[11:29:55 AM] Command-line executed: ["C:\Program Files\Android\android-sdk\platform-tools\adb", start-server]
[11:29:55 AM] ADB server didn't ACK
[11:29:55 AM] * failed to start daemon *
[11:29:55 AM] * daemon not running. starting it now on port 5037 *
[11:29:55 AM] Command-line execution failed (Return code: -1)
[11:29:55 AM] Deployment cancelled.

Solution:
Go to platform-tools and kill adb server, it might be running because you would have done some debugging.
cd C:\Program Files\Android\android-sdk\platform-tools
adb kill-server

ADF Exception Handling - Taskflow, Controller, Model

Exception handling in ADF can be done at following three places:

a. Taskflow Exception Handler

b. Extending Controller level ExceptionHandler - for controller level exceptions

c. Extending DCErrorHandlerImpl- for model

• Whenever there is an exception in model layer it is being handled by custom class extending DCErrorHandlerImpl.
• Exception in ADF Controller can be handled by creating a custom class extending Controller level ExceptionHandler.
• If an exception rethrown from above, it can be handled at TaskFlow level exception handler which can be a view activity, router or a method call.

One by one let`s discuss all of them:

ADF integration with Jasper Report

In this post i am just posting a few important steps and code snippet which can be helpful to integrate with Jasper Reports for generating a pdf or an excel.


You need add the following jars from /modules/ext folder of Jasper Reports in your ADF project(fonts related jar need to be added if you are using some specific fonts in your jrxml):

Make sure to add above jars from Add Jar/Directory and not through Add Library, otherwise you will get the following error:

<ActionListenerImpl> <processAction> java.lang.ClassCircularityError: net/sf/jasperreports/engine/JRException

javax.faces.el.EvaluationException: java.lang.ClassCircularityError: net/sf/jasperreports/engine/JRException

ADF - Java Mail with attachments

First create a mail session in weblogic server. In Weblogic server under "Services" you can find Mail sessions. Create a new Mail Session. Give following information:
Name - test
JNDI Name - mail/test
Java Mail Properties - 
mail.smtp.password=[password]
mail.debug=false
mail.smtp.user=[user name]
mail.from=xx-do-not-reply@abc.com
mail.smtp.host=[host name or IP of exchange server]
mail.smtp.auth=false
mail.smtp.port=25
mail.verbose=false
mail.disable=false
mail.transport.protocol=smtp


The following java method can be called to send mail with attachments

destination - array of email addresses to which mail has to be sent
subject - subject of mail
content - body of mail
data - list containing byte[] of the files to be attached in the email
fileNames - names of the attachement
contentTypes - content types of the attachments

ADF - setting default value for Range Slider

When using a range slider if you put minimum=0 and maximum=10000 then it will look like this :

            <af:inputRangeSlider value="#{bindings.area.inputValue}"
                                 shortDesc="#{bindings.area.hints.tooltip}"
                                 label="#{bindings.area.hints.label}"
                                 required="#{bindings.area.hints.mandatory}"
                                 id="irs1" autoSubmit="true" majorIncrement="-1"
                                 minorIncrement="-1" minimumIncrement="100"
                                 maximum="10000" partialTriggers="cil3" styleClass="selectField"
                                 animationInterval="0"
                                />

ADF - Showing UCM Images in carousel

I had an interesting requirement where we are showing all the available properties in a list view(new feature in 11.1.1.7). Each row of a list view has a carousel. Carousel will show images of the concerned property. The images are residing in UCM. Whenever a new image is uploaded in UCM automatically the carousel will include the new image as well.

Now i will explain how we have implemented the same.

ADF mobile - Setting Up

ADF Mobile – Setting up

1.     Downloads:

• ADF Mobile support is available from Jdeveloper 11.1.2.3.0 onwards. It can be downloaded from here. Download Jdev 11.1.2.4
• ADF Mobile Developer`s guide can be downloaded from here.                                                                       
• Android SDK can be downloaded from here. Android SDK contains a set of API libraries and tools to build test and develop Android Apps.