Create LOV based field using Personalization in OA Framework
Written by Anil Passi   
Monday, 30 July 2007

The purpose of this article is to show you :-
    1. How to create a new Field using Personalization in OA Framework
    2. How to attach a List Of Values to this new field, again using Personalization in OA Framework

This is an Audio-Video demo.
You may encounter a similar requirement in real world, however, in real world you will also need to extend CO/AM to take actions on the value selected in newly created field.

Before we jump onto the audio-video demo, let me give you the overview of the Requirement.

 

Requirement
To add the two fields as shown below, alongwith an LOV.
This should be done without modifying the base page, i.e. using Personalization



Where will we add these two fields?
These fields will be added to HelloWorld Page, that comes with OA Framework Tutorials.



We will use a LOV Region supplied in OA Framework Tutorials.
LOV Region is nothing but a page that displays data fetched from a SQL Statement [via ViewObject].
The LOV region being used is /oracle/apps/fnd/framework/toolbox/lov/webui/EmployeesLovRN, as shown below
This LOV region is delivered as a part of OA Framework Training Tutorial.
In real world, you will be creating a similar region [based on your requirement], in case there is no existing/standard LOV region to implement your LOV.


CLICK HERE TO VIEW THE OA FRAMEWORK PERSONALIZATION DEMO FOR CREATING LOV BASED FIELD ON PAGE




Comments (14)add
...
written by Rafiq Khan , August 02, 2007
Thanks for a great tutorial, Anil.

Anil, I'd like to know if one can one auto-apply a hold (not a credit hold) to a Sales Order using Oracle Forms Personalization. If yes, I'd request you to give me the relevant process (setup et al).

regards,
RAFIQ KHAN.
...
written by Anupam , August 08, 2007
Hi Anil,

First of all my heartiest gratitute to you for putting up such a great effort for bringing inside information about this cutting edge technology to us. This is really a great JOB.
I have a wish and i am sure that you will fulfill that in due course. Can you please put up something related to how to change look and feel (I mean from BLAF to CLAF) in order to have a completely different look and feel of a OA frame work based application.


Thanks,

Anupam
...
written by Rajasekhar Hasthi , August 08, 2007
Hi Anil,
Thanks for your great work.The tutorials are very helpfull.
I am working on iPayment(IBY).

1.Ftp'ed all the necessary files in to my local machine from apps server and decompiled the class files in to java files.Also taken webui - xml files from MDS using jdr_utils package.
My problem is i am not able to make directory structure as like in server using jdeveloper.
Can you please tell me how to replicate entire structure of files in jdeveloper as like in apps server?
2.Can you please tell us how to generate debug statements in log files?is there any package for log statements generation?Do we need to set any profile options or do we need to change any configuration fies?I am new Oracle apps .Please let me know at the earliest.

3.What are all the new features in OAFramework?What is the scope of ADF?
Best Regards
Raj
...
written by Rajasekhar Hasthi , August 08, 2007
Hi Anil,
Thanks for your great work.The tutorials are very helpfull.
I am working on iPayment(IBY).

1.Ftp'ed all the necessary files in to my local machine from apps server and decompiled the class files in to java files.Also taken webui - xml files from MDS using jdr_utils package.
My problem is i am not able to make directory structure as like in server using jdeveloper.
Can you please tell me how to replicate entire structure of files in jdeveloper as like in apps server?
2.Can you please tell us how to generate debug statements in log files?is there any package for log statements generation?Do we need to set any profile options or do we need to change any configuration fies?I am new Oracle apps .Please let me know at the earliest.

3.What are all the new features in OAFramework?What is the scope of ADF?
Best Regards
Raj
...
written by Anil Passi , August 08, 2007
Hi Anupam

Style sheets are stored in /OA_HTML/cabo/styles
When OA Fwk started, that time we could override the definition of Existing Styles sheets by making entries in custom.xss
A concept very similar to our good old CUSTOM.pll

But from 11.5.10CU3 onwards, this task has become much simpler.
There is a responsibility named "Customizing Look and Feel Administrator"

See the image below, whereby you can easily create new stylesheets or amend new stylesheets.


Within just 5minutes you can have a new skin for OAF Pages, without writing a single line of code.

Thanks,
Anil Passi
...
written by Rituparna Dey , August 12, 2007
Hi Anil
A very informative article!!
Is there a way/script to import personalizations of 1 environment into another without having to effect them again manually?
Also, please write on Integration of XML Publisher with OAF.

Regards
Ritu
...
written by Anil Passi , August 19, 2007
Hi Ritu

Indeed you can move personalizations from one environment to another.

Prior to 11.5.10, we used to write scripts using XMLExporter and XMLImporter.
However, from 11.5.10 onwards, we can simply use a responsibility named Functional Administrator to download the personalizations into a flat file.

Step 1. Download personalizations using Functional Administrator
Step 2. Tar the files and move them to new environment
Step 3. Unzip/explode tar file in new environment
Step 4. Import the personalizations in new environment, again using Functional Administrator

Thanks,
Anil Passi
...
written by Rituparna Dey , August 20, 2007
Thanks Anil!!
Will try to import personalizations the way you suggested. Waiting for your article on XML Publisher Integration with OAF. Actually i extended the XDOCommonRN.xml. I get the PDF outline on my page after deployment, however not the data. I think there is some problem with the way I am attaching the template to the data. Are you planning to come up with an article/demo sometime soon?

Regards
Ritu
...
written by sarang , October 06, 2007
i had an issue with my custom interface i.e order handling system ohs to project accounting interface.
...
written by Shilpa , October 09, 2007
Hi Anil,

I tried the OAF Personalization for creating the LOV based feild.
I followed all the steps. But it is giving me following error.

oracle.adf.mds.MetadataDefException: Unable to find component with absolute reference = /oracle/apps/fnd/framework/toolbox/labsolutions/webui/HomePG.xxEmpName, XML Path = C:JDeveloperjdevhomejdevmyclassesJRADXML;C:JDevel operjdevhomejdevmyprojects;C:JDeveloperjdevbinjde voamdsxml wk. Please verify that the reference is valid and the definition of the component exists either on the File System or in the MDS Repository.

iproc Non Catalog Request - Catalog LOV
written by Sonia V. , October 23, 2007
Hi Anil,
The information is very helpful.. Thanks a lot...

Using the steps given , i have created a new Category LOV item in the iProc Non Catalog requisition page.
But i am not able to hide the existing Category LOV,
the rendered property is not present when i try to personalize the item.
Can u please let me know how can i go ahead in hiding the extisting LOV.

Many thanks...

Regards,
Sonia
Removing the personalistion
written by shobhit , October 25, 2007
Hi anil,

Great tutorial.I was trying to carry out the personalistion in the hello world page.but made some mistake in typing the address.so when i click apply i got an error.now i want to correct my mistake.but the hello world page is not getting open as it is throwing error.so how can i revert back the personalistion?

Regards
Shobhit
Reg: Where the data gets stored
written by Anoop , November 29, 2007
Hi Anil

The tutorial was great. Am pretty new to OA framework. Can you just tell me if we create a item throough a personalization in a page, where is the value stored in the backend.

how do i link the values to a attribute coloumn

regards
anoop
oa query
written by oracle_enigma , February 07, 2008

i have a oa framweork page with lov's in it.it is working fine in the jdeveloper but when i am migratin it to apps.it is throwing me an exception.something like "" callinfromform='y'....failed:can only fwd frm a jsp or html""
i have only registered the main page under my responsibility and not the regions associated with the lov's.
can u please help me out.

You must be logged in to a comment. Please register if you do not have an account yet.

busy