Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size


OA Framework Tutorials Training

E-mail
User Rating: / 93
PoorBest 

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

 

 


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


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

OA Framework - Develop Page that does not require login - Using GUEST
Hide or change Copyright and Privacy Statement in OA Framework
Creating custom Web ADI Integrators
Embed HTML into OA Framework Page- URL Include and other options
Comments (130)add
...
written by sanjeev sadhwani , January 11, 2007
too good stuffs.. keep up good work.. master.
report abuse
vote down
vote up
Votes: +9
...
written by sanjeev sadhwani , January 11, 2007
too good stuffs.. keep up good work.. master.
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: +1
...
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: +2
...
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: +2
...
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: +2
...
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: +1
...
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: +1
...
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: +1
...
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: +1
...
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. smilies/smiley.gif
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: -1
...
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: +1
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=(ADd***s=(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: +1
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)
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: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 .

Regards,
Chandramouli
report abuse
vote down
vote up
Votes: +1
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: +1
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: +1
...
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: +1
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: +0
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
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.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

Thanks,

Advait...
report abuse
vote down
vote up
Votes: +0
Attachments
written by Ashwini , March 24, 2008
Hi Anil,

I am learning OAF from past 4 months.
I came across the topic of Attachments in OAF.
Can you please provide some information on that.

Thanks in Advance
report abuse
vote down
vote up
Votes: +0
...
written by Pramod Bellamkonda , April 04, 2008
Hi

When I try to Create New Person from your tutorial. First the ManagePersonPG do not show up. GIVES some application id error.

Solved it by giving the path

/xxt/oracle/apps/ak/xxperson/webui/managePersonPG" ---"There was no XXT in your path"


But now when i click "Create New Person" it goes to "ManagePersonPG" but the last record in the table is AUTOMATICALLY POPULATED in the ManagePersonPG Page ?

Is it Some buffer problem, why it is retaining the last record?
report abuse
vote down
vote up
Votes: +1
...
written by Pramod Bellamkonda , April 04, 2008
Hi Anil

where exactly we need to initialize Vo sothat it points to New record in memory.?

where exactly we need to initialize Vo sothat it points to New record in memory?
report abuse
vote down
vote up
Votes: +2
Beginner in OAF
written by Ashwini , April 22, 2008
Hi Anil...

Please guide on how to call a Oracle Form from a OAF screen. You have shown Oracle Form calling OAF page but will vice versa take place?

And also let me know how tough is to start with Jdeveloper 10g. I had worked for 2-3 months on Jdeveloper9.0.3 version.

Please guide me on what all I need to look into this tutorial as a beginner.

Thanks
Ashwini.
report abuse
vote down
vote up
Votes: +0
Run iSupplier Portal page through local machine (urgent)
written by AMIT , April 23, 2008
Hi Anil,
I have to extend few page of iSupplier Portal. I am really trying hard to run the page from my local machine. I have gone through your article on how to setup JDeveloper to run page local.
I have got confusion. You have mentioned about step10. Include all available libraries into jDeveloper project.

What exactly libraries are you talking about?
How can i add any ****PG.xml file which i found using personalization link in project?
Can I just open xml file using open under file menu to include into OAProject?

What is the Import option available under file menu? I am able to use this only for server.xml file.
There is one more option available "Copy files to project Directory". I could not find any help regrading this.

I am completely stuck at xml file which i have downloaded from mds directory..
please guide me how to run any page which we download from mds. I have seen your video to setup jdev to run page on local machine.
There 10gJdeveloper has automatically included all the files under project. I am currently using 9iJDeveloper for 11i10 RUP5. This does not include file automatically.

I can send you screen shot of all steps which i have done. Please help me on this. Its really urgent.

thanks
Amit
report abuse
vote down
vote up
Votes: +1
Extend VO
written by kishore Ryali , April 27, 2008
Reference Link: http://oracle.anilpassi.com/ex...mwork.html

During VO extension, after creation of new view attributes for task_num, award_num etc. you entered the query based on new view xxicx_pa_projects_expend_v.
Does that mean if during patching original view pa_projects_expend_v changes, those upgrades are not propogated to the extended VO.
So is it not breaking the sanity of going for safe VO extensions?

Regards
Kishore Ryali
report abuse
vote down
vote up
Votes: +0
VO's in expert mode
written by Anil Passi- , April 28, 2008
Hi Kishore

You are right, for VO's that are created in expert mode in Oracle, run this risk during the extension.

Thanks,
Anil Passi

report abuse
vote down
vote up
Votes: +0
about OAPageContext.
written by chenlin , April 28, 2008
I just got a question with pageContext.setForwardURL(),I see there is something different between r11 and r12. (I use JDeveloper 10 in R12),But when i followed the sample "OA Framework Training Tutorial 03 " ,i found that the jdeveloper tell me there is an complain error with setForwardURL(),the parameter did not matched!
report abuse
vote down
vote up
Votes: +0
...
written by chenlin , April 28, 2008
When i rebuild the sample i got a error about:
Error(62,25): method setForwardURL(java.lang.String, byte, null, java.util.HashMap, boolean, java.lang.String, byte) not found in interface oracle.apps.fnd.framework.webui.OAPageContext
Who can tell me?
Thanks.
report abuse
vote down
vote up
Votes: +0
...
written by chenlin , April 28, 2008
Thank you ,I have find my answor.
report abuse
vote down
vote up
Votes: +0
There is a BUG in the sample(In OA Framework Tutorials 03)
written by chenlin , April 30, 2008
Hi,I have find a bug in the sample. After i followed the sample(the video),I find that i can not create a new person in "managePersonPG".In fact,i create it in the page,but it no reflect to DB,(I can not get my new person in DB).
And,I already get the why. In the managePersonCO.java file, in the "processFormRequest" method,like:
=============
if ( pageContext.getParameter("savePerson") != null )
{

personam.invokeMethod("savePersonToDatabase") ;

pageContext.setForwardURL(
"OA.jsp?page=/oracle/apps/ak/xxperson/webui/xxPersonMainPG"
, null //not needed as we are retaining menu context
,OAWebBeanConstants.KEEP_MENU_CONTEXT
, null //not needed as we are retaining menu context
,null // no parameters are needed
,true //retain AM
,OAWebBeanConstants.ADD_BREAD_CRUMB_NO
,OAWebBeanConstants.IGNORE_MESSAGES);

}
======================

if I change the "pageContext.getParameter("savePerson") " to " pageContext.getParameter(EVENT_PARAM)", than the problam solved.!!!!
report abuse
vote down
vote up
Votes: -1
Thanks chenlin
written by Anil Passi- , April 30, 2008
Thanks for letting us know
report abuse
vote down
vote up
Votes: +0
...
written by cscus , May 14, 2008
Hi Anil,

How to find WHO column details in a OAF page?

Thanks,
Aryan
report abuse
vote down
vote up
Votes: +1
Need help on JDeveloper 9 download
written by Gopik , May 18, 2008
Hi Anil,

I need Jdev 9i software, but it is not available on the Oracle site, I searched through the net but didn't find it.
Can you pls help me? Where can i download it? Other wise, can i use app11.5.10. 2 with jdev 10? Pls giv give me a suggestion.
Gopi
report abuse
vote down
vote up
Votes: +1
...
written by Anil Passi , May 18, 2008
Hi Gopi

You need to download apps version of jDev from Metalink.
In your case, you need to download patch 4573517 to get the right version of jDeveloper for 11.5.10 CU2

See the metalink note below
---------------------------------------
Subject: How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12
Note:416708.1

Release 11i
OA Framework 5.10 patch JDeveloper 9i Patch
ATG.PF.H (patch 3438354 or Oracle Applications 11.5.10) Patch 4045639 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H
ATG PF CU1 (patch 4017300) Patch 4141787 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1
ATG PF CU2 (patch 4125550) Patch 4573517 Oracle9i JDeveloper with OA Extension for 11.5.10 CU2
11i.ATG_PF.H RUP3 (patch 4334965) Patch 4725670 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3
11i.ATG_PF.H RUP4 (patch 4676589) Patch 5455514 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP4
11i.ATG_PF.H RUP5 (patch 547385smilies/cool.gif Patch 6012619 9IJDeveloper With OA Extension ARU FOR 11i10 RUP5

11i.ATG_PF.H.RUP6 (patch 5903765)
Patch 6469392 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11I10 RUP6
Release 12

ATG Release 12 Version
JDeveloper 10g Patch
12.0.0 Patch 5856648 10g Jdev with OA Extension
12.0.1 (patch 5907545) Patch 5856648 10g Jdev with OA Extension
12.0.2 (patch 5484000 or 5917344) Patch 6491398 10g Jdev with OA Extension ARU for R12 RUP2 (replaces 619741smilies/cool.gif
12.0.3 (patch 6141000 or 6077669) Patch 6509325 10g Jdev with OA Extension ARU for R12 RUP3
12.0.4 (patch 6435000 or 6272680) Patch 6908968 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12 RUP4


Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +1
Thanks for help
written by Gopik , May 19, 2008
Hi Anil,

Nice hearing from you. Now I got the clear picture of Jdev Version and compatibility with Apps.
Thank you very much for your time.

Gopi

report abuse
vote down
vote up
Votes: +0
oracle.jbo.RowCreateException: JBO-25017
written by Cyril PHCAR , May 20, 2008
Hi !

I encounter the following error :

## Detail 0 ##
java.lang.InstantiationException
at sun.reflect.InstantiationExceptionConstructorAccessorImpl. newInstance(InstantiationExceptionConstructorAccessorIm pl.java:30)

Can anybody help me ?

Thanks by advance !

Cyril
(from France)
report abuse
vote down
vote up
Votes: +0
oracle.jbo.RowCreateException: JBO-25017
written by Cyril PHCAR , May 21, 2008
Hi !

I have found the cause : my specific table didn't have Who Columns.

Thanks !

Cyril
report abuse
vote down
vote up
Votes: +2
OA Framework error
written by ShShSar , May 24, 2008
Hi,
I am getting the following error when I was trying to compile the Impl.java files of my EOs,

Error(14,smilies/cool.gif: class xxch.oracle.apps.fnd.schema.server.XXQAEOImpl should be declared abstract; it does not define method setLastUpdatedBy(oracle.jbo.domain.Number) in class oracle.apps.fnd.framework.server.OAEntityImpl

Can you please tell me what I am doing wrong?
report abuse
vote down
vote up
Votes: +0
Problem with EO and VO Creation
written by ShShSar , May 24, 2008
Table UserInfo:
==============
Column NameIDPkNull?Data TypeDefaultHistogramEncryption AlgSalt

USER_PK11NNUMBERNo
USER_NAME2YVARCHAR2 (30 Byte)No
PASSWORD3YVARCHAR2 (16 Byte)No
EMAIL_ID4YVARCHAR2 (60 Byte)No
MOBILE_NUM5YNUMBERNo
CREATED_BY6YNUMBERNo
CREATION_DATE7YDATENo
LAST_UPDATED_BY8YNUMBERNo
LAST_UPDATE_DATE9YDATENo
LAST_UPDATE_LOGIN10YNUMBERNo


Table Questions:
=================
Column NameIDPkNull?Data TypeDefaultHistogramEncryption AlgSalt

QUESTION_ID11NNUMBERNo
QUESTION2YVARCHAR2 (60 Byte)No
CREATED_BY3YNUMBERNo
CREATION_DATE4YDATENo
LAST_UPDATED_BY5YNUMBERNo
LAST_UPDATE_DATE6YDATENo
LAST_UPDATE_LOGIN7YNUMBERNo


Table QA:
==========
Column NameIDPkNull?Data TypeDefaultHistogramEncryption AlgSalt

QA_KEY11NNUMBERNo
USER_PK2NNUMBERNo
QUESTION_ID3YNUMBERNo
ANSWER4YVARCHAR2 (60 Byte)No
CREATED_BY5YNUMBERNo
CREATION_DATE6YDATENo
LAST_UPDATED_BY7YNUMBERNo
LAST_UPDATE_DATE8YDATENo
LAST_UPDATE_LOGIN9YNUMBERNo

Able are the columns in my tables. I am having trouble creating EOs and VOs such that user will enter his userid, pwd, email,mobile and choose all 3 questions and enter answers for them. Thanks in advance.
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi- , May 25, 2008
HI Shsh

To overcome this issue, simply copy past the below lines into your EOImpl
public void setLastUpdateLogin( oracle.jbo.domain.Number n ) {}
public void setLastUpdatedBy( oracle.jbo.domain.Number n ) {}
public void setLastUpdateDate( oracle.jbo.domain.Date n ) {}
public void setCreationDate( oracle.jbo.domain.Date n ) {}
public void setCreatedBy( oracle.jbo.domain.Number n ) {}

Cheers
Anil
report abuse
vote down
vote up
Votes: +0
...
written by santhosh kumar , June 06, 2008

why Oracle changed direction from Oracle Forms to OA Framework and need of oa framework.plz explain me in detail becz i'm new to oaf


thankinu,
santhosh
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , June 06, 2008
Hi Santosh,

It isn't Oracle that changed the direction, the industry itself changed the direction.
However, if you are keen to know the reasons, I request you learn the possibilities of OA Framework extension, and then you will find the answer by yourself.

Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
...
written by Manav , June 06, 2008
HI Anil;

Thanks once again for all your help you have provided to me . I have one more question on Form Personalization. We are on OIE.K and i have a req . from one of client t that they want to SORT credit card transactions in IExpense . I know the steps in order to enable this feature. What i am doing right now is i have assigned my self as a delegate to that user and on Credit Card Transaction page.i am personalizing. However,i want to know is there any way i can personalize this page from any Admin responsibility ,i mean without assigning myself as a delegate to that user and simply personalize (enable sorting order) at site level.

Thanks,
Manav
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi- , June 06, 2008
Hi Manav


For OA Framework screens, if you wish to personalize without going into that screen, first find the full path of that page using "About this Page". Next you can also use Functional Administrator to personalize that page, by creating seeded user level personalization. There is a video demo for the same on website.


In case yours is a D2k screen, then you will have to go to that screen itself and change the default where clause using personalization.

Thanks,
Anil Passi


report abuse
vote down
vote up
Votes: +0
OA framework : List boxes used to select items - can it be done?
written by Joseph , June 27, 2008
Hi Anil,

I would like to develop a page that has two list boxes. List box A, on the left of the form that contains all valid items, and List box B on the right that will include selected items from list box A. Two buttons will be placed between the list boxes. One will be used to move the selected items from list box A to B. And one to move items from B back to A.

List box A will be loaded with items depending on a text field and a combo box. For example, if text field is period "May-08" and combo box action is "Close", in list box A I want to display those companies that have "May-08" period open in their accounting system.

Is this possible with OA framework? If so, can you please give me some tips on what I should research on?

Many thanks
Joseph
report abuse
vote down
vote up
Votes: +0
OA framework : List boxes used to select items - can it be done?
written by Prabhakar Somanathan , June 27, 2008
OA framework has a inbuilt comopnent called Shuttle that performs your Ui requirement.
It also allows to UI for the search you are looking for.

Please read the developer guide chapeter 4 : Implementing Specific Ui features -- > Shuttle

Hope this helps you.


cheers,
Prabhakar.S
report abuse
vote down
vote up
Votes: +0
getting error while running tutorial.jpr
written by vijay sharma , July 02, 2008
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01653: unable to extend table ICX.ICX_SESSION_ATTRIBUTES by 16 in tablespace APPS_TS_TX_DATA
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1367
ORA-06512: at line 1


report abuse
vote down
vote up
Votes: +0
Regarding Insertion of data
written by Rahul Minocha , July 04, 2008
Hi ,

I am having this problem of inserting data simultaneously into multiple tables.....And also the concept of View Link
Can anyone help.....

Thanks
report abuse
vote down
vote up
Votes: +0
...
written by jyo , July 15, 2008
Hi Anil, I tried your tutorial for update person and I encountered a minor issue and would be glad if you could answer this.
When I click in update icon in a row, it takes me to managePersonPG with the correct record to be updated. I enter some details and I click commit data, it takes me to the xxPersonMainPG with the updated record displayed in the query field, where as it should be blank.
I think when the page renders it takes that updated record to be shown in the query field.
what am I missing here ?
Thanks
Jyo
report abuse
vote down
vote up
Votes: +0
diff b/w customization and extension
written by krish , July 23, 2008
Hi Anil,
Thank u for ur guidence.plz clarify my doubt.
can u tell the difference between customization and extensions. plz explain with an simple examples.
both r same?. i didn't find any thing on customization in these tutorials.i need clear idea on customization ie, in which scenerio we go for customization.plz clarify it.

Thanking u,
krish

report abuse
vote down
vote up
Votes: +0
How to set multiple indexes when a Page Renders in Dynamic List Box
written by Shweta Sinha , October 31, 2008
hi,

I am having problem in setting multiple indexes when a Page Renders in Dyanamic List Box.

can anyone help me....

Thanks
Shweta
report abuse
vote down
vote up
Votes: +0
error in opening OA Page
written by Nirmal , December 03, 2008
Hi Anil,
I get the following error when i run the Page.
"http://198.162.100.182:8988/OA_HTML/runregion.jsp
Application Not Found"
What could be wrong. Plz help.
report abuse
vote down
vote up
Votes: +0
Assigning Values to View Attributes
written by A.Malar Selvam , January 29, 2009

Dear Anil,

I am having one problem, kindly guide me how to overcome this.

In a Controller Class ProcessRequest() function i am creating new row and initializing values to some attributes to my views through Application Module Implementation Class as below.

SalesHeadersVOImpl shi = getSalesHeadersVO();
Row r1 = shi.createRow();
r1 = shi.createRow();
r1.setAttribute("SaleOrderHeaderId", headerid);
r1.setNewRowState(Row.STATUS_INITIALIZED);


LinesVOImpl lvo = getLinesVO();
Row r2 = lvo.createRow();
r2 = lvo.createRow();
r2.setAttribute("SaleOrderHeaderId", headerid);
r2.setNewRowState(Row.STATUS_INITIALIZED);

After that I am getting Inputs from the User for the Remaining View Attributes.

Now my problem is while doing getDBTransaction().commit(), i have to assign some values manually to the View Attributes. How can i Achieve this?
Presently I am doing as below, but the values are not committed in the database.


LinesVOImpl lvo = getLinesVO();
SalesHeadersVOImpl shi = getSalesHeadersVO();

shi.setProperty("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
lvo.setProperty("SaleOrderNumber", shi.getProperty("SaleOrderNumber"));

getDBTransaction().commit();


But the values are not affecting in the database.

Kindly guide me how to assign values to the View Attributes while doing getDBTransaction().commit().

Regards.

A.Malar Selvam.



report abuse
vote down
vote up
Votes: +0
SE
written by Payal , February 24, 2009
Hi Anil,

I'm new to OA framework and am learning from your articles. I've a requirement in oracle configuration module to go to an external site on a click of a button. The configuration details are entered in that site and stored in an XML string. That site is in asp.
Now, I need to get the control back to oracle configurator page and read the xml string and populate the fields on oracle page from the xml string.

I've personalized the oracle page to navigate to configurator site. I also know how to read xml string and enter the specific values in text fields.
I'm looking for a way to redirect to same oracle page from asp page without asking the user to relogin.
Do you know how can this be achieved?

Thanks,
Payal
report abuse
vote down
vote up
Votes: +1
iprocurement
written by Srini , March 10, 2009
I have a requirement in iproc to make the project field required based on a value in account segments. Appreciate any help in this regard
report abuse
vote down
vote up
Votes: +0
Please send me the next URL.
written by Keerthana , March 31, 2009
Hi Anil,
Please let me know the next-part URL (s)(Vedio and Audio link) which are after the below mentioned URL.
http://anilpassi.com/demo/oa_framework/runPageFromjDev/prepare_environment_etc1/prepare_environment_etc1.html



report abuse
vote down
vote up
Votes: +1
FND, Message Name: SECURITY_INVALID_DBC_PARAMETER
written by Malar Selvam , April 20, 2009
Hi Anil,

I tried to connect with ORacle Apps Release 12.0.4 using JDeveloper 10.3.1. I have created a test page, but i was getting the below error:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SECURITY_INVALID_DBC_PARAMETER

Then i found, i have to use Patch 6908968 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12 RUP4. I have downloaded that Patch also.
But, now i am getting 500 Internal Server Error while running my Custom Page.

Then I, just tried to test my Application Module (Empty one not having any View). I am getting the following Error.

JBO-30003: The application pool (.120C3C3AD59) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-25222: Unable to create application module.

I tried to run the HelloWorld Sampe Application, that also giving the same problem.

Kindly guide me, how to configure JDeveloper for Release 12.0.4.

Regards.

Malar.

report abuse
vote down
vote up
Votes: +0
Mapping Servlet in R12
written by Malar Selvam , April 30, 2009
Dear Anil,

I have developed some custom pages for R12. In one of the page to read the image i am using one Servlet. I have configured the Servlet path in web.xml located in "jdevhomejdevmyhtmlOA_HTMLWEB-INF" as below
------------------------------

ReadImage
oracle.apps.xxcust.sshrms.CO.ReadImage



ReadImage
/readimage

------------------------------

And it is working fine.

Now i want to deploy the pages into Apps Server. Please let me know,
1) In which file i have to include the Servlet Mapping?
2) In wich TOP the file will be there.
3) And the Path of the File.

Regards.

Malar.
report abuse
vote down
vote up
Votes: +0
Servlet Mapping
written by Malar Selvam , May 05, 2009
Hi Anil,

I found that we have to place servlet mapping in orion-web.xml.

path:
cd $INST_TOP

cd ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/

Servlet Mapping:
------------------------------

ReadImage
oracle.apps.xxcust.sshrms.CO.ReadImage



ReadImage
/readimage

------------------------------

Now it is working fine.

But in some regular interval the service is stopping. After that i need to start the service again and again.

Please guide me how to resolve the issue.

Regards.

Malar.


report abuse
vote down
vote up
Votes: +1
Read Image
written by Malar Selvam , May 17, 2009
Hi Anil,

Regarding Servlet Mapping issue for Reading Image, i got one more solution from one POST. In that instead of separate servlet class they are reading the image column and creating a temporary file as below. It is working fine locally in my JDeveloper, but once deployed into my Linux Server the image is not displaying and also there is no error.

Controller Class:

Serializable[] param = {pageContext.getTemporaryImageLocation()};

pageContext.getApplicationModule(webBean).invokeMethod("initImg",param);
OAImageBean oaimagebean = (OAImageBean)webBean.findIndexedChildRecursive("EmpImg");
if(oaimagebean != null)
{
oaimagebean.setAttributeValue(UIConstants.SOURCE_ATTR, new OADataBoundValueViewObject(oaimagebean, "ImageSource"));
oaimagebean.setWidth(100);
oaimagebean.setHeight(110);
oaimagebean.setBorderWidth(2);
}
if(pageContext.isLoggingEnabled(1))
pageContext.writeDiagnostics(this, "Leaving processRequest..", 1);

----------------
In AM:


public void initImg(String s2)
{
OAViewObjectImpl oaviewobjectimpl = getEmpProfileVO();
oaviewobjectimpl.executeQuery();
if(oaviewobjectimpl.first() != null)
{
OARow oarow = (OARow)oaviewobjectimpl.first();
BlobDomain blobdomain = (BlobDomain)oarow.getAttribute("Image");
if(blobdomain != null)
{
String s3 = createFile(s2, blobdomain, "Emp"+oarow.getAttribute("PersonId").toString());
oarow.setAttribute("ImageSource", s3);
}
}
}



public void fromInputToOutput(InputStream inputstream, OutputStream outputstream) throws IOException
{
byte abyte0[] = new byte[255];
int i = 255;
do
{
if(i != '377')
break;
i = inputstream.read(abyte0);
if(i < 0)
break;
outputstream.write(abyte0, 0, i);
} while(true);
outputstream.close();
inputstream.close();
}

public String createFile(String s, BlobDomain blobdomain, String s1)
{
File file = new File(s);
if(!file.exists())
file.mkdirs();
File file1 = new File(s, s1);
try
{
fromInputToOutput(blobdomain.getBinaryStream(), new FileOutputStream(file1));
}
catch(IOException ioexception)
{
ioexception.printStackTrace();
}
return (new StringBuilder()).append("fwk/t/").append(file1.getName()).toString();
}

-----------------------------------------------

VO:

SELECT
PERSON_ID, EMPLOYEE_NUMBER, EMP_NAME, DOJ, ORG_NAME, POSITION, DIVISION, DEPT, LOCATION,
PAYROLL_ID, CONFIRMATION_DATE, EMAIL_ADd***s, WORK_TELEPHONE, EMP_TYPE, IMAGE, Null Image_Source
FROM
XXGTI_EMPPRO

---------------------------

Using this solution, i am able to display the image locally running from JDeveloper, but after deployed into our LINUX Server it is not displaying the image.

Can u please guide me.

Regards.

Malar.
report abuse
vote down
vote up
Votes: +0
OA Framework : Jdeveloper database conncetion error
written by Shaswat Kumar , June 17, 2009
Hi Anil,

I was going thru your OA framework tutorial and following step by step.
but While trying to connect to database thru Jdeveloper getting this error.

io exception: connection refused(description=(tmp=)(vsnnum=169870080)(err=12505) (error_stack=(error=(code=12505)(emfi=4))))

Please help.

Thanks
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi- , June 17, 2009
Try to telnet to that machine on which DB is hosted,

telnet machineNameHere PortNumberHere

Does it connect from your PC?

If not, then you have firewall issues

Thanks
Anil Passi
report abuse
vote down
vote up
Votes: +0
Calling External Application with Parameters
written by Malar Selvam , July 21, 2009
Dear Anil,

I want to call an External Application when clicking a button. For testing I have given "http://www.yahoo.com" and it is working fine.

My Requirement is i would like to call an External Web Application like this. But i need to pass Values from OAF Pages as parameters.

How can we achieve this? Please guide me.

Regards.

Malar.
report abuse
vote down
vote up
Votes: +0
Calling External URL with Parameter
written by Malar Selvam , July 22, 2009
Dear Anil,

When Clicking a button, I want to popup an external URL from my Controller Class. I need to pass some parameters (OAF Page Field Values) dynamically.

Please guide me how to achieve this?

Regards.

Malar.
report abuse
vote down
vote up
Votes: +0
Poup URL from OAF Controller Class
written by Malar Selvam , July 23, 2009
Dear Anil,

We need to popup an OAF Page, for that i put the following code in my ProcessFormRequest function, but it is giving JavaScript Error:Objected Expected.

Kindly guide us to solve the issue.
---------------------
String pubOrderId = param;
StringBuffer l_buffer = new StringBuffer();
StringBuffer l_buffer1 = new StringBuffer();
l_buffer.append("[removed]mywin = openWindow(top, '");
l_buffer1.append("/oracle/apps/xxcust/adec/webui/tempPG");
l_buffer1.append("&retainAM=Y");
l_buffer1.append("¶m="+pubOrderId);
pageContext.putJavaScriptFunction("SomeName",l_buffer.toString());
-------------------

I paste below the javascript dynamically created.

[removed]mywin = openWindow(top, '/OA_HTML/OA.jsp?page=/oracle/apps/xxcust/adec/webui/tempPG&retainAM=Y¶m=233&addBreadCrumb=S&_ti=499301981&oapc=2&oas=dtn4Te15R-JfH2bTwjbOcQ..', 'lovWindow', {width:750, height:550},false,'dialog',null);

Kindly give us a solution.

Regards.

Malar.
report abuse
vote down
vote up
Votes: +0
About pageContext
written by Radhika , September 11, 2009
Hi,

I got the same error mentioned by chenlin on 28th April 2008. He said he got the solution but its not mentioned here. Could you please tell me the solution?

Regards,
Radhika.
report abuse
vote down
vote up
Votes: +0
About pageContext
written by Radhika , September 11, 2009
The error is

Error(68,21): method setForwardURL(java.lang.String, null, byte, null, java.util.HashMap, boolean, java.lang.String, byte) not found in interface oracle.apps.fnd.framework.webui.OAPageContext
report abuse
vote down
vote up
Votes: +0
running standard oracle customer online page in jdev
written by Ramya , September 18, 2009
Hi Anil,

I downloaded all the files from Server.I am able to run the page in Jdev. The page which I currently run has a Drop down list which has a PPR event.So on selecting values in the drop down am able to get the respective attributes below. But whenever I select a particular value I am getting the below mentioned error. for the remaining values It is working fine.



oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoSuchMethodError, msg=oracle.apps.fnd.framework.server.OAViewDef.addPersistentAttrDef(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZBLjava/lang/Stringsmilies/wink.gifV



Please do help me resolving the issue.



Thanks
Ramya
report abuse
vote down
vote up
Votes: +1
doubt in oaf
written by Lakshminarayna , September 22, 2009
Hi,

i have created external lov but my requiremnt is user entered free text in lov.
please help me
report abuse
vote down
vote up
Votes: +0
Iexpenses report notification customization
written by anithan , November 05, 2009
Hi Anil,

I am doing Internet Expenses report notification customization in that I have to add each and every field name has to be with English and Chinese languages. Some profile developed to capture the Chinese characters. Can I call the profile in the prompt of the field? Or any other way is there Please give reply it is urgent requirement.
Thanks in advance

Regards,
Anitha.


report abuse
vote down
vote up
Votes: +0
Controller Extensions
written by Lakshminarayana , January 12, 2010
Hi Anil,

I extended CO. when i click on personalization page page layout Region pencil icon is not visible. how to do the personalization particular CO


Regards,
Lakshminarayana
report abuse
vote down
vote up
Votes: -1
Problem with DFF personalization
written by prashanthreddy , March 15, 2010
Hi Anil,

I have created a DFF item in a page. But i am facing a wiered problem. I am mentioning the steps that i have used to create the item and problem i faced at subsequent steps.

Here are the steps i followed
1)Create “Flex” Item at Location Level in the “Other” section on the Hire and Rehire: Person Details page (Hire & Rehire responsibility)

2)Return to Application and check that the field is being displayed correctly:

3)Cancel the Hire & Rehire transaction.
Begin a new Hire & Rehire transaction
Enter Basic Details
Continue to the next page (Rehire: Person Details)
Note that the field is NOT displayed

