We have introduced CholaMeetings.com for all our live classes conducted through adf training at https://www.cholanacademy.com/.

While live classes are frequently taken through different tools, now we had switched to Chola Meetings for better control and features.

Based on the popular request from our learners, below is the self paced course bundle offering for you to save money as well as time. It is like learning yesterday, today and tomorrow of Oracle Technologies for an EBS Technical Consultant.

The courses included are OAF + ADF Beginners + Oracle Fusion Tech Cloud and the price is $299

On our 10th Year of ADFTraining.com, we would like to thank all our supporters and learners to help us sail through all these years. We started this website when US was under peak recession in 2008 to help people to learn new technologies for free.

In 2016, we went live with a large scale conversion of a College system from .net and oracle forms to Oracle ADF application with dashboard integration to OBIEE in Muscat with Ministry of Manpower, Oman. The major challenge we faced is the performance issues when there were around 6000 concurrent users and the expectation was to handle the 13000 concurrent users. Read more to view how we solved it...

I am excited to hear the news of new JDeveloper for Oracle ADF...You heard it right !!!..

Oracle JDeveloper 19.1.0.0.0 is coming and it has new UI features for ADF which can be Oracle JET integration..

In one of our ADF Training batches, we had noticed an issue related to ADF Security not working on the authorization part when enabled on a Oracle ADF REST API.The authentication part was working fine, but the authorization was failing on ADF 12.2.1.2.0

After scratching the head for few hours, the solution has been arrived at...Thanks to Google Search and Andrejus Post.

import oracle.jbo.VariableValueManager;

import oracle.jbo.ViewCriteria;

import oracle.jbo.server.ApplicationModuleImpl;

import oracle.jbo.server.ViewLinkImpl;

import oracle.jbo.server.ViewObjectImpl;

public void applyVCforGlobalSearchProjects(String searchCriteria){

    ViewObjectImpl vo;

    vo = this.getProjects();

    ViewCriteria vc = vo.getViewCriteria("HrProjectsVOCriteria");

    vc.resetCriteria();

    VariableValueManager vvm = vc.ensureVariableManager();

    vvm.setVariableValue("p_search_criteria", searchCriteria);

    vo.applyViewCriteria(vc,true);

    vo.executeQuery();

}

Below are the bugs which we found while working with JDeveloper 12.2.1.3.0 and their corresponding work arounds

Recently I had migrated the MAF app for one of our client to IOS 9.2 using MAF 2.2.1 and found the issue like below.

The resource could not be loaded because the App Transport Security policy requires the use of a secure connection

Below are the steps to fix the issue

The main complaint against the JDeveloper is that it is very slow..Yes, of course you can increase the heapsize and use 64 bit jdk to speed up the slow jdeveloper.

But still the design view for the page and page fragment is very slow.Sometimes it hangs and creates lot of frustration among the ADF developers.Here is the way you can set the default view as source view for the page and page fragment.

The navigations were slightly confusing in 12.1.3 JDeveloper..Here is the screenshot for the same.

I had a requirement to move a bunch of personalization from one instance to another in my current project.I did lot of googling as well as raised an SR with oracle to find the best way to move the personalizations from one instance to another..And then I gave up on it for sometime and later while researching on a different topic I found out the best way to move adf saved queries and user personalization.

It is as simple as export from the source instance and import into the destination MDS using the EM Console.Let me show the steps here..

I got really excited to hear the news that Oracle JDeveloper 12c released finally.I tried to install the 12c jdeveloper to get my hands dirty but couldn’t even install it :(.

 On windows, installer quit abruptly without any error message and on MAC, what the heck happened I don’t even know.Here is the solution to install them successfully on MAC and Windows.

In the last article, I had taken you through the steps required to source control your Oracle ADF apps with the help of code.adfapps.com repository and subversion.Let me show you how to checkout an existing oracle adf project from the code.adfapps.com subversion repository.

High level steps:

1) Connect to Subversion repository using the credentials

2) Open up the Versioning Navigator in the JDeveloper

3) Open up your repository and go to (Trunk or Branches or Tags)

4) Checkout the appropriate project folder by right click on the folder and say checkout

Below are the steps in detail:

In the last article, we had seen how to deploy Oracle ADF app to the java cloud from jdeveloper.In this article, let us create some objects in model project with the Department and Employees table from oracle XE database to deploy those tables to the database cloud.Once you migrate the required tables from the XE database to Database cloud, we can deploy our ADF app to javacloud.

Here are the high level steps.

1) Develop your ADF app locally connecting to the Oracle XE database

2) Migrate the referred tables to the associated database cloud

3) Modify the Root AM’s datasource to database.

