<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content



Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Related Items

Home arrow Training Articles arrow OA Framework Training
This website has now moved to http://apps2fusion.com

OA Framework Tutorials Training | Print |  E-mail
Written by Anil Passi   
Friday, 22 December 2006

Please find a list of OA Framework & Java [in APPS] related articles.

OA Framework Related


Get Started with OA Framework

Installing jDeveloper on your PC to get Started with OA Framework Development [11.5.10 CU4]

OA Framework Tutorial 1 - Step by Step in Audio Video


OA Framework Tutorial 2 - Step by Step in Audio Video

OA Framework Training Tutorial 3 - Add record functionality to the screen

OA Framework Training Tutorial 4 - Update record functionality to the screen [Also includes deployment instructions and source code ]

A step by step example to deploy the Tutorial onto APPS Instance 


Important OA Framework API - JDR_UTILS 


D2K Form comparison with OA Framework

OA Framework : How to design/build a simple screen that interacts with Database table
   jDeveloper steps to build the screen as above
   Programming the Controller, ApplicationModule to complete this screen

What is MDS - Meta Data Service in OA Framework

What is SPEL - Explained with Audio Visual Demo

Audio Video Demo - How to Embed a Custom Screen into OA Framework Screen

                                 Contains Video Tutorial for steps to develop custom screen and also the extension steps

Audio Video tutorial to explain how Partial Page Rendering Functionality can be built in  OA Framework

Entity Objects :- Where do they fit into our Forms/D2K model

Implement Entity Object using PL/SQL API, in OA Framework

Steps to Extend View Object in OA Framework

Extend Entity Object Substitution [using iProcurement] in OA Framework - An Example

Extend OA Framework to use a WebService[Design]

Captcha Implementation. Step by Step Webservice in OA Framework using java

Steps by Step approach to call a Captcha Webservice from OA Framework

How to Extend a Controller in OA Framework Sceen

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

When to bounce and How to Bounce Apache Server when working on OA Framework

OA Framework page on web

Is extension of Controllers in OA Framework Safe?  [Some Pointers]

Different techniques to debug OA Framework [With Audio-Video demo]

Add a field with LOV to OA Framework Page, by using Personalization

How to call OA Framework Page from Oracle Forms and the syntax for passing parameters

How to build Master-Detail screen in OA Framework - Part 1  

OA Framework Extensions - A Presentation

A Brief History of OA Framework - Presentation

OA Framework R12 Extension Example

Extend OA Framework in R12


Personalizations with Audio-Video Demo

User Level Personalization- For individual user

User Level Personalizations by Admin- Shared Folders

How to move personalizations from one environment to another



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

OA Framework Interview Questions

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
How to write Java Concurrent Programs in Oracle Apps?

Another usage of Java Concurrent Programs

FAQ on OA Framework
FAQ for Extending View Objects in OA Framework

Comments (59)add
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

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,

Anil Passi
written by Sai Bala , February 26, 2007

I stumbled upon this site searching for a workflow customization example, and I have to say this is an awesome site. Thanks a bunch...

written by pavankumar , April 17, 2007
Hi anil

1)How to register new selfservice form?
2)Breif introduction about personalization?Give me one example?
written by Ajay Singh , July 05, 2007
good work
ajay singh
written by Malini , July 13, 2007
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

written by Anil Passi , July 13, 2007
Hi Malini

You can use staticStyledText as shown below

In case you wish to achieve this programatically, then use below approach in controller

import oracle.apps.fnd.framework.webui.beans.* ;
public void processRequest(OAPageContext pageContext, OAWebBean webBean)
super.processRequest(pageContext, webBean);
OAStaticStyledTextBean ost = (OAStaticStyledTextBean)webBean.findChildRecursive("item1") ;
ost.setLabel("Click here for my website");

PS: item1 is the item with style staticStyledText.

You may also use Raw text to achieve the desired results. < a rel="nofollow" href="http://news.bbc.co.uk" >http://news.bbc.co.uk< / a >

In case you are modifying the standard page, then use personalization to create new item of type staticStyledText

Anil Passi
written by Sourav , August 07, 2007
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?
written by Anil Passi , August 07, 2007
Hi Sourav

First you need to find the fnd_message which is responsible for displayinng this.