4)If I were to click “Personalize Page”, then do nothing and click “Return to Application”, the field is then displayed


Please help me out in solving this issues.

Thanks
Prashanth
report abuse
vote down
vote up
Votes: +0
...
written by andolsi , March 25, 2010
hi,
i got the some error like Radhika, and i found the solution, you have to import com.sun.java.util.collections.HashMap not java.utili.HashMap.

thanks
report abuse
vote down
vote up
Votes: +0
How to build Master-Detail screen in OA Framework - Part2 is not available
written by Harishnunna , April 08, 2010
Hi Anil,

Can you please give me the link for How to build Master-Detail screen in OA Framework - Part2 and also other parts in this topic.

Thanks,
Harish.
report abuse
vote down
vote up
Votes: +2
great stuff
written by Santo , April 11, 2010
Hi Anil
Great job
It is very helpful
report abuse
vote down
vote up
Votes: +0
How deploy the custome page in to apps instance
written by Raghunandan , April 15, 2010
I would appreciate ur work over here. This is very very use ful site for apps consultants. I'm new to OAF. Can u please provide me the step to be followed to deplooy
tha custom page into the apps instance. I need the step by step procedure.

Thanks in advance.......
Raghu
report abuse
vote down
vote up
Votes: +0
LOV in LOV in OA Framework
written by Sreeram Vaskuri , May 28, 2010
Hi Anil