4) Deploy the ADF app to the Java Cloud.

It is a very rare sight that a project team with more than 2 developers doesn’t have any source control in place while working on an Oracle ADF development project.If you don’t have source control for Oracle ADF development, then your project needs a better project manager and architect :).

I had created a small project to demonstrate source control with Oracle ADF jdeveloper’s native support for subversion(SVN).We will use the code.adfapps.com for our subversion project hosting.

Below are the high level steps..

1) Create a manual connection to subversion repository from Jdeveloper

2) Click on the Application menu and say version application.

3) Select the repository connection and choose whether to version control to trunk,tags or branch(Put it in Trunk for the first time)

4) That’s it.. We are done with source control..No, there are lot of challenges still.We will cover them one by one in the 5 part series.

For now, let us look at the above steps in detail.

Oracle public cloud simplifies the process of deploying your application and keep it running without much of a headache specially if you don’t have full fledged IT team to maintain the application.You need to register for Oracle Cloud Java Trial account with the below url.

https://cloud.oracle.com/mycloud/f?p=service:java:0:::::

Once the trial activation is done, you will receive username/password to login to identity console(Probably in your junk email :) )

Let us go over the steps in detail.

This is a very interesting issue which totally got me stumped as the application was working perfectly fine in 11.1.1.6 and then migrating the app to 11.1.2.3 resulted in the below error while uploading the file to a blob column.

Cannot create an object of 
type:oracle.jbo.domain.BlobDomain from 
type:weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB with 
value:weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB@114

 Solution is as below.

In the last part of this series, I had explained you about how to checkout an Oracle ADF project from subversion and run the page from JDeveloper.In this part, I will explain you how to make changes to the checkout project and commit changes to the subversion repository using the pending changes tab in JDeveloper.

High Level steps:

1) Make a change to the jsf page

2) Open up the pending changes tab

3) Select the changed files and click on commit button

4) Provide a commit message to commit the changes to repository.

Above steps in detail:

This is the feature you must have been used to if you had used forms developer and I missed this with the previous version of jdeveloper, specially during the OAF development days.But here is the relief in the 11g version of JDeveloper.I noticed this option while opening the jdeveloper 11g version 11.1.2.3 and came as a tip in jdeveloper.

Lets see how we can use this option.

I had faced an issue with resource bundle variable resolver library after upgrading adf from 11.1.1.6 to 11.1.2.3.

Error:

Caused by: java.lang.ClassNotFoundException: javax.faces.el.VariableResolver
at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:297)
at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:270)
at java.lang.ClassLoader.loadClass(ClassLoader.java:305)
at java.lang.ClassLoader.loadClass(ClassLoader.java:246)
at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:179)
at java.lang.ClassLoader.defineClass1(Native Method)

Seldom you expose a webservice operation without a security attached to it..Let us see how we can attach the simple username token based authentication to the webservice we had created in our previous posts.

Checkout the code from below repository if you haven’t completed the previous exercises.

https://code.adfapps.com/svn/adfwebservices

adftraining/adftraining

TAG : CUSTOM_METHOD_WEBSERVICE

Oracle ADF has helped us to develop a webservice with ADF BC pretty fast by using the service interface of the App Module.In the last version of this webservice, we just created an EO,VO and exposed the AM methods as a webservice.What if you need a custom functionality written in a custom method in the AM to be exposed as a webservice? We have an option in the service interface of the AM to expose the custom methods in AM as a webservice method too.

Lets start by creating the custom method in the AM.

In the last post, I had walked you through the creation of simple ADF webservice which is based on the Departments table in XE database.There was no validation on the create or update method of the webservice in the previous version.There is a lot of chance that the caller of this webservice may send some junk data into your system through the webservice which doesn’t handle the validations properly.I have a lot of experience with my clients on this aspect :).

Also, the caller won’t know the ids in our system and most probably they will send the names(For Ex: Location id will not be known to the callers but they will know the Location Name).Instead of writing code to handle this kind of scenario, you can simply handle it by attaching the lov to the location id attribute.But this is tricky because locationid attribute is bigdecimal but how the caller will send the location name which is a string ??

Let me show the trick :)

This course is available on the below link now.

https://www.adftraining.com/training/self-paced/guruPrograms/3-oa-framework/6-oa-framework-for-beginners

Oracle ADF has a cool feature for building SOAP based webservices using ADF Business Components.I will take you through series of blog entries to build a simple webservices with ADF BC, adding validation using lovs, adding security to the web services etc.

I will be using Oracle XE for the database access and will post the workspace at code.adfapps.com website for you to checkout directly from your jdeveloper.

