-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Home |
Technical Articles |
Training Articles |
Receive Email for New Articles |
Contributors |
Apps Book |
OA Framework Tutorials Training | | Print | |
Written by Anil Passi | |
Friday, 22 December 2006 | |
Please find a list of OA Framework & Java [in APPS] related articles. OA Framework Related
Installing jDeveloper on your PC to get Started with OA Framework Development [11.5.10 CU4]
OA Framework Tutorial 2 - Step by Step in Audio Video OA Framework Training Tutorial 3 - Add record functionality to the screen A step by step example to deploy the Tutorial onto APPS Instance
Important OA Framework API - JDR_UTILS
D2K Form comparison with OA Framework What is SPEL - Explained with Audio Visual Demo Extension of Application Module in OA Framework - Part 1 Extension of Application Module in OA Framework - Part 2 How to use XMLImporter in OA Framework Add a field with LOV to OA Framework Page, by using Personalization How to build Master-Detail screen in OA Framework - Part 1 OA Framework Extensions - A Presentation
Personalizations with Audio-Video Demo User Level Personalization- For individual user User Level Personalizations by Admin- Shared Folders
Extensions Steps to prepare your jDeveloper environment for Extensions Audio-Video Demo- How to run Oracle Apps pages from jDeveloper - Example iProcurement Enable Personalizations -Why is it important to use Functional Administrator to set Profile Options Defaults in OA Framework - Concepts and practical approach
Add Picklist/Dropdown list field to OAF Screen using extension/Personalization Testing OAF Extensions after deployment- When to bounce what? Add Submit Button Programatically - Concept Sample Code- Add Submit Button Programatically
Java in Oracle Apps Another usage of Java Concurrent Programs Comments
(59)
![]() ![]() written by sanjeev sadhwani , January 11, 2007
too good stuffs.. keep up good work.. master.
![]() written by sanjeev sadhwani , January 11, 2007
too good stuffs.. keep up good work.. master.
![]() written by pavan , January 19, 2007
hi anil
I have doubt abt entity object, what is exact difference between java EO and pl/sql EO? please clarify my doubt with small example. thanking you ![]() written by pavan , January 19, 2007
hi anil
I have doubt abt entity object, what is exact difference between java EO and pl/sql EO? please clarify my doubt with small example. thanking you ![]() written by Anil Passi , January 20, 2007
Hi Pavan
Yes, Oracle Apps lets you have EO in Java form or PL/SQL API. If your EO will use multiple table update/deletes or if there exists an API for re-use then you can use PL/SQL based entity object. An example is whereby you want an entity object to create FND_USER. In this case pl/sql fnd_user_pkg could be used. Please see article http://oracle.anilpassi.com/pl...mpl-2.html Cheers, Anil Passi ![]() written by Anil Passi , January 20, 2007
Hi Pavan
Yes, Oracle Apps lets you have EO in Java form or PL/SQL API. My personal choice is pl/sql. I will publish some example to demonstrate that. Please give me a weeks time, Cheers, Anil Passi ![]() written by Sai Bala , February 26, 2007
Anil,
I stumbled upon this site searching for a workflow customization example, and I have to say this is an awesome site. Thanks a bunch... Sai ![]() written by pavankumar , April 17, 2007
Hi anil
1)How to register new selfservice form? 2)Breif introduction about personalization?Give me one example?
good work
ajay singh
Hi Anil,
Thanks for this fantastic site. I have learnt such a lot on customising and working with OA Framework. Is it possible to open a new window and display an external link like say http://news.bbc.co.uk from a link within an OA Framework page? I tried this on one of the tutorials, converted an ietm to a link and put the destination as http://news.bbc.co.uk, and it worked fine when I ran it from JDeveloper. I am now trying to do something similar, but the destination URL does not get formed correctly, it becomes http://tolkien.uk.tnsofres.com...file_name, file_name is my VO item and I'm currently retrieving the value http://news.bbc.co.uk in there. Your help will be greatly appreciated. Kind Regards Malini
Hi Anil,
First of all thanks for all the articles you have written, you are doing a great job. i had a query ,how can we change the custom home page of apps, as you must have seen in the custom home page i.e the OA.jsp page the message comes like ,Logged in as "XYZ" where xyz represents the login id of the employee which he entered in the login screen,but i want to replace thet messaage by a message Welcome ABC where ABC is the username fetch from the database.Is it possible if yes then how?
Hi Anil
I have a query about the naming convention for the BC4j packages when we create an OA form... Thanks & Regards Silpa
Hi Anil
I have a query about the naming convention for the BC4j packages when we create an OA form...What should be the naming convention? Thanks & Regards Silpa
Hi Anil,
Its really nice of you to have this site setup. thanks buddy for all the info. I need a little clarification in regards to SubTabLayout and Table region. For subTabLayout, the problem comes when the user click on the go for search criteria again, the navigation doesnt get transfered to index 0. I have tried stSelectedIdex property, and my intialindex is set to 0 aswell. For Table region,i want to pass a value from a table cell to populate another table (similar to master-detail knid of thing) when user clicks that particular value. Any suggestion will be highly appreciated. Regards, Shoaib.
Hi Anil,
Stupendous job. Its become my hobby going through your posts. I would like to know if R12 OAF documentation is relased or are we required to use 11.5.10 OAF for R12 as well. Also is there any changes in the 11.5.10 & R12 relase w.r.t OAF. Thanks Mohd
Hi Anil,
Thanks for all the time that u r spending sharing ur valuable knowledge.Thanks a lot once again.Got a chance to learn a lot from the very good articles on OA framework on this site. I have got a requirement and need some pointers that can guide me. Requirement is changing the color of a button. As i am not familiar with applying css using OAF and i couldnt get much help from OAF dev Guide. Can u plz give me some pointers which guide me in completing my requirement. Thanks, Krithika.
Hi Anil,
I want to implement data security in custom pages. This could be done in standard web applications like iSupplier portal by defining the security attributes at the USER and the RESPONSIBILITY level. But when tried on custom pages the same approach doesn`t works. ![]() Please Help
Hi,
I am implementing iRecruitment.There is a Requirement in iRecruitment---Client wants interview schedule form to be available in iRecruitment Manager.So i enabled the schedule button near status.But the problem is 1.When we click on the button, again i have to find the applicant name.Is there anyway , so that i can get the applicant name directly in the find screen 2.After scheduling the interview, when i am closing the form, i am getting the home page.But i need to be in the page where i created the schedule button. Could you please help me by giving the solution for these two points. Regards Radhika
Hi Anil,
i have been following most of ur articles those esp on OAF.truly it had been of great help.Thanks You. ![]() Can u please help me out in implementing file upload/download in my custom OAF page. Download: 1. What to write in "File View Attribute". I have created a table with BLOB data type and my VO attribute column has been mapped to the messageDownload field The problem is that instead of showing the File name as the "Download" link the whole contents of the file is displayed as a link.
while deploying the search page to the oracle apps after successful completion of all steps when registering with apps we are getting an error page showing following error
oracle.apps.fnd.framework.OAException: Could not load application module 'xxt.oracle.apps.ak.xxperson.server.xxPersonAM'. Pls suggest ..
Hi Anil,
First of all thanx for making available such user friendly tutorials especially useful for novice developers... We were trying to deploy search application in oracle apps 11i(11.5.10.2) using Jdeveloper9i patch p6012619_11i_GENERIC we are facing the following problems: 1. The deployment guide(anjani pandey) available at ur portal has a differnt file structure mentioned( myproject exits in jdevbin whereas in our case it is located inside jdevhome) 2. well, after executing the script mentioned for import(C:p6012619_11i_GENERICjdevhomejdevmyprojects xxtoracleappsakxxpersonwebuixxPersonMainPG.xml -username apps -password apps -rootdir C:p6012619_11i_GENERICjdevhomejdevmyprojects -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.32.66)(PORT=1521))(CONNECT_DATA=(SID=TEST)))" it does shows import successful but when we try to accesss the page through Oracle apps (after registering, of course)we get following error messages: (i) oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /apps/oracle/testcomn/java/oracle/apps/ak/xxperson/webui/xxPersonMainPG; (ii) We even changed the HTML call required in apps but every time it shows similar msgs.. We even bounced the Apache server.. Plz suggest a way out...( Kindly also provide explanation i.e logic of import statement)
Hi Anil,
Working in implementation of irecruitment module. Client wants a requirement as below A grid arrangement of checkboxes is required to allow candidates to indicate their capacity to work at different times of the day on the different days of the week. This should look like below Morning Hours Evening Hours Not Available. Mon Tue Wed There should be check boxes, so that applicant can let us know the exact availability of a day. Can you throw some ideas on this ... or do we have any standard bean component to get this done..? Regards, Naveen S
Hi Anil,
Thanks for your ideas .. I have used combination of stacklayout and avancedtable to design the grid. I have few doubts .. 1. Can we change the layout style of a standard page. The client requirement is to move defaultsinglelayout (Standard Look and feel) to defaultDoubleLayout. This is basically to accomodate space and add custom region to the standard one without having scrollbar. 2. If I have added custom region to standard region ... The controllers for standard and custom region will be different... so .. how to commit my transaction in this senario ?? For eg .. irecruitment module have a train of 4 pages, and i have to add custom region in 3 page of the train... controller for my region will be different .. so how can i commit my transaction...? 3. I have to build a new page which facilitates user to send Bulk emails to job seekers... how can we accomplish email functionality in OAF.. Thanks in advance for all your support.. Regards, Naveen
Hi Anil,
I have a quick question ... In your demo we were able to add Flexiblelayout region to standard page and then U have given full path for the stacklayout there. But when I am trying to add a region .. I am unable to see such options lie (Stacklayout,Flexible layout ... etc). On what basis the options over here will get changed... Regards, Naveen S ![]() written by shobhit , October 18, 2007
you have created a great site for the starters like us.thanks a lot.i need to do some customizatio as per the requirements of the project.for that i need to create a new jsp n call an exsisting jsp in the oracle apps.also i need to pass parameters from my new jsp to the inbuilt jsp of apps so that it can populate values there.how can i do this?pls give some solutions.
Hi Anil,
Thanks for all your support .... I have a doubt as how to catch the parameters for a standard page. I have attached a custom region to standard page and when i am trying to query for a static value it is working fine. But I couldn't able to trace out the the parameter name which is storing the value. I have tried by enabling diagnostics option too.. but no luck .. Regards, Naveen S ![]() written by Run OAF from Home , October 21, 2007
Hi Anil,
Can I run a OAF page from Home without having apps installed on my syatem. It asks for Responsibility key and application user name and password in the project property. Please let me know if it is possible Thanks a lot Pramil Hi Anil, I'm a newby in OAF development. Over the past 5 days I've managed to go through the Hello World and couple of other tutorial projects and managed a way to implement a new page for the payroll module. Everything so far has worked out pretty good after migrating the new page from my local development into an actual app server, except for a slight issue with the "setRedirectURL" command. On the server it gives me an error that a forwarding pages needs to be a JSP or HTML, when in fact that is the case. The only way i've been able to get around this issue is to execute the setRedirectURL with the full URL like ("http://xky.server.com/OA_HTML/payslip_temp/file1.html") when before i was only passing in the relative path ("payslip_temp/file1.html"), as it worked without any issues on the local machine. I would like to make the first part of the URL dynamic ("http://xky.server.com/" right now it's hard coded and we would have issues once the code is moved to the another environment) so is there a way to reterive it from the pageContext object ? . I've looked at the getCurrentURL, and number of other similar function but none of them seem to return the full URL. Your input into this would be greatly appreciated . Thanks Manish
Hi Anil,
How r u ? Thanks for your inputs.. It was very helpful for me all the time.. 1. I have personalized standard pages and added custom region to it.. now how can we migrate them to other instance. 2. When I have compiled project in JDEV, It will create classfiles in myclasses directory which also contains RN and PG files. So, what i am doing is move them to $JAVA_TOP and import the PG / RN. But Do we have to create directory structure in $APPL_TOP and move all PG and RN files there ? Is this a repository where we are saving / is there any other purpose ? .. 3. Is there any way to findout the depended objects on a particular region. For example, I have created custom region and now I want to know what are all pages where I have added this .. 4. Can you thorw some ideas on how to change the standard region style eg : defaultSingle layout to double layout.. I have tried your suggestion ((OADefaultDoubleColumnBean)oawebbean).setNumberOfColumns(1), but i couldn't get any solution for that... Thanks , Naveen S
Hi Anil,
I am new to jdev ... In this application which i am working it requires changing the copy to cart functionality ..in case of any items expired copy to cart gives error message ..and business need is to over ride the error message giving the new item reference picked from a custom table ...this mandatorily need not add new item to cart but new item desc should be put on the screen . Now I was trying to open the ShoppingHomePG which has already some extensions on it I ftped the custom folders in the custom path and added to my jdeveloper . As mentioned i have imported the server.xml and available class,xml files too to the jpr . But when i tried to run the home page ..its giving message stack . oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.icx.por.req.server.RequisitionAM'. at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:279) at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:7 ![]() at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1177) at ---- ## Detail 0 ## JBO-30003: The application pool (sea-ax0022.davita.comFINTEST1527oracle.apps.icx.por.req.server.RequisitionAM) failed to checkout an application module due to the following exception: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.CustomClassNotFoundException, msg=JBO-26022: Could not find and load the custom class oracle.apps.icx.por.req.server.RequisitionAMImpl at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1619) at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2366) at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:427) at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:214) at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:473) at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:39 ![]() at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:20 ![]() at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:7 ![]() at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1177) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423) at _OA._jspService(OA.jsp:40) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534) How should i go ahead ..please help . Regards, Chandramouli
I have found out that OADefaultSingleColumnBean is deprecated and its alternative is OAMessageComponentLayout. So there is a method in OADefaultSingleColumnBean called setHeaderDisabled() but its equivalent is not there in OAMessageComponentLayoutBean. i need that method. Please help me .Thank you
![]() written by rajesh.s , November 16, 2007
Hi,
what are the table and column changes in interface tables in finance modules. Thanks in advance for ur response. Thanks Rajesh
Hi Anil,
I am working as Oracle apps techincal cosultant,i started learning OA frame work. I went through your tutorial,its helping me alot.I got an error while developing page i got the following error Error(13, ![]() colud u tell me why this error came. can i download this tutorial? how can i download please let me know. Thanks, Sarath
hi Anil,
Please can you provide highlights on "HTML DB and OA framework comparison" basically 1) when one should use OA Framework -- is it only related to Oracle apps extension or any general project? 2) For any general project, is HTML DB is better or OA Framework ?
Hi Anil,
Thanks for this great site. Is it possible to open a new window and display an external link like say http://www.oracle.com from a link within an OA Framework page? I created a new item of type Static Styled Text but the url opens up in the same window. I am trying to add a link to another page. Thanks for your help. MKONDA
Used this as the destination URI to open a new window.
javascript:void window.open('http://www.oracle.com') Thanks MKONDA
Hi Anil,
Why didn't you give us a trainig on creating a tree. Pls give a training on it.
Anil, Can you offer Weekend online OA Framework Training. we are highly motivated and dedicated 4 members interested to learn on lIne via skype etc.
We are at Houston Tx please reply. -Vijay ![]() written by alok , February 12, 2008
Hi! Anil,
Thanks for all information you have posted on your website. Could you pleas provide correct method to use with example? - Alok.
Hey Alok
OLD METHOD ------------- createWebBean(OAPageContext pageContext, String style) NEW METHOD ------------- createWebBean(OAPageContext pageContext, String style, String dataType, String itemName) Having said so, even Oracle's FND internal classes continue to use old creaeWebBean, feel free to decompile and check those out. There are over 200 instances where oracle haven't migrated their code to new API [as per 11.5.10CU6] Thanks Anil ![]() written by raja anu , February 13, 2008
Hi anil.
Thanks for this great site and the help you are providing. we have a small problem while calling a standard oracle form from OAF page. we tried to open the menu form using the following syntax. form:SYSADMIN:SYSTEM_ADMINISTRATOR:STANDARD:FND_FNDSCAU S Its opening successfully, but when we are trying to pass some values to Menu & User Menu name fields, with the following syntax and values form:SYSADMIN:SYSTEM_ADMINISTRATOR:STANDARD:FND_FNDSCAU S:G_QUERY_FIND=FALSE FND_MENUS.MENU_NAME=SAMPLE_OAF_TEST FND_MENUS.USER_MENU_NAME=SAMPLE_OAF_TEST it is erroring out like UTIL-BAD MENU PARAM(NAME=FND MENUS.MENU_NAME) (VALUE=SAMPLE_OAF_TEST) can you please help us in calling oracle form from the OAF pages by passing values to the form. Thanks raja ![]() written by ram raju , February 15, 2008
Hi anil,
Can you please reply to the above query(Opening a standard oracle form with parameters from OAF page) It's very important for us to resolve this as early as possible. Thanks Ram.
Hi Anil,
I would like to know how to implement radio button in a page. Could you please help me regarding this? Thank you, Paramita
Hi Anil,
I'm very new to OFA, im trying to configure JDeveloper as per the details given in your tutorial. But receiving "Io exception: The Network Adapter could not establish the connection". Not knowing how to resolve this problem. Using Vision instance in my system and JDK not installed. Pls tell some solution how to come out from this problem Thanks Baskar ![]() written by Mahmoud Assem , March 13, 2008
Dear All,
Please can anyone provide me with a tutorial of adding an attachment region and how to view it. Thanks, Mahmoud Assem ![]() written by sai krishna aravapalli , March 16, 2008
Sir to my knowledge ur the genius who are intendending to help new ones on oracle applications
this work would be really appreciated ![]() written by sai krishna aravapalli , March 16, 2008
Hi i am new to oracle applications could anyone forward me ppts and video totorial links
which would help me a lot u can mail me at ask6849@gmail.com help would be really appreciated Thanks & Regards krish
Hi Sir,
i need your advice on one issue i have to work on Here's the detail In OIE.K, when a delegate tries to enter an expense report for an employee following error message pops up "Approver: The specified approver is not defined as a user of the application. Please enter another approver, or select one from the list of values." This occurs when the supervisor of an employee for whom expense report is entered either has an end dated User Record in Oracle or does not exists as an Oracle User (they are only entered as an employee). The Oracle standard functionality is to classify this as an invalid approver. The request is to research and apply a customization to bypass this validation and proceed with the expense report entry even though the supervisor is not a valid supervisor. This is related to OA framework jdeveloper Can you please advice as to how i should proceed .i'll be really greatful to you Thanks Manav
Sir,
I need your help to solve the following issue . The issue is: I have entered the Amount(25.00) in Non-catalog request in IProcurement the item type is "Goods or services billed by amount" and I filled the required field then click "Add to Cart button" we can see the shopping cart detail on left side. When we click the "view cart and checkout button" we will see the "amount(25.00)" in "Quantity" field.Price is 1.00 USD but the Amount will display in "Price" field. Amount is misplaced in quantity field. How can I resolve this problem. Please guide me? Regards, Usha Ananthakrishnan. Technical Developer.
Hi Anil,
we have created an SelfSecured OAF page. this page when loaded on server will work if profile:fnd function validation level =none but when we change this profile option to 'Error' it is not working. where as we have few other SelfSecured pages(log is given below) which are working fine for profile value 'Error'. in Production we are not suppose to change the value to None. so can you please suggest us what could be the issue. below are the log files of our solution and other solution(which is working fine). Our solution: [437]:STATEMENT:[fnd.framework.webui.OAPageSecurity] ![]() [437]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Current Page SelfSecured = true [437]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Current Page matea data securing function = XXAT_POACCL_GUEST_FUNC [437] ![]() ![]() [437] ![]() ![]() [437] ![]() ![]() [437] ![]() ![]() [437] ![]() ![]() [437] ![]() ![]() [437]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:MAC validation status = false [437]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Request parameters validation status = false [437]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Security Level = ERROR [438]:STATEMENT:[fnd.framework.webui.OAPageSecurity] ![]() Other Solution: [40]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Security Level = ERROR [40]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Current Page SelfSecured = false [40]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Current Page matea data securing function = null [40] ![]() ![]() [40] ![]() ![]() [40] ![]() ![]() [40] ![]() ![]() [40] ![]() ![]() [40] ![]() ![]() [41]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:MAC validation status = true [41]:STATEMENT:[fnd.framework.webui.OAPageSecurity]:Request parameters validation status = false [41]:STATEMENT:[fnd.framework.webui.OAPageSecurity] ![]() Thanks, Advait... You must be logged in to a comment. Please register if you do not have an account yet.
|