OA Framework Tutorials Training

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

...
written by pavankumar , April 17, 2007

Hi anil

1)How to register new selfservice form?
2)Breif introduction about personalization?Give me one example?

report abuse

vote down

vote up

Votes: +0

...
written by Ajay Singh , July 05, 2007

good work
ajay singh

report abuse

vote down

vote up

Votes: +0

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

Malini

report abuse

vote down

vote up

Votes: +0

...
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");
ost.setDestination("http://anilpassi.com");
}

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

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passi , August 07, 2007

Hi Sourav

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

APPLICATION_ID MESSAGE_NAME MESSAGE_TEXT
-------------- ------------------------------
231 GLB_ER_LOGGED_USER Logged in as &USERNAME
283 CN_LOGGED_IN_AS Logged In As &USER
510 OKC_REP_USER_PAGE_STAMP Logged In As &USER_NAME

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.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

Regards,
Shoaib.

report abuse

vote down

vote up

Votes: +0

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

Thanks
Mohd

report abuse

vote down

vote up

Votes: +0

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

Thanks,
Krithika.

report abuse

vote down

vote up

Votes: +0

...
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.
smilies/cry.gif

Please Help

report abuse

vote down

vote up

Votes: +0

...
written by Radhika , September 28, 2007

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

report abuse

vote down

vote up

Votes: +0

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.

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.

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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(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)

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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

Thanks
Anil Passi

report abuse

vote down

vote up

Votes: +0

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

Regards,
Naveen

report abuse

vote down

vote up

Votes: +0

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

Regards,
Naveen S

report abuse

vote down

vote up

Votes: +0

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

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

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.

report abuse

vote down

vote up

Votes: +0

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

Regards,
Naveen S

report abuse

vote down

vote up

Votes: +0

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

Thanks
Anil Passi

report abuse

vote down

vote up

Votes: +0

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
Pramil

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passi , October 21, 2007

Hi Pramil

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

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

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 .

Thanks

Manish

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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:7 smilies/cool.gif

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 smilies/cool.gif

at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:20 smilies/cool.gif

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

Regards,
Chandramouli

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

what are the table and column changes in interface tables in finance modules
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

report abuse

vote down

vote up

Votes: +0

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.

Thanks,
Sarath

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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.

MKONDA

report abuse

vote down

vote up

Votes: +0

Open URL in new window
written by MKONDA , December 18, 2007

Used this as the destination URI to open a new window.
[removed]void window.open('http://www.oracle.com')

Thanks
MKONDA

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +0

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.

-Vijay

report abuse

vote down

vote up

Votes: +0

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.

report abuse

vote down

vote up

Votes: +0

...
written by Anil Passii , February 12, 2008

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

report abuse

vote down

vote up

Votes: +0

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.

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

report abuse

vote down

vote up

Votes: +0

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.

Thanks
Ram.

report abuse

vote down

vote up

Votes: +0

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

Cheers
Anil

report abuse

vote down

vote up

Votes: +0

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,
Paramita

report abuse

vote down

vote up

Votes: +1

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

Thanks
Baskar

report abuse

vote down

vote up

Votes: +0

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.

Thanks,
Mahmoud Assem

report abuse

vote down

vote up

Votes: +0

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

report abuse

vote down

vote up

Votes: +1

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 \n This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it
help would be really appreciated
Thanks & Regards
krish

report abuse

vote down

vote up

Votes: +0

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
Thanks
Manav

report abuse

vote down

vote up

Votes: +0

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

ORIGINAL METHOD
------------------
public OAException validateUserAccount(Number number)
{
boolean flag = true;
flag = hasValidFNDUserAndWfAccount(number);
if(!flag)
return new OAException("SQLAP", "OIE_ENTRY_APPROVER_NOT_USER");
else
return null;
}

METHOD IN EXTENDED VO
------------------
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.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

Iprocurement Non-catalog
written by Usha Ananthakrishnan , March 17, 2008

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.

report abuse

vote down

vote up

Votes: +0

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

Thanks
Anil

report abuse

vote down

vote up

Votes: +0

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

age 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.gif