-------------- ------------------------------
283 CN_LOGGED_IN_AS Logged In As &USER

I have shortlisted 3 for you. Howver to be 100% sure, you need to run debug log after setting that to Yes at statement level ,for the site.

Anil Passi
written by silpa , August 27, 2007
Hi Anil
I have a query about the naming convention for the BC4j packages when we create an OA form...

Thanks & Regards
written by silpa , August 27, 2007
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
written by Shoaib , August 31, 2007
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.

written by anil passi fan , September 03, 2007
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.

written by krithika_gv , September 03, 2007
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.

written by Anil Neema , September 21, 2007
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
written by Radhika , September 28, 2007
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.

File upload/Download in OA framework
written by debashis , October 03, 2007
Hi Anil,
i have been following most of ur articles those esp on OAF.truly it had been of great help.Thanks You. smilies/smiley.gif
Can u please help me out in implementing file upload/download in my custom OAF page.
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.

written by shobhit , October 04, 2007
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 ..

clarifications required
written by Swapnil , October 05, 2007
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(
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="
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)

Grid Arrangement of checkboxes
written by Naveen Sreeramoju , October 05, 2007
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.

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..?

Naveen S
written by Anil Passi , October 07, 2007
Hi Naveen

You could try TableLayoutBean/Rowlayout bean.
Each checkbox will go into a cellformat.
For the first column of the header, its cellformat will contain a spacer. You will need to optimize spacer for its horizontal width.

Anil Passi

Thanks for your advice
written by Naveen Sreeramoju , October 17, 2007
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..


Reg : Adding Regions in Standard page
written by Naveen Sreeramoju , October 17, 2007
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...

Naveen S
written by Anil Passi , October 18, 2007
Hi Naveen

1. Changing from Doublecol to SingleCol, at runtime,
perhaps you could try ((OADefaultDoubleColumnBean)oawebbean).setNumberOfColumns(1);
I haven't tried doing this at my end, hence can't be 100% sure if this is going to work.
2. Nested Controller will be called and within that events generated from train can be captured.
In the nested controller[the one against stacklayout], you can use pageContext.getRootApplicationModule() and then invoke the commit within the root AM.
Additionaly another option, if your custom region is attached to a Custom AM, then you can invoke a commit from custom region
3. Use the code provided in http://scripts4oracle.blogspot...ocate.html for sending mass emails from Oracle EBS
4. Once Flexiblelayout has been created, personalize that item which you have created and withinn that click create to add stacklayout region

Anil Passi
calling an exsisting jsp from a new jsp and also passing parameters to that page
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.
Catching parameters for an OAF Page
written by Naveen Sreeramoju , October 19, 2007
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 ..

Naveen S

written by Anil Passi , October 20, 2007
Hi Naveen
You can find out the list of all the parameters in a controller, by using a method named pageContext.getParameterNames(). This returns Enumeration type object, using which you can iterate over the list of parameters.

Some pages [for example in Oracle Student System] use Session Variables as well.

To analyse Oracle classes, simply decompile and study them.

Anil Passi
Can I run a OAF page from Home without having apps installed on my system
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
written by Anil Passi , October 21, 2007
Hi Pramil

You will require access to APPS Database before you can run the OAF Page

Anil Passi
How to retrieve the fully URL
written by Manish Neupane , October 24, 2007

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 .



Migration of personalizations
written by Naveen Sreeramoju , October 25, 2007
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

Changes to be done to Copy to cart on iProc
written by Chandramouli K , November 14, 2007
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:7smilies/cool.gif
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1177)

## 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:39smilies/cool.gif
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:20smilies/cool.gif
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:7smilies/cool.gif
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 .

Bean classes in OA Framework
written by someone , November 16, 2007
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
what are the table and column changes in interface tables in finance modules
written by rajesh.s , November 16, 2007

what are the table and column changes in interface tables in finance modules.

Thanks in advance for ur response.

Hi Anil,
written by sarathb , December 05, 2007
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,smilies/cool.gif: class xxt.oracle.apps.per.xxperson.schema.server.xxPersonEOImpl should be declared abstract; it does not define method setLastUpdatedBy(oracle.jbo.domain.Number) in class oracle.apps.fnd.framework.server.OAEntityImpl