I have one busniness requirement like LOV inside few more Serach fileds required like inside LOV region 1 LOV 2. Dropdown 3. Normal input field and TAb out should be work when enter any value in main inputlov.Could you please provide the solution on this.This is very urgent for my client business.

Thanks
Sreeram Vaskuri
report abuse
vote down
vote up
Votes: +0
Auto-Query on Page Load
written by Jaime McLamb , June 10, 2010
Hi Anil,

I have taken several of your training courses on JDeveloper and they are awesome! Thank you so much for putting them together and sharing them with everyone! I am new to JDeveloper and I am using JDeveloper 10g. I have a requirement to create a new tab on the SSHR Employee Self Service - Employee History View Page. I want to create a custom page in JDeveloper and create a new tab on the seeded page that links to the new custom page - I am hoping this is going to work. I have created a VO based on a custom query that I wrote to obtain the bonus information for the person logged into Oracle Apps. I created the VO with that query using View Attributes that I defined to hold the fields from my custom query, created an AM based on that VO, and I created a PG based on the AM. The issue that I am having is that I do not want to have to search to obtain the data on page load. I want the query to automatically execute on page load. Right now, no results are being returned when the page loads. I have to click on Go to execute a blind query to obtain the results. Do you know of a setting that will allow the results to be automatically queries on page load in 10g?