There is a huge form user has filled up and suddenly by mistake she clicked on another button in the page  which took her to another page.All her changes are gone..This will be a typical scenario which could have been handled in the development stage, if the team knows the best practices around the web page development.Now you know the use case and lets see how we can implement the solution in Oracle ADF.

It is indeed a pain to work in an Oracle ADF project where there are multiple developers and everyone names their objects according to their wish.We had the same kind of issue in my previous Oracle ADF  Development project.This has to be the first priority before even starting the coding.If not, you are in for a big shock when you look at the object names in future :)

Oracle JDeveloper comes with a great feature to tackle this scenario and does a wonderful job.Let us look at the steps to implement the same.

History columns in Oracle ADF is a very convenient builtin functionality which takes out a little bit pain out of the developers to maintain the who columns.It is very simple to implement and have to be done at the Entity Object level.Below are the list of History or WHO columns available in Oracle ADF.

I had this requirement where I had to pass the url generated in OAF to Java script. In Javascript I have a link, when clicked needs to go back to OAF page. The problem I had was when I pass just "OA.jsp?OAFunc=<functionname> it was throwing me an error.

You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to proceed.

The below code snippet will help you to call an external application like ADF based or any other websites like google from oracle apps.You can register the function to call the external url.I had used this technique 3 years back to integrate an ADF application with oracle R12.

Requirement was to build an OAF page which will display the files stored in the filesystem.OA Framework doesn't support this functionality natively.But core java comes in handy during these situations.

Challenges:

1) Dynamically read the files from a specific directory.
2) Create the link items dynamically and provide action type programatically
3) Filter the files by name
4) Open the pdf file using a custom function(OA Framework supports FileDownload from a blob but we need to show that from file-system).

Below code addresses all the challenges above and creates a seamless approach to read the file from filesystem and display them in an OAF Page.

I got this requirement recently with one of my client to send an email as well as save the pdf on the file system for future audit purpose.The existing program was sending the email attachment with the bursting Control file,but now we have to include the option to save it to the file system after the email is sent.I went with the multiple delivery channel approach to get the functionality working..the code snippet for the bursting file is available below.

Recently I had this requirement to update the project start date and end date on a oracle project.This requires lot of validations before update can be performed but the below API really simplified my work..Have a look at the below API sample Call

Here is the code snippet for querying the list of users who have vacation rules enabled.

Sometimes you have to show all the error messages at one shot,instead of showing the error messages one by one. In that case, we have to use bundled exception to show multiple error message. Below are the steps:

Use the below link to download the Oracle Workflow Client.It was a  real struggle to find this for some reason :)

Recently I had this question in asksudhakar.com,below code snippet will get you the handle to the item inside the advanced table.This is straight forward with classic table but for advanced table you need to get the handle to the column bean and then to the item.

            OAAdvancedTableBean table = (OAAdvancedTableBean) webBean.findIndexedChildRecursive("region2");
            OAColumnBean columnForStatus = (OAColumnBean)table.findIndexedChildRecursive("column4");
           
            OAImageBean statusImageBean =
              (OAImageBean)columnForStatus.findIndexedChildRecursive("StatusImage");

    Below code is used for creating a new page button bar region and then adding a button inside that region to display in the top and bottom of the page.

        OAPageButtonBarBean pageButtonBean = (OAPageButtonBarBean)createWebBean(pageContext,OAWebBeanConstants.PAGE_BUTTON_BAR_BEAN,null,"pbBar");

        OAButtonBean oasb= (OAButtonBean)createWebBean(pageContext,BUTTON_BEAN, null, "BUTTON");

        String msg1=pageContext.getMessage("FND","FND_CANCEL",null);

       oasb.setText(msg1);

        pageButtonBean.addIndexedChild(oasb);

      OAPageLayoutBean page = (OAPageLayoutBean)webBean;

      page.setPageButtons(pageButtonBean);

This is pretty simple.Use the command below.

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct  XXCH_B2CE091_MESSAGES.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCH" MESSAGE_NAME="XXCH_B2CE091%"

Where MESSAGE_NAME can be like 'XXCH%' or '%XXCH%' or '%XXCH'

HGrid is nothing but a Hierarchical Grid in OA Framework.It is a combination of Tree and the Table Grid.It is usually used for displaying hierarchical data in a Table.

There are two ways to build a HGrid with DML Operations.

1) Traditional Web Method where you can display the data on the Hgrid.For Create and Update,you need to navigate to a different Page.

2) Advanced HGrid where you can create the records as well as update them on the Hgrid itself.

Oracle Site Hub is a location mastering solution that enables organizations to centralize site and location specific information from heterogeneous systems, creating a single view of site information that can be leveraged across all functional departments and analytical systems. Site Hub has integrations to Property Manager, Assets Management and few other modules. Oracle Site Hub module is available from R12.1.1 version.

