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
(19)
Subscribe to this comment's feed
...
written by Anupam , August 08, 2007
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
Votes: +2
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
report abuse
vote down
vote up
...
written by Rajasekhar Hasthi , August 08, 2007
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
Votes: +0
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
report abuse
vote down
vote up
...
written by Rajasekhar Hasthi , August 08, 2007
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
Votes: +0
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
report abuse
vote down
vote up
...
written by Anil Passi , August 08, 2007
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
Votes: +0
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
report abuse
vote down
vote up
...
written by Rituparna Dey , August 12, 2007
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
Votes: +0
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
report abuse
vote down
vote up
...
written by Rituparna Dey , August 20, 2007
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
Votes: +0
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
report abuse
vote down
vote up
...
written by sarang , October 06, 2007
written by sarang , October 06, 2007
i had an issue with my custom interface i.e order handling system ohs to project accounting interface.
Votes: +0
report abuse
vote down
vote up
...
written by Shilpa , October 09, 2007
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.
Votes: +0
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.
report abuse
vote down
vote up
iproc Non Catalog Request - Catalog LOV
written by Sonia V. , October 23, 2007
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
Votes: +0
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
report abuse
vote down
vote up
Removing the personalistion
written by shobhit , October 25, 2007
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
Votes: +0
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
report abuse
vote down
vote up
Reg: Where the data gets stored
written by Anoop , November 29, 2007
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
Votes: +0
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
report abuse
vote down
vote up
oa query
written by oracle_enigma , February 07, 2008
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.
report abuse
vote down
vote up
Form Customization
written by sarang , July 07, 2008
written by sarang , July 07, 2008
Hi All,
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?
Votes: +0
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?
report abuse
vote down
vote up
How can LOV's be modified on self-service web pages?
written by Periking , July 29, 2008
written by Periking , July 29, 2008
How can LOV's be modified on self-service web pages?
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.
Votes: +0
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.
report abuse
vote down
vote up
...
written by Forum Admin , July 29, 2008
written by Forum Admin , July 29, 2008
Hi Periking
This is possible by extension
To get a detailed solution to your business requirement, please post the query on
http://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,
Apps2Fusion Forum
Votes: +0
This is possible by extension
To get a detailed solution to your business requirement, please post the query on
http://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,
Apps2Fusion Forum
report abuse
vote down
vote up
Consultant
written by Bibs , January 07, 2010
written by Bibs , January 07, 2010
Periking
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
Bibs
Votes: +0
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
Bibs
report abuse
vote down
vote up
Id fields not coming in saved view criteria for LOV item
written by Sham , July 21, 2010
written by Sham , July 21, 2010
Hi,
I have a custom page using a query region suing autocustomizationcriteria. 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(checked through jdr_utils.printdocument). 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.
Please help. Any pointers will be appreciated.
Thanks in advance.
Sham
Votes: +0
I have a custom page using a query region suing autocustomizationcriteria. 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(checked through jdr_utils.printdocument). 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.
Please help. Any pointers will be appreciated.
Thanks in advance.
Sham
report abuse
vote down
vote up
| < Prev | Next > |
|---|
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.