colud u tell me why this error came.
can i download this tutorial? how can i download please let me know.

OA Framework and HTML DB
written by amey , December 14, 2007
hi Anil,
Please can you provide highlights on "HTML DB and OA framework comparison"
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 ?
Open URL in new window
written by MKONDA , December 17, 2007
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.


Open URL in new window
written by MKONDA , December 18, 2007
Used this as the destination URI to open a new window.
javascript:void window.open('http://www.oracle.com')

written by sumo , February 06, 2008
Hi Anil,
Why didn't you give us a trainig on creating a tree.
Pls give a training on it.
On Line Training
written by Vijay A , February 06, 2008
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.

Method createWebBean(oracle.apps.fnd.framework.webui.OAPageContext, java.lang.String) in class oracle.apps.fnd.framework.webui.OAControllerImpl has been deprecated
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.
written by Anil Passii , February 12, 2008
Hey Alok

createWebBean(OAPageContext pageContext, String style)

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]

Opening a standard oracle form with parameters from OAF page
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.


Its opening successfully, but when we are trying to pass some values to
Menu & User Menu name fields, with the following syntax and values


it is erroring out like

can you please help us in calling oracle form from the OAF pages by passing values to the form.

Opening a standard oracle form with parameters from OAF page
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.

written by Anil Passi , February 15, 2008
Hi Ram

I have'nt done this in past.

However, I notice there is a java class named RunFunction
This class has a method named getRunFunctionLink to which you can pass in responsibility, Function as parameters.

Once you get the URL, you can assign this value to a link bean.

You can also consider invoking oapagecontext.runFunctionURLRedirect(linkStringFromPrevFunction)
I am yet to use this myself, hence you can use this suggestion to initiate your investigations.

Radio Button
written by Paramita Sanyal , February 21, 2008
Hi Anil,

I would like to know how to implement radio button in a page. Could you please help me regarding this?

Thank you,
Problem in configuring JDeveloper
written by Baskar , March 10, 2008
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

Please Help: I need a tutorial for How to an attachment region to a page using OAF ?
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.

Mahmoud Assem
what a wonderful stuff i have never seen this kind of stuff on web
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
Hi could anyone provide ppts and some like this kind of stuff on AP,AR,GL
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
OIE.K customization
written by Manav Manocha , March 16, 2008
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
written by Anil Passi , March 16, 2008
Hi Manav

Usually, we must not bypass such validations.
This validation is there for a good reason.
If your approver does not have an FND_USER account, then how will they ever Approve the expense report.
How will the workflow send them notifications, as they do not have access to application to logon.

What you should be looking to do is to create default FND_USER accounts for all the employees.
All this can be quite easily scripted.

Anyway, in answer to your question, you can extend view object oracle.apps.ap.oie.server.ApproversVO
When you extend the view object, you need to override the method below

public OAException validateUserAccount(Number number)
boolean flag = true;
flag = hasValidFNDUserAndWfAccount(number);
return new OAException("SQLAP", "OIE_ENTRY_APPROVER_NOT_USER");
return null;

public OAException validateUserAccount(Number number)
//do not call super.validateUserAccount(number) ;
return null;

Anyway, I hope you convince your business analysts to not to proceed with this extension.

Anil Passi
Iprocurement Non-catalog
written by Usha Ananthakrishnan , March 17, 2008
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?

Usha Ananthakrishnan.
Technical Developer.

written by Anil Passi , March 17, 2008
Hi Usha,

Sounds like you are facing issue on standard iProc functionality,
Hence please raise SR via metalink

SelfSecured Page giving Mac Validation error
written by adv , March 19, 2008
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]smilies/tongue.gifage Securing Expression = ${oa.FunctionSecurity.XXAT_POACCL_GUEST_FUNC}
[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]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
[437]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
[437]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
[437]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
[437]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
[437]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
[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]smilies/tongue.gifage Securing function = XXAT_POACCL_GUEST_FUNC

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]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
[40]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
[40]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
[40]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
[40]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
[40]smilies/tongue.gifROCEDURE:[fnd.common.WebAppsContext]smilies/shocked.gifracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
[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]smilies/tongue.gifage Securing function = null


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