If you are working on a R12 environment and your company is planning for MOAC support then the below post will help you to make your custom tables MOAC Compliant.

Most of the validations in Oracle Property Manager happens through lookups.Below is the list of lookups available in PM.

Here is the list of base tables in Oracle Property Manager.Some of the important tables are below

Property:

PN_PROPERTIES_ALL

PN_LOCATIONS_ALL

Leases :

PN_LEASES_ALL

PN_LEASE_DETAILS_ALL

PN_OPTIONS_ALL

PN_PAYMENT_TERMS_ALL

PN_DISTRIBUTIONS_ALL

Variable Rent Agreement:

PN_VAR_LINES_ALL

PN_VAR_PERIODS_ALL

PN_VAR_RENTS_ALL

PN_VAR_RENT_DATES_ALL

PN_VAR_RENT_INV_ALL

PN_VAR_RENT_SUMM_ALL

Full list is here:

Having worked on Oracle Property Manager for last 5 years,I would like to share my experience on Oracle Property Manager with the world.

Introduction:

Oracle Property Manager is the Property Management solution from Oracle for the Retail and Real Estate clients.It was introduced back in 1998 as part of the Oracle EBS,it has travelled a very short distance interms of maturity.This is mainly because the number of Clients are less compared to some of the modules of Oracle EBS.Oracle Property Manager is a lease based system and has tight integration with AP,AR and GL

Recently I had this requirement to restrict some of the values on an existing LOV item in a EBS form.Below are the steps required for the same.

It is little weird that I couldn't find any documentation related to creating a OAFormValueBean programatically.I had the issue in my current project where we need to create the form value item programatically(Dynamically).Here is the code snippet for the same.

I frequently find myself in a situation where I have to remove the lock from tables.Here is the script I use to remove the locks.

There was a requirement with one of my client  to open an OAF page from workflow email notification.  In R12  below error will occur if you try to open an OAF Page URL link directly.

You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to Proceed.

Note: When you call a standard page this error won't appear. This happens only when you try to open a custom page.

Below are the steps to resolve the error:

I was developing an OAF Page which has to support MOAC in R12.1.1.The below metalink note become thirukural to me as I start building those pages with ease.

Oracle Applications Multiple Organizations Access Control for Custom Code [ID 420787.1]

begin

 fnd_global.apps_initialize(:user_id,:responsibility_id,:responsibility_application_id);

 mo_global.init(':product_short_name');

end;

Lease administration flow is one of the key flow  in Oracle Property Manager.Having worked with Oracle Property manager for last 4 years,there are lot of clients require a good real estate solution but oracle never met the demands of clients through Oracle Property manager.

But good news is they are catching up with it by understanding the demand for it in the market now.

The below screenshot shows a simple workflow of the Lease Administration cycle.More useful property manager articles will be available in premium section.

This is a requirement where people are used to Oracle forms style generation of unique number.The unique identifier for the record is derived from a database sequence when user saves the record in an OAF page.Most of the OAF pages developed by me has the sequence automatically generated in the Create method of the EO when user navigates to the screen.

Drawback of that approach is if user navigates to the create t screen and doesn't click on apply button then the sequence value will elapse and wasted.To avoid this ,follow the approach below to  simulate the Forms Style Generation of the unique Number.

This E-Book covers the Google Style Auto Suggest LOV functionality for OA Framework on a custom OA page. Same method can be used to extend any standard page by using personalization. This is completely a Noninvasive approach to introduce Google Style Auto Suggest LOV functionality for your standard LOV or text items. Support Available at OracleArea51 Forums.

Below is the preview of eBook with some pages hidden.

This is a very common scenario where you have to compare two dates in OA Framework.For example there is a start date and end date for an employee.Business scenario is start date should not be greater than the end date.To achieve this scenario in OA Framework you have to put the below code under Validate Entity method in your EOImpl.java since this is a cross attribute level validation.

Now let us see how we can develop the code for above said functionality.

Issue : Unable to create an entity object from R12 Jdev when you configure the Jdev for the first time.

Resolution :  As below

Recently I came across a scenario where I have to validate the key flexfield segments passed  and derive the id for it.Below generic routine helped me to achieve that.

http://oraclearea51.com/code/code-snippets/pl sql/convert-key-flexfield-to-id-in-oracle-apps_11.html

The Page xml files(*PG.xml) and region xml(*RN.xml) files resides in the database. So you have to import the file into the database to make it work in the instance. Oracle application provides XMLExporter/XMLImporter to export and import page files from and to the database.

• Oracle BI Presentation Services
• Oracle BI Applications.