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
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
Apps2Fusion Articles 
Comments
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.
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
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.Wh at are all the new features in OAFramework?Wha t is the scope of ADF?
Best Regards
Raj
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.Wh at are all the new features in OAFramework?Wha t is the scope of ADF?
Best Regards
Raj
Style sheets are stored in /OA_HTML/cabo/s tyles
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
A very informative article!!
Is there a way/script to import personalization s of 1 environment into another without having to effect them again manually?
Also, please write on Integration of XML Publisher with OAF.
Regards
R itu
Indeed you can move personalization s 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 personalization s into a flat file.
Step 1. Download personalization s using Functional Administrator
S tep 2. Tar the files and move them to new environment
Ste p 3. Unzip/explode tar file in new environment
Ste p 4. Import the personalization s in new environment, again using Functional Administrator
Thanks,
Anil Passi
Will try to import personalization s 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
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.Metadat aDefException: Unable to find component with absolute reference = /oracle/apps/fn d/framework/too lbox/labsolutio ns/webui/HomePG .xxEmpName, XML Path = C:\JDeveloper\j devhome\jdev\my classes\JRADXML ;C:\JDeveloper\ jdevhome\jdev\m yprojects;C:\JD eveloper\jdevbi n\jdev\oamdsxml 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.
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...
Rega rds,
Sonia
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
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
regard s
anoop
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.
I had an problem in form customization.. .my requirement is there is sales order form in order manager responsibility. ..there is field order type...and one lov is attached to the field...i have to sort this lov at runtime as per the responsibility. ..if i am using "xx1 responsibility" then the order type should i can see in the order type field lov must start xx1 i.e "xx1 sales".And if i am login through xx2 responsibility then i should be able to see the order type starting with xx2 i.e "xx2 sales"sales.i am not getting how to get the responsibility name and use this responsibility name to sort the lov value at runtime.would it be possible through Form personization?
I need to modify a Query´s lov on a web page. I'm having trouble finding and knowing where to find documentation that
will explain how to do this. Does anyone know where to find this?
I have read OSO 11i Application Developer’s Guide and Oracle Application Framework
Developer’s Guide (Release 11.5.10 RUP5) but I do not find solution to this
problem.
This is possible by extension
To get a detailed solution to your business requirement, please post the query on
apps2fusion.com/forums/oaf
Please follow the template in the forum to give maximum information and we will respond.
Also please post under relevant section only
Thanks,
A pps2Fusion Forum
Can you please let me know where I can find OSO 11i Application Developer’s Guide?
I was searching in the metalink but couldnot find one.
Thanks
Bi bs
I have a custom page using a query region suing autocustomizati oncriteria. In simple search panel of that i added an LOV item. eg Resource Name. So when i select any resource from LOV and then save view and apply results. I see that only resource name get added in view criteria(checke d through jdr_utils.print document). I want that resource id also gets added to the criteria so we dont have any performance issues. Currently its searching on name only and hence performance issues.
I have created the LOV with Resource Name as Criteria & Return Item and ResourceId as return item. Also ResourceId is there as a formValue in Search Panel region And correct mappings for Id's and name fields are provided.
Plea se help. Any pointers will be appreciated.
T hanks in advance.
Sham
Or send it to my id - ajay_s
You had mentioned in this thread that - Style sheets are stored in /OA_HTML/cabo/s tyles ............ See the image below, whereby you can easily create new stylesheets or amend new stylesheets.... .........
I could not see the image. I am a non technical person, but am required to make changes to the colour on iRec external candidate/site visitor page where the logo is already changed. This is on a 11.5.10.2 instance. Can you give a step by step easy to understand guide on 1. How to change the background colours to match client colours (they gave a gif file and RGB colour code) and 2. How to know if the logo was changed individually or done using a customised stylesheet
Aja y
This is my RT requirement.
Pl ease help me
Thanks
Bhavanam
In LOV page opend seprately on there if we keep search allowed true then we found that in search by feild option eg. two feild name and region.
My requrement is such that by default there is Name but i want that with Description.Is this possible.
Thank you,
Trushar P Gohil
we have a product E-Sourcing, which can integrate with Oracle E-Business Suite.
please email us for a free demo.
thanks
radhe
RSS feed for comments to this post