Thank you so much for your time!

Jaime
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi- , June 10, 2010
You can create a controller for your custom region. In processRequest, use oapagecontext.getEmployeeId() to fetch the current logged in person_id
Using that, you can dynamically set the where clause of view object and achieve auto query for that person that has logged in
report abuse
vote down
vote up
Votes: +0
Adding a subtab to a seeded OA Framework page
written by Jaime McLamb , June 22, 2010
Anil,

Thank you so much for your help! The Auto-Query is working great now!!! I am currently trying to embed the custom Region into a new Sub-Tab on the Employee Self Service - History Views Page. Unfortunately, the new subtab is not showing up. I completed the following steps.

1. Created sasEmpBonusHistoryVO, sasEmpBonusHistoryAM, sasEmpBonusHistoryRN, and sasEmpBonusHistoryCO in JDeveloper. The Region Type is stackLayout.
2. Deployed all files to the proper $JAVA_TOP webui and server directories
3. Imported sasEmpBonusHistoryRN into the database
4. Added the following site level customization to the oracleappsperselfservicemgrviewswebuiEmployeeVie wsPG and imported the change into the database afterwards :





5. To enable the tab and link on the page, I added the following function level customization to the oracleappsperselfservicemgrviewswebuiEmployeeVie wsPG and imported the change into the database afterwards :









6. Cleared all cache, logged out and back in, but the tab is not showing up. Actually, the personalization link in the upper right hand corner of the History Views Page (EmployeeViewsPG) can no longer be clicked either.

Just as a test, I removed the site and function level customizations, so that the personalization link would work again and I added the region to the main part of the EmployeeViewsPG (not within a tab) using personalization - item style of Flexible Layout and Flexible Content extending to the /sas/oracle/apps/per/selfservice/mgrviews/webui/sasEmpBonusHistoryRN per the "OA Framework Screen Extension by Embedding a Custom Page" training video you created and it worked great when adding it to the main part of the page using Flexible Layout. Unfortunately, the requirement is that the Region has to be part of a brand new subtab for Bonus information instead.

Do you know what I may be doing wrong that is preventing this sub tab from displaying on the SSHR Employee Self Service History Page in steps 1-6 above?

Thank you again for all of your help!

Jaime
report abuse
vote down
vote up
Votes: +0
Adding a subtab to a seeded OA Framework page
written by Jaime McLamb , June 23, 2010
Hi Anil,

Please ignore my previous comment, I figured it out last night smilies/smiley.gif

I was able to get this working by adding a new function from System Adminstrator responsibility > Application > Function and adding that new function to the menu (System Adminstrator responsibility > Application > Menu) used by the Employee - History Views Page! All is working perfectly now!

Just in case anyone needs this information for a similar task, I am going to attempt to repaste the tags that were filtered out in yesterday's request in #'s 4 and 5 :

4. Attempting to repost tags for step 4 from previous post: ' '

5. Attempting to repost tags for step 5 from previous post: ' '

If the tags still do not make it, they are also posted in forum : http://forums.oracle.com/forum...0&tstart=0

Thanks again for your help with this!

Jaime
report abuse
vote down
vote up
Votes: +0
Displaying Master Detail Records differently
written by Yasser , July 19, 2010
Hi Anil,

I was wondering if it would be possible to display the header record immediately followed by its child records ?

So for example:

Expense_Report_headers:

Report_Header_ID, Total
100, 150
101, 600


Expense_Report_Lines:
Report_Header_ID, Line_ID, type, amount
100, 1, airfare, 100
100, 2, taxi, 50
101,1, lodging 500
101,2, meals, 100

And we'd like to see if the OAF page can display :

Report_Header_ID, Total
100, 150
Line_ID, type, amount
1, airfare, 100
2, taxi, 50
Report_Header_ID, Total
101, 600
Line_ID, type, amount
1, lodging 500
2, meals, 100

We are currently using Oracle EBS 11.5.10 RUP 7

Thanks again for all your help !
report abuse
vote down
vote up
Votes: +0
...
written by Ken , August 17, 2010
Hi Anil,

In your lesson on PPR, the application module uses 2 different approaches to get a handle for the view object....

The code that is called from the controller's processRequest method uses...
public void initializePPRPVO()
{
OAViewObject vo = getxxPPR01PVO();

...while the code that is called from the controller's processFormRequest method uses...
public void handleUOMChangeEvent()
{
OAViewObject pVO = (OAViewObject)findViewObject("xxPPR01PVO");

Is there a reason for doing it like that?

Thanks for all you do,
Ken
report abuse
vote down
vote up
Votes: +0
Need to Buy OA Framework Application training video
written by Ashraf Ashour , September 02, 2010
Hi,

I need to buy 'Building OA Framework Application' training video. Please advise.

Regards...Ashraf
report abuse
vote down
vote up
Votes: +0
To change language on the Oracle 'Self Service Work Requests' page
written by Siddhi Dwivedi , October 06, 2010
Hi,

We have a responsiblity 'Self Service Work Requests' and a menu 'Work Requests' which opens Oracle Asset Management's Work Requests page.
We have got a new requirement to display all the text (like button text , field text LOV filed text) in Portuguese instead of English.

Menu for this responsibility is 'Self Service Maintenance Home View Work Request'
and function for Work Reuest is 'Work Request for Enterprise Asset Management' and the URL for this function is
'OA.jsp?akRegionCode=EAM_WR_VIEW_REQUEST&akRegionApplicationId=426&OAPB=EAM_BRAND_NAME&OAHP=EAM_MAIN_SS&eAMReleaseSearch=Y'

I tried to change the long lable in portuguese for AK Region 'EAM_WR_VIEW_REQUEST' and bounced the Apache server but it didn't work.

I am not sure whether I need to customize the page or personalization will solve my purpose.
Could you please help me to implement this change?

Thanks & Regards,
Siddhi
report abuse
vote down
vote up
Votes: +0
POPlist Problem
written by Md.Mofizur Rahaman , December 20, 2010
Hi,Anil,
Hope you are fine.
i am facing a problem to develop a application with OAF.
My scenario is :
if i select a value from e poplist named "Diivision" then another poplist named "Department"will show only the department of that division.
that means the value of the second poplist will be filtered depending on the value of first poplist.

please reply
report abuse
vote down
vote up
Votes: +1
Oracle Application Framework (OAF) Online training
written by Ashish Raj , September 11, 2011
http://www.adivaconsulting.com...ining.html
report abuse
vote down
vote up
Votes: +0
Not able to access the link provided for OAF training 'OA_Framework_Tutorial_03.htm'
written by Basha77 , March 26, 2012
Hi Anil,

I just started learning OAF by going through the OAF Tutorials provided at your site. Somehow am not able to view the OA_Framework_Tutorial_03.htm page....its just getting stuck while downloading...Can you please add the proper tutorial page...so that I can proceed further.

Thanks in advance...

Regards,
Aslam
report abuse
vote down
vote up
Votes: +0
Insert Hyperlink in iRecruitment Module Pages
written by rahulsharma20 , April 16, 2013
Hi Anil Sir,

I would like to insert a custom hyperlink on iRecruitment page linked to the Client's website. Please help me on this issue. thanx in advance. i had tried searching everywhere. i hope i will find the solution here.
report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy
Last Updated ( Tuesday, 29 July 2008 16:14 )  

Related Items

Search apps2fusion


albuterol sulfate inhalation aerosol arthritis alternative treatment diet prednisone canada drug store levitra preisvergleich where to buy medrol how much does cialis cost in australia roxithromycin overnight new canadian drug laws 2011 viagra effects time cialis jelly online pharmacies with out prescription where to buy ampicillin online canada discount strattera of canada lloyds pharmacy allergy reliever cialis super active india sale accutane long term effectiveness buy coreg with remeron canadian online overnight pharmacy propranolol reviews for anxiety propecia 1mg tablets hair loss buy remeron 30 mg prescription prilosec otc depakote without a script prescription cod cheap lotensin buy no prescription hyzaar comments tinidazole without prescription pills levitra price 20 mg prinivil over the counter drugs fda approved online pharmacies no prescription ordering calan generic prescription where to buy xenical with no prescription where can i get cipro from cymbalta mg mexico buy effexor xr 150 online without generic protonix uk tetracycline from india buy ditropan tablets mexico plendil cost comparison flagyl drug in fr pharmacy methotrexate canadian online overnight pharmacy cheap canadian tadacip no prescription alli ride shop coupon code furosemide pills albendazole over the counter uk cheap albenza order abilify on line canada order lozol online no presctiption cialis online pharmacy no prescription buy floxin otic buy yasmin mg order bactroban without rx side effects of atorvastatin 10 mg viagra medicine used zithromax antibiotic lisinopril on line uk internetonlinedrugstore viagra store usa uk buy cialis super active without prescription celebrex without prescription periactin without a script prairie stone rx tadalafil without a script brand cialis top 10 drug sales 2011 buy viagra super active online drugstore com buy allegra online can i buy silagra in canada viagra soft 50mg canada buy plavix without prescription buspar online meds revatio injection package insert order adhd medicine online wellbutrin without a rx clomid tablets price uk buy viagra professional without prescription lasix generic name furosemide order lisinopril rx erection packs 2 drugs cymbalta generic form cialis originale online best over the counter pain pills where can i buy inderal mg where to buy cipro hc otic buy anxiety hyzaar blood pressure coupons ciprolisina canada nitroglycerin visa augmentin online from canada buy zoloft tablets us liposafe mg order trazodone noprescrition needed canada online pharmacy prednisolone canada pharmacy genuine diclofenac dostinex tablets product information buy bentyl paypal generic actos 30mg tablet buy diamox usa pharmacy can buy amoxicillin over counter spain paroxetine prescription only doctor protonix pharmacies what is pyridium medication where to buy renagel with visa extra cheap tabs keflex and alcohol intake depakote without a script cheap cod buy calan online overnight delivery actoplus met mg canadian rx novo prednisone for dogs side effects periactin pills online in the usa buy abilify 20mg online cheap indian viagra no prescription floxin online overnight delivery tetracycline from canadian pharmacy where to buy voltaren tablets cymbalta with prescription where cane i buy kamagra in london top 10 meds online review online pharmacy legal usa online lexapro overnight delivery nitroglycerin trusted online drug stores in canada manly brand viagra celebrex com overnight valtrex levitra medicine good how to purchase cordarone forzest review best place to buy trandate online licensed pharmacy cabgolin licensed pharmacy pyridium pilex online order buy cheap prevacid online cheap propranolol uk ciprofloxacin hcl 500mg medicine buy serpina without prescription bupropion generic side effects what is the best antibiotic for bronchitis order alli on line usa cymbalta 30 mg and alcohol meijer herbal water pills uk buy tadacip without prescription canadian pharmacy arjuna maxalt online from usa order methylphenidate online medicine for abortion new blood pressure treatment 2009 atorlip-10 to purchase without a prescription safe mexitil no precription arthritis home treatment for dogs order cephalexin uk pharmacy amoxil dosages order brand cialis 20 mg order avodart from india without prescription canadian pharmacy lotrisone moduretic online without rx online meds without a prescription buy vpxl tablets us decadron canada no prescription can i order vytorin online boots alli weight loss aid purchase adhd medicine buy lexapro tablets canada how to buy lisinopril in canada buy pantoprazole sodium 40 mg diovan generic 2012 buy cheap avodart without generic flagyl medicine online prescription drug paroxetine deprax canadian background diabetic retinopathy walmart prescriptions for 4 dollars list what is buspar mg used to treat viagra vs cialis 2012 liposafe over the counter tricare mail order pharmacy clomid for sale where to buy viagra super active without a prescription discount cephalexin prescription tamoxifen from sigma enaril coupon buy midamor with no script kamagra for sale in uk is there a shortage of pravachol generic prevacid canada brand viagra online canadian pharmacy pills torsemide generic usa safe to buy generic kamagra from usa order aciclovir rx nexium on line alesse where can i buy ciprofloxacin dosage dose purchase adalat oros online pharmacy vermox lowest price online where can i get suhagra from what is prednisone medication used for no script lithium mg hydrochlorothiazide generic price non prescription mobic requip prescription drug information buy zopiclone uk no prescription where to buy periactin with amex ordering finpecia usa antivert tablets buy indian pharmacy congress 2009 ahmedabad craigslist glasgow ky taking viagra drinking alcohol myambutol order in the us what is cafergot mg used to treat lisinopril pills online in the uk requip buy canada alli side effects funny cardura doxazosin drugs blood dog arthritis treatment tylenol canada celexa tablets online buy bupron have no prescription safe strattera no precription order tetracycline on line mexico order januvia 50 mg how to use cialis 20mg purchase plendil on line in canada ceftin pills online in the uk alternative medicine back pain relief propecia online pharmacies with out prescription buy retin a cream in uk amitriptyline sleep dosage hydrochlorothiazide birth control online australia there is none like you lyrics tabs lenny leblanc purchase ortho tri cyclen genuine generic clonidine online can you buy viagra over counter mexico alli available over counter canada nolvadex over the counter canada ampicillin and gentamicin compatibility phenergan generic form zoloft prescriptions valtrex online in usa zanaflex shopping buy doxycycline tablets 100mg buy cheap brand cialis levitra mexican propranolol prescription overnight cialis 10mg duration 24 hr medical centre melbourne singulair without a prescription from canada sildenafil pulmonary hypertension newborn how to purchase kamagra buy viagra canada approved canadian buy femara online thru paypals can i buy isoniazid in canada levitra costco price us pharmacies online that sell ephedraxin crestor tablets 10mg amoxil india companies only generic drugs online canada abilify coupons rebates cheapest albendazole online without sending prescription medicine by mail purchase vantin on line in usa cheap 1 accutane mg isotretinoin bactrim medication error zenegra usa sale purchase indocin online digoxin mg canadian rx where can i get some glucophage sertralina efectos colaterales buy bupropion paypal order elavil drug can you buy floxin can you take cialis viagra together order plavix 75mg clopidogrel cialis generico e20 feldene online without rx generic cialis from india safe propecia over the counter soma pharmacy india purchase generic zestril prednisone pharmacy prices are there free samples of viagra purchase arjuna on line in canada phentermine 37 5 price walmart order now order altace generic tinidazole from china actoplus from china buy estrace tablets us evista drug in usa pharmacy motilium mexico no prescription pariet buy no prescription forum prix du cialis en pharmacie dosis recomendada para tomar aciclovir roxithromycin buy online us albendazole tablets buy finpecia online no prescription clomiphene citrate organon purchase generic cardizem buy nizoral shampoo hair loss symptoms too much synthroid medicine aurochem laboratories i private limited buy decadron+injection over the counter drugs similar to fucidin aciphex where can i buy order diarex on line canada is there a drug comparative to cymbalta order diovan pills buy generic cefixime online no prescription the drugstore cowboys band buy lipitor in canada ciprofloxacin 500mg antibiotics used treat pain pills addiction pregnancy free birth control pills indianapolis lisinopril 20 mg tab myla medicamento lipiblock orlistate performance enhancement drugs legal paroxetine uk companies only sildenafil citrate sublingual tablets motrin online without rx cialis by mail no prescription can viagra be bought over the counter in london cialis 20 mg 12 st ck preis canadian meds world best place to buy avodart in mexico prevacid canada otc buy generic tetracycline online buying somas with a mastercard rosuvastatin fast canada ranitidine tablets dosage use suhagra tablets zyloprim medication on line best place to buy betnovate without a prescription is effexor xr generic the same antidepressant cheapest viagra uk online order allegra online buy advair online overnight delivery vantin canada pharmacy furosemide buy usa where do i cialis in uk south carolina pharmacies for sale medrol to buy in the uk without a prescription ipharmacy professional colchicine tablets online buy accutane uk online pharmacy can i order haldol online discount pharmacy no prescription viagra plus buy uk buy rx online without a prescription best place to buy provera in india quickest glucophage order zyvox online no prescription with a amex lisinopril overnight evista from australia buy yaz birth control no prescription ds no prescription bactrim interactions buy augmentin online without prescription ethionamide on line in the canada erythromycin tablets for acne reviews what is motilium syrup used for order elavil finpecia online pharmacies vermox plus precio best depression medicine avodart fast india amoxil capsules pregnancy prescription strength buy nizoral levitra 10 mg paypal buy amoxil fast delivery online cheap calan generic name levitra price comparison cheapest place to buy chloromycetin beta blockers online cheap viagra without online pharmacy lasuna to purchase without a prescription cialis jelly buy without wellbutrin sr for purchase without a prescription clomid fast uk side effects after stopping prednisone pfizer viagra price in india 2012 craigslist london cars amitriptyline alcohol 10mg buy isoptin online safely lantus online canada where to buy motilium without a prescription doxazosin for purchase without a prescription buy exelon lowest price online pharmacy yagara donde comprar viagra sin receta buenos aires female viagra online no prescription buy diovan with paypal cardizem pills online in the uk generic nolvadex safe where to buy bactrim with amex order plavix medication purchase femara on line in usa where to buy lamictal online without rx viagra clinic singapore cost of accutane acne treatment order isoptin online no prescription with a mastercard order roxithromycin from usa without prescription purchase retino a cream 0 05 online sildenafil 100mg tablets india prescription buy nizoral online accutane wiki drug generic viagra sold in the united states female viagra cream buy pills india amitriptyline generic brand bay prednisone amantadine sulfate 100mg purchase furosemide 40 mg suprax online order natural osteoarthritis treatment reviews erection packs 1 without a prescription buying finasteride online uk diclofenac drugs forum enalaprol lowest buy crestor with no script augmentin generic mexico order minipress online no prescription with a amex best website to order drugs without prescription zyloprim fast usa approved online pharmacies canada zithromax online purchase order buy cheap chloromycetin viagra building canada generic zenegra canada purchase accutane 5mg elocon ointment dosage buy plavix india levitra plus drug in usa pharmacy canada pharmacies online that sell zestril tadalafil europa buy weight loss drugs without prescription indian jelly viagra online cheap order lotensin from canada without prescription drug allergy testing minocin no prescription needed order aricept prescription order alesse online non prescription albenza dosage worms what is viagra yahoo answers pill best prescription nausea medicine where can i buy bactrim online cabgolin for purchase without a prescription 15 mg ritalin street price best viagra in india sitagliptin metformin combination coumadin without a prescription buy diclofenac gel online doxycycline uses treatment discount viagra mg atarax tablets used for viagra tablets price in chennai revatio medication use propecia online pharmacy shipped to canada florinef buy online canada buy norvasc online us no prescription the canadian pharmacy one item clomid ovulation calculator check this out buy elocon paypal voltaren buy india purchase cephalexin oral suspension frumil canadian online overnight pharmacy drugs that cause sexual dysfunction safe dosage valtrex during pregnancy ordering benicar hct order medrol 4 mg female cialis canadian online overnight pharmacy alphagan best online non prescription pharmacy buy generic dilantin online no prescription how to buy bentyl online free trial cialis com order amitriptyline generic canada order elocon without prescription cardinal without feathers suhagra 100mg where to buy lexapro online mexico tadalis sx low cost accutane cheap mexico pharmacy buy cheap reglan discount aciclovir online prescription cheap universe lyrics zoloft dosage during pregnancy cialis green pharmacy viagra cialis srbija prodaja differin cream and waxing natural fertility pills for women doxycycline side effects forum flomax where to buy in canada where can i buy differin tablets healthy meals meat potatoes man are albuterol and ventolin the same purchase risperdal 2mg anafranil online canadian azithromycin dosage children sinusitis eye allergies symptoms treatment order 1 trial erection packs viagra pills x mg viagra red stromectol where to get cheapest place to buy lamictal crestor without a script prednisone side effects on cbc order weight loss shakes wellbutrin sr mg canadian rx hytrin to buy in the usa without a prescription is there a shortage of femara order avodart online without rx i want to pay some doxycycline doxazosin mg order where do i citalopram in india decadron without a perscription bystolic canadian source where to buy amaryllis plants bulbs buy cialis exeter canadian ecotoxicology levitra cialis viagra better generic elavil pills viagra pills for men side effects how to buy exelon patch buy generic nolvadex tamoxifen what do synthroid tablets look like stromectol fast usa micardis prescription price vytorin birth control online canada zanaflex to buy in the canada without a prescription protonix cheap india pharmacy u s online pharmacy for clomid aslene orlistat 120mg canada and citalopram cialis order to nigeria flumach seller web pharmacy reviews atorlip-10 buy no prescription legal order valium online sbp prophylaxis ciprofloxacin dose white colored contacts non prescription crestor online coupons buy cefixime online without a prescription can you get lotrisone over the counter tesco pharmacy viagra betaloc price doxycycline dogs ear infection eritromicina acne topica viagra drugs india actos comunicativos entrevista buy cheap viagra super active+ viagra soft usa generic trade name hydrochlorothiazide viagra jelly delivered to your home order pills alli weight loss how to get viagra sample online drug store best site to buy cialis online alphagan pharmacies brimonidine ophthalmic seroquel 300 mg bipolar atorlip-5 over counter cephalexin online prescription is there a generic available for cymbalta where to buy vytorin without a prescription best anti anxiety medication over the counter paxil by mail buy keftab with a mastercard buy cheap xanax doxycycline acne worse before better levitra hong kong lamisil canada pharmacy generic lipitor pills hyzaar no prescription overnight delivery india pharmacies online that sell cialis super active where to buy alli cheapest how much does alesse cost in canada protonix medicine used for purchase lamictal 200mg world best online pharmacy reviews where can i buy zenegra mg methotrexate online with out prescription purchase generic lipitor ritalin stores clomid ovulation calendar for girl order adalat 2 pharmacy risperdal canadian online overnight pharmacy coming off citalopram 20mg cheap non prescription colored drug non prescription januvia prescription drug order lipitor 40mg effexor xr dosage for ocd prescription periactin signs symptoms ovulation clomid oregon state university ranking mechanical engineering purchase periactin cheap kamagra supplier uk overnight delivery cheap floxin prescription purchase flonase on line in canada can i buy permethrin 5 cream over the counter buy albendazole 400 mg fucidin delivered to your home flomax medicine ikawe all natural viagra prescription drugs uk customs what is doxycycline hyclate 100mg alphagan where to buy in canada where alesse price generic acular best place to buy glucophage online tadacip canadian medications without prescription allermax mexico cialis wholesale prices diclofenaco para que sirve skelaxin reviews side effects generic cialis oral jelly very cheap arjuna cheapest endep paypal purchase tadacip on line in australia biaxin medication on line medication online provera diurex water pills dose buspar where to get buy generics from india singulair shortage low dose prednisone in dogs ms phd in pharmacy in canada ordering biaxin canada ethionamide online no prescription sildenafil pulmonary hypertension pediatric best place to buy proventil in usa ic bupropion hcl xl dosage how much does proventil cost buy eutirox viagra for ladies blood periactin medication uses treatment fasigyn tinidazole my accutane journal proscar pills online in the uk elavil complaints medicament cialis 20mg prix where can i buy femara tablets canadian pharmacy mail order online nolvadex dosage gyno the cost of propecia in hong kong prescription cream order estrace albendazole fda approved to buy without prescription order abilify mexico rabeprazole brand cialis shortage how much is tadalafil 10mg dosage viagra cream erection packs 2 generic name best place to buy dostinex in uk cheap cleocin mg purchase clomid canada purchase antibiotics online amoxicillin 500mg viagra soft trusted online drug stores in canada levitra professional australia pharmacy adapalenum coupon normal dosage of cialis purchase isoptin online colchysat canada buy ethionamide paypal canadian pharmacy nizoral trial erection packs 2 non perscription countries cheap buy amoxil online without purchase lanoxin on line in canada chloromycetin canada companies only levitra professional canadian pharmacy online actoplus without prescription medication anafranil on line in the usa side effects of zithromax in women metformin hcl 850 mg tablets where to buy strattera online mexico topamax to buy in the usa without a prescription anxiety pills names buy humorap methotrexate medicine definition zyvox no script diflucan in india purchase cipro online no prescription comprar capsulas alli online non prescription viagra ray ban tadacip mg uk order desyrel rx doxycycline hyclate dose for acne cialis cheap online pharmacy buy alphagan discount over the counter pills similar to viagra cheap cialis in uk cheap colchicine mg metformin drugs to avoid lincocin noprescrition needed canada online pharmacy buy alphagan online canada buy viagra online review buy ephedrine slimming tablets drugs similar to cialis super active ayurvedic medicines for depression and anxiety order online drugstore cheap colchicine zyloprim online purchase actors in cialis commercials no script robaxin mg retin cheapest rate non prescription viagra online uk cheapest roxithromycin drugs com safe viagra deals pharmacy abilify overnight delivery purchase decadron lowest price cheap canadian hytrin no prescription metformin generic india elocon online uk discount oxcarb styplon by mail where to buy rosuvastatin ciprofloxacin uses uti effexor xr online cheap where can i get some hytrin hytrin medication on line buy cialis canadian pharmacy canadian drug store largo fl online pharmacy florinef generic prednisone online levitra professional no prescription fedex ups when will viagra be a generic brand viagra fast usa suhagra birth control online australia phenergan canada lamictal buy no prescription side effects of coming off effexor xr order ethionamide buy cheap generic buy revatio online from mexico paxil pills pink generic augmentin uk buy cialis generic line ajanta pharmaceuticals india alternative to nexium medication viagra best price uk altace generic canada fake viagra prescription online drugstore brand cialis mg no prescription drugs order erection packs 11 online pharmacy store in usa eurax mg no prescription can i bring back prescription drugs from mexico suprax no prescription fedex ups coupons for plavix prescription metoclopramide discounted citalopram generic pfizer viagra 50mg preis diclofenac purchase robaxin without prescription cialis 5mg online kaufen seroquel pharmacies prix du cialis en pharmacie 2011 levitra online pharmacy no prescription generic drugs toradol canada buy alphagan us drugs order buy paxil mg online strattera buy uk buying delestrogen buy reglan online thru paypals bleeding during ovulation clomid where to buy diarex online canada nombre generico viagra chile bactroban ointment no prescription buy generic finasteride online orlistat canadian online overnight pharmacy cialis soft on line effexor xr from canadian pharmacy buy mevacor without a subscription tabs overnight buy fda approved viagra ordering omnicef on line flagyl suspension order motilium online without rx risperdal mg canada pharmacies in windsor ct revatio cost canadian how easy is it to buy prescription drugs in mexico perdorimi i viagra is abilify available on line in canada azithromycin side effects rash for itching canadian pharmaceuticals online buy accutane online buy biaxin cheap prescription cod orlistat buy canada cialis soft discount no prescription what is advair diskus mg used to treat alli aka xenical orlistat lexapro 20 mg dose citalopram uk boots canadian lantus xetum watches discount prescription solutions prior authorization fax number cost of amitriptyline without insurance rx drug description carafate buy online us where to buy cleocin online canada buy aceon online without a prescription gout allopurinol dosage order bupropion from usa without prescription tadacip fast india se puede comprar viagra en estados unidos methotrexate isoptin drugs viagra super active drug in germany pharmacy safe to buy generic ephedraxin from canada maxalt shop tamoxifen medicine herbal viagra liquid where is the cheapest place to buy alli diet pills drugs can you fill prescription without using your insurance generic lipitor usa viagra paypal france hyzaar online from usa order cialis canadian pharmacy nexium tablets ordering atarax mexico ventolin expectorant capsule side effects walmart pharmacy online pharmacy refills where can i buy carafate tablets viagra prijs belgie ranitidine prescription medicine celebrex side effects celebrex medication buy doxycycline hyclate 20mg reviews on canadian family pharmacy pfrizer pharmacies where to buy motilium mg prilosec prescription vs otc discount erection packs 1 otc best weight loss pills available in india over the counter prilosec side effects buy cefixime pills online medication for depression anxiety and panic attacks alli diet pill reviews uk over the counter medicine tenormin diamox drugs cialis jelly medication on line chlamydia treatment doxycycline dose cvs viagra price liquid anxiety medication for children safe diamox no prescription craigslist belfast me order dostinex free delivery prescription where to buy accutane from india buy differin online from usa effexor xr medication reviews compare drug prices walmart cvs buy zyprexa mg what is the cheapest adhd med viagra plus usa no prescription can you buy real viagra from canada purchase cialis jelly on line in canada generic viagra reviews forum guaranteed bristol myers squibb pharmaceuticals limited antivert delivery pharmacy cheap what is the medicine lisinopril used for propranolol no prescription overnight delivery canada chloramphenicol tablets online retail pharmacy assistant salary in canada tadalafil 20mg cipla tretinoin cream 0 025 buy online valacyclovir 500 mg side effects cheap no prescription buy elavil order cardura lowest price healthy choice manicotti formaggio viagra cialis buy uk prednisone 20 mg tablets uses drugstore makeup uk zanaflex online without rx cheapest antivert prescription medication over the counter nexium alternatives erymax nextdayflyers inderal no rx prograf no prescription needed canadian online pharmacy any coupons for cymbalta synthroid generic equivalent canadian generic drugs association order triamterene online purchase cafergot on line in uk levitra prescription price phenergan lowest price betnovate over the counter drugs printable viagra coupon over the counter sex pills for men canadian schools natural medicine clomid for men side effects cycle prograf order online no prescription purchasing sarafem online diovan generic release buy protonix online india no prescription generic methotrexate price buy viagra toronto store amantadine hydrochloride betnovate ointment online cheapest weight loss camp salbutamol ventolin syrup cheap paroxat fluoxetine current price erection packs 1 albenza 200 mg ciprofloxacin hydrochloride ophthalmic solution ear cholestoplex order in the us can i order elocon online overnight erection packs 1 cialis canada zyvox tablets online how often to take albendazole where to vote in pa cheap uk buy accutane online isotretinoin pravachol noprescrition needed usa online pharmacy trial erection packs 1 over counter accutane cost in canada wikipedia de levitra plus trial erection packs 1 overnight pharmacy differin gel 0 3 cost exelon prescription drugs how long does it take to get off effexor xr buy ventolin nebules no prescription decadron online meds very cheap ortho tri cyclen accutane long term effects women what are metformin hydrochloride tablets used for what is the best online pharmacy without a script buy abana low price generic for protonix i v finasteride tablets uk how to get pain pills from a doctor lasix senza ricetta medica over the counter drugs similar to eurax synthroid thyroid medication side effects viagra medication on line ajanta pharma ltd hyderabad buy atarax cheap generic ventolin syrup side effects nitroglycerin dosage and administration best viagra in india for men viagra sublingual buy uk buy cheap sumycin order methotrexate online no prescription with a amex sildenafil chewable tablets clomid without iui propecia buy online no prescription voltaren 100 mg tabletten atorlip-10 no script purchase cephalexin in india water pills to lose weight at walmart walmart pharmacy jobs in louisiana buy clonidine with a mastercard canada discount pravachol azithromycin uses for chlamydia levitra pills for sale how many fluoxetine pills to overdose buy canada prilosec be taken with wellbutrin xl online pharmacy order zithromax buspar generic price cheapest clonidine paypal can you drink alcohol and take accutane buy fake ortho tricyclen ordering aldactone generic colchicine india propecia reviews uk cheap allopurinol us pharmacy online zovirax tabletas 500 mg precio can buy mebendazole boots buy bactroban cream no prescription drug allegra over the counter vs prescription usa meds online review propecia rezeptfrei order bactrim online no prescription best place order levitra generic buy generic viagra cheapest terramycin without a script cialis daily vs viagra generic viagra buy uk canadianmedicinenow com reviews can you buy viagra usa lamisil no prescription needed buy cheap kamagra suppliers uk online buy depo provera shot online lisinopril discount code lamisil from cheap diclofenac gel body building best online viagra blog doxycycline hyclate 100mg cap espanol purchase clonidine hydrochloride buy nitroglycerin online safely how do i buy viagra from tesco 2 5 mg ritalin street price order levitra super active online without rx cheap cialis 10mg tablets lexapro prices walmart feldene without prescription pills no script blopress mg levitra commercial actress finasteride use hair loss buy terramycin online now buy citalopram hydrobromide do men take clomiphene zovirax tablet 800 mg 40 tb can i get viagra without seeing a doctor plendil prescription assistance program tenormin dosages can you purchase ambien online buy birth control pill online coreg pharmacies where to triamterene buy cheap generic us pharmacies online that sell zovirax buy cephalexin 250 mg 500 capsules ordering norvasc purchase micardis mg order metformin online no prescription with a echeck robaxin over counter crestor pills buy can you purchase cialis online lasix fast uk strattera australia companies only cheap benicar 40 mg januvia non perscription countries where to inject methotrexate for abortion where can i buy kamagra online keflex side effects doctor tricor buy no prescription voltaren emulgel usa yasmine galenorn books in order can 25mg viagra work what infections is flagyl used to treat how to get levitra professional sialis bluebirds where can i get toradol dose atorlip-20 canada online no prescription prescription drug celebrex arthritis pain order buy elocon cream buy amitriptyline online uk how to buy antivert in canada periactin without a prescription from canada generic propranolol usa order retin a without prescription canada purchase alli online no prescription buy cheap furosemide buy alli online weight loss aid aarp approved canadian pharmacies buy cordarone online overnight delivery buy zolpidem online purchasing nitroglycerin online where can i buy alli in stock can you buy viagra over the counter boots side effects clomid success rate kamagra 100mg uk cheap aciclovir 200mg pharmacy online motrin buy online us purchase doxycycline for dogs finpecia order in the us tretinoin mg canadian rx viagra generic price levitra cialis professional generic cialis professional generic levaquin what is maxalt 10mg used for nizoral tablets hair loss vardenafil hcl 20mg tab s buy viagra in northern ireland revia without a prescription wellbutrin sr reviews weight loss generic pill photos indian advair diskus prescription long term usage of nexium effexor xr low cost purchase citalopram in canada buy lilly cialis brand name canadian insomnia guidelines allopurinol pills buy elimination half life effexor xr artrenac sale maxifort 100mg indocin generic usa arjuna online canadian worldwide pharmacy uk buy styplon online canada no prescription tetracycline patient reviews nitrofurantoin without prescription medication glucophage no prescription sildenafil rx drugstore online order clonidine online no prescription atacand on line in the usa buy cheapest alli online lipitor from australia herbal viagra suppliers uk prescription motrin pregnancy discount protonix mg etodolac 400 mg tablet for dogs north american pharmacy online reviews buy revia online with no prescription generic for allegra d 12 hours treatment of primary dysmenorrhea with diclofenac sodium buy plendil online cialis order online canada diclofenac sodium 75 mg uses vpxl birth control online mexico little blue pill review does alli pill work weight loss list of medical drugs 2009 voltaren australia pharmacy prix propecia pharmacie toulouse viagra professional lowest price online duetact in usa order unisom online no prescription with a mastercard canadian pharmacy drug prices online buy online pollo feliz estado de mexico canadian pharmacy uk amitriptyline discount ceftin otc university of toronto pharmacy application digoxin canadian online generic clopidogrel bisulfate 75 mg tablets plavix where can youtube get viagra over the counter canada and dostinex amitriptyline low dose should how to buy nolvadex in canada pain pills addiction detox aciphex mg order bystolic dosage range medco mail order medications online medsource oklahoma where to buy cheap diazepam rosuvastatin over the counter usa where can i buy clomid from prescription wellbutrin sr from canada purchase dilantin 100 mg online methotrexate dose for cancer atarax no prescription needed order where do i levitra professional in uk side effects of prednisone long term buy isotrex gel ampicillin dosages children vpxl uk companies only abilify dosages bipolar disorder viagra online paying with an echeck buy tramadol buy albenza how to purchase valtrex buy lopressor drug viagra legal buy line is it legal to buy prescriptions drugs online zofran no prescription buy actoplus met without a subscription kroger pharmacy refill policy buy ambien cheap online avapro usa purchase minocin mg generic amitriptyline uk generic name for alesse side effects diflucan 150 mg price bystolic 10 mg side effects purchase viagra 10 mg order augmentin canada a good web page to buy erythromycin with no script amoxil canadian online overnight pharmacy coumadin cheap canada pharmacy viagra vs cialis reviews cost viagra vs levitra vs cialis soma 350 mg street price carbacot mexico prescription cheapest trial erection packs 2 birth control online canada where to buy vytorin with amex is it illegal to order prescription drugs online from canada fenofibratum overnight is betnovate n good for acne cefoprox price antivert medication side effects flomax drug information side effects boots ireland pharmacy luvox over the counter generic price allopurinol 100mg cefixime to buy vardenafil user reviews canada buy risperdal without prescription american express canada gift card side effects of prednisone in women buy propecia pills in the india buy tadalafil tablets 20mg lamisilate creme dose prednisolone generic name buy prescription viagra online india cheap anapsique best place to order cialis in us where to buy trial erection packs 2 with amex once daily cialis cost nolvadex from usa minoxidil 15 recall purchase metformin on line in usa cheap antibiotics online without order coumadin no rx canadian pharmacy nitroglycerin mg buy buy liposafe low cheap price nizagara mg uk where to buy doxycycline 100mg biaxin generic usa cheap voltaren uk natural viagra products effexor xr buy canada buy cheap klonopin online buy aricept drugstore donepezil what medication can you take for anxiety buy flagyl pills online viagra side effects men prescription drugs with no prescription needed proper dose of cephalexin for dogs doxycycline hyclate generic periostat viagra women ireland unicure remedies pvt ltd sildenafil citrate baclofene et sevrage alcool cholestoplex from canada cheap anafranil prices discount who is buying vera bradley buy dilantin medication where to buy dipyridamole with mastercard canadian avalide azithromycin z pack dose doctor soma pharmacy propranolol discount price levitra generic is it is itlegal to buy prescriptions in mexico rx buys review order lisinopril from usa without prescription canadian drugs generic cialis buy bargain viagra online cheap liposafe pills online in the usa awccanadianpharmacy review zyvox canada buy generic diovan mg mexico pill rx health order trazodone products kroger pharmacy hours houston purchase brand amoxil online no prescription proventil buy india purchase doxycycline in us buy generic rythmol online with prescription citalopram generic for celexa where to buy metformin online usa cialis professional usa 24 7 pharmacy canada purchase colchicine in usa bactim to buy online where can i get some cardizem differin cream reviews makeupalley can ultram called into pharmacy suhagra store india where to buy neurontin with echeck purchase flomax on line in australia buy viagra over the counter london boots non prescription alli prescription robaxin used buy generic nexium online with prescription robaxin to buy where do i cialis soft in australia no prescription aciclovir licensed pharmacy accutane metoclopramide for purchase without a prescription buy generic fucidin online with prescription where to buy diazepam 10mg medicine calander side effects donde comprar cialis online aciclovir fast uk viagra sin receta andorra where to buy ed drugs online order soma online overnight delivery fucidin no prescription overnight delivery buy glucophage low cheap price buy minipress price of viagra at walgreens ventolin drug in usa pharmacy 1mg finasteride generic brand levitra generic usa best site for evista toradol free shipping nitroglycerin tablets non prescription is there a cheaper alternative to propecia inderal online without rx zanaflex mg no prescription safe trileptal no prescription periactin in usa low dose amitriptyline anxiety endep actoplus met mexico pharmacy super active overnight delivery soft buy cialis order pharmacy buy ditropan online buy glucophage online from canada how to buy prescriptions online from mexico tamoxifen over the counter drugs does viagra for women really work can buy viagra online australia where to get methotrexate buy brand cialis pills in the mexico when to take viagra for best results buy cheap lexapro online ventolin medication overnight delivery plendil cheap us pharmacy canada pharmacy drugstore long after azithromycin alcohol cheap ariclaim generic cialis online buy buy silagra tablets usa the canadian drugstore tampa dr martin get free viagra pills canadian canada pharmacy exam board buy betapace online safely viagra washington dc requip buy usa the chepest lotensin buy prednisone online canada buy augmentin without prescription dufine lowest buy generic sildenafil citrate online pariet without prescriptions inderal lowest price cialis super active no prescription needed anti anxiety medications benzodiazepines what is accutane cost comparison buy strattera online nitroglycerin generic name fucidin h cream reviews online desyrel over the counter best anxiety medication to take cialis medication class most effective slimming pills in india lexapro generic when is it going generic buy trandate canada generic cialis online tadalafil diovan reviews avodart prescription medicine where to buy colchicine tablets overnight ampicillin canadian source allegra pharmacies purchase cialis on line in the uk alphagan online order myambutol prescription assistance is allegra 180 over the counter prescription propecia price in india where to buy dilantin online canada oristat pills canada combivent zixen trimix gmt 1000m propecia 1 mg propak pharmacy trileptal order online generic synthroid pills how to buy hytrin online amaryl comments northwest pharmacy convention 2012 renagel lowest price online levitra pharmacies cheapest cialis online viagra sale uk cheap cialis 50 euro buy shampoo online nz motilium online canada buy generic prednisone how much does propecia cost ramipril cough experiences diamox where can i buy order zenegra online no prescription with a visa robaxin without a prescription from mexico amantadine drug for dogs flagyl buy australia prescriptions cod fedex vantin phenergan pills online in the india online keftab overnight delivery buy effexor xr online no prescription buy nitrofurantoin uk delivery without cheap abilify orlistat from biocon allopurinol tablets and alcohol fluseren by mail desyrel no prescription sumycin drug in usa pharmacy anxiety medication cipralex lexapro prescription drug revatio quickest hydrochlorothiazide pharmaceutical companies in india 2012 a good web page to buy zebeta with no script generic prevacid for infants codeine promethazine dosage recreational methotrexate combination therapy rheumatoid arthritis shuddha guggulu without prescription medication can you take viagra while drinking alcohol colchicine cheap india pharmacy tylenol rapid tabs dosage viagra pharmacy online sale apo-metronidazole in pregnancy cheap cephalexin natural testosterone cream gel where can i buy atarax tablets actoplus met cheap us pharmacy uk pharmacies online that sell periactin purchase colchicine on line in mexico buy cheap havaianas online australia discount renovators warehouse adelaide order cheap viagra online uk 100mg what does doxycycline hyclate 100mg treat levitra professional buy mexico allegra over the counter concept buy alesse contraception drug buy elocon online from australia buy allopurinol usa buy actoplus met lowest price accutane reviews bactrim online no prescription cheap amoxil usa buy alphagan p generic brimonidine where can i buy levofloxacin canada buy premarin without prescription bactrim ds acne medication propranolol without rx diltiazem hcl canada discount atorlip-20 of canada clomiphene citrate for men results buy amitriptyline line cheapest where to buy avalide with echeck buy torsemide online thru paypals buy bactrim canada isoniazid uk boots mexico buy abana heartcare bupropion xl 300 mg tablets over the counter actoplus met remeron from usa alli diet pill facebook vigra airport code the evolution of a viagra salesman quotes zantac mg canada adalat components buy retin a 0 1 gel zyvox 600 mg generic levitra paypal albuterol inhaler side effects adults where to buy grifulvin with visa bactroban fast usa zyvox sales pharmaceutical prescription flomax on line in the canada overnight pharmacy diclofenac gel cialis by mail canada 350 mg price generic soma pharmacy order levaquin cheap where can i get some alli independent pharmacies america actoplus met dosage buy differin have no prescription cheap alli online buy zocor without a subscription luvox buy online canada what antibiotics are given for chlamydia diprolene canada purchase depakote on line in australia mail order dipyridamole online inderal generic name propranolol effects west yellowstone montana pharmacies should you order viagra online in canada purchase tretinoin online no prescription buy nitrofurantoin online with out prescription clomid without ovidrel what are diclofenac pills for buy viagra uk tesco what is azithromycin 500mg for prescription nausea medicine for pregnancy men sex pills over the counter purchase cozaar lowest price can i order azithromycin online viagra next day usa levitra super active dose schedule buy singulair without prescription levitra pills buy online buy propranolol with paypal medicine back pain dogs where to buy furosemide with echeck buy zestoretic online canada no prescription suhagra canadian medications without prescription how to purchase levaquin cheap coversyl 4mg where to buy metronidazole for fish clozaril drugstore buy prescription drugs online buy generic viagra professional buy tetracycline lowest overnight kamagra delivery uk alli simpson quotes lincocin buy online us best place to buy zyvox in canada order lasix 12.5 mg assert cloridrato de sertralina bula buy synthroid online no rx side effects of ciprofloxacin hydrochloride propranolol on line in the mexico signs and symptoms of asthma in infants viagra no prescription online tadalafil 20mg uk price indocin prescription best place to buy trial erection packs 1 online information on celexa medication carafate generic usa where to buy silagra online without rx canadian pharmacy brand levitra differin cheap mexico pharmacy light blue pill with watson 540 on it sample free herbal viagra motilium in usa aciphex generic drug buying xanax online no prescription do cialis soft tabs work buy clomid nolvadex pct puerto rico pharmacy school tuition luvox cheap canada pharmacy flagyl and pregnancy cdc order provera 5mg decadron discount rx card florida tenormin medication overnight delivery motilium purchase propecia medication works generic viagra shipping approved pharmacy 30 x 24 medicine cabinet wellbutrin to buy in the canada without a prescription can you buy ditropan over the counter where could i buy propecia without prescription elocon cream more drug_side_effects viagra super active on line in the india misoprostol for pph ppt best price buy propecia buy generic pravachol online no prescription revista caras angola where to buy lipitor cheap pomegranate juice recipe video buy levlen mg top pharmaceutical companies india list phenergan cost comparison discount cheap online meds without a prescription order elocon cream 0.1 5g protonix over the counter tricor medication overnight delivery glucotrol where can i buy differin gel canada female viagra without rx order nolvadex without rx how long does it take to get off lexapro gasex with no perscription discount elavil mg buy eventide pitchfactor flagyl class of drugs can you buy viagra over the counter in ireland where to buy exelon online usa prednisone low cost pharmacy view topic accutane 5 mg day femara prescription card paxil reviews bipolar disorder erythromycin gel reviews yasmin over counter adalat through compromise settle when will diovan be available in generic form order proscar uk lamisil comprimidos efectos secundarios amoxil dosage for cats buy hyzaar 100 25mg robaxin dosage for horses abilify drug in usa pharmacy tadacip buy uk viagra cialis levitra sample packs buy xenical without prescription valaciclovir prescription online pharmacy reviews ritalin buy lamictal online from canada order acivir online no prescription with a visa canadian health card ontario canadian drug policy cost economic discount lipitor 20 pfizer where can i get some blopress cialis sublingual non perscription countries where can i buy prednisone online cheapest paroxetine paxil clarithromycinum drugstore buy eurax online canada no prescription generic propranolol overnight prescription order metoclopramide ventolin canada fake non prescription viagra for men suhagra uk sale cipro purchase buy kamagra no prescription generic depakote er 500mg purchase prednisone no prescription zyvox 400 mg where can i buy sildenafil in the uk viagra pour homme contre indication generic cialis tadalafil what is clomiphene 50mg used for in men order estrace on line canada i want to pay some amitriptyline best place to buy tadalafil seroquel xr quetiapine 300 mg levitra 30mg ordering celexa usa order doxazosin drugstore bph does safeway sell home drug tests purchase pyridium drug elisor coupon propecia side effects treatment female cialis from mexico order vpxl online no prescription with a mastercard endep buy no prescription metformin 500 mg price walmart cymbalta drug in canada pharmacy buy ambien cr no prescription canadian equivalent food drug administration boaz discount drugs medrol buy online us buying penamox tadacip online purchase propranolol generic sumycin online pharmacy shipped to canada cialis brand online which is better levitra viagra or cialis where can i buy female viagra tablets buy cafergot suppositories online compazine from canadian pharmacy zyprexa on line in the usa generic serpina usa big mountain drugs canadian pharmacy can i order propranolol online purchase premarin in us pharmacies for sale in louisiana acticin order online no prescription purchase clozaril in uk where citalopram antidepressant cheap supradol isoptin online canada can you buy fucidin over the counter where to buy levitra plus how to purchase atarax cheap rx buy actoplus met order antabuse without prescription brand cialis noprescrition needed uk online pharmacy diovan tablets buy mobic tablets what for soma store order levitra overnight delivery elavil overnight shipping where do i nitroglycerin in canada no prescription effexor low cost canadian discount actos purchase prednisolone online cialis jelly to buy cardizem combination buy viagra super active generic muscle relaxant drugs buy aceon prescription lozol where can i buy tinidazole buy usa generic price cheap advair diskus finasteride sin prescription buy lotrisone tablets usa mircette without prescription order generic viagra from india finpecia generic propecia 1 mg 10 tablets buspar without a prescription from india trial erection packs 3 usa no prescription buy atarax cheap allergy sedation rythmol on line in the usa levitra professional canada no prescription order zoloft online no prescription with a visa retin a free shipping buy tramadol online doxycycline good spots canada pharmacies online that sell trial erection packs 3 acticin without buy online order paroxetine from australia without prescription viagra naturale farmacia senza ricetta suhagra fast uk xenical orlistat 120 mg fiyatl dilantin in usa erection packs 20 drugs online pharmacy discount buy vermox online where to buy actos online generic cialis tablets 20mg price toprol mg usa doryx side effects joint pain amoxil delivered to your home wellbutrin sr generic pictures protonix canada order buy tadalis mg zyvox sales bentyl usa pharmacy novo rabeprazole ec 10 mg diamox with no rx glenpool walmart pharmacy phone number discount metoclopramide best non prescription weight loss drugs unipharm wholesale drugs limited private cheap antibiotics online review prescription order cheap acticin tamoxifen on line in the canada amantadine no prescription cod strattera without a rx where can i buy alli weight loss tablets from bentyl buy usa sex enhancer pills for men india is there a generic lipitor now cialis sublingual discounted generic wellbutrin sr uk which stores carry bonine for kids tenormin noprescrition needed canada online pharmacy buy adalat cc nifedipine buy staticin album flat bringing back prescription drugs mexico diflucan online canada buying viagra from canada no prescription sirop zentel pret buy generic elavil online no prescription alli diet coupon printable pharmacy technician online courses in bc habeeb alli canadian council of imams where can i get diclofenac from alphagan birth control online us can i buy diclofenac actos tablets used buy unisom tablets usa actoplus met generic substitute 500mg is there a shortage of benicar prednisone visa order calan from usa without prescription tetracycline 500mg antibiotics no script celexa mg buy actos online without prescription meclizine online pharmacy shipped to canada betnovate mg usa generic cialis uk cheap buy revatio with canada zestril tablets online buy minocin capsule aldactone for pcos reviews proscar hair loss 5 mg medco mail order pharmacy fax number my alli diet supplement cheapest liposafe paypal cafergot online in uk hindi movie adalat watch online tenormin over the counter india lipothin canadian medications without prescription