OAF Miscellaneous

How to embed custom HTML code in OAF Page

October 28, 2012 by techhoneyadmin

It’s always that all the text on an OA Framework page is in black color. Ever thought of having a text in other color e.g. a note just after a table in a smaller font and in red color?

Here we will have a look at how to embed a custom HTML code in OA framework page and have a different color to that HTML text so that the text looks different from the rest of the text on the OA Framework page.
In order to do this, we need to use the OARawTextBean as it’s the only OAF item bean which supports the use of HTML tags.

Before discussing further I assume that you have an OA framework page e.g. xxTrialPG and also a controller to that page like xxTrailController.
Also I assume that you have created an OARawTextBean under the pagelayout region and the id of the OARawTextBean is xxTrialRawTextBean.

note Please note that all the lines that come in italics are the java code lines, this is done for easy segregating code from text in the post.

Again, let’s take this in steps for easy understanding and remembrance.

Step1: – Import the OARawTextBean in the controller so we will be able to create handles for it. Import the OARawTextBean bean as shown below.

import oracle.apps.fnd.framework.webui.beans.OARawTextBean;

Step2: – In the processrequest method create a handle for the OARawTextBean and create a String to write the HTML code in it.

OARawTextBean trialRawTextBean = (OARawTextBean)webBean.findChildRecursive(“xxTrialRawTextBean “);

code to embed custom HTML code in OA Framework Page

Step 3: – Set the String variable as the text to the OARawTextBean as shown below and run the page.

trialRawTextBean.setText(theHTMLCode);

Step 4: – You should be able to see the Text that you have written as shown below in your OAF Page.

How to embed custom HTML code in OA Framework Page

Creating XML Publisher Report in OAF

October 28, 2012 by techhoneyadmin

I know that this post is out of the niche of the blog but then the requirements of most of the implementations require new reports to be generated using XML Publisher and that’s the only reason why I have written this post. Also, using the hyperlink at the end of the post you can download my free PDF book on XML Publisher.

Oracle XML Publisher has gained a lot of popularity among developers and also among the businesses as its very easy to create a report using XML Publisher and even more easy to generate reports in various formats like PDF, EXCEL, RTF etc.

Oracle created XML Publisher is as a template based tool for publishing reports and much more along with Oracle E-business Suite. XML Publisher is powerful enough to populate the data fetched by a PL SQL package into a custom, yes custom, template and then generate the report in any of the desired form such as PDF, HTML, RTF, EXCEL (HTML) and even PLAIN TEXT for transmission using EFT and EDI.

Download Free Guide to XML Publisher. Click Here!!!

How to Install JDeveloper and Test it?

October 28, 2012 by techhoneyadmin

Here we will take a quick look on how to install JDeveloper and also how to test the installation.
First of all just download the correct version or patch of jdeveloper from metalink.
I assume that you have saved and extracted the jdeveloper in D:meta-patch folder.
1. Go to desktop
2. Right click on my computer
3. Click on Properties

4. Select Environment Variables

Install JDveleoper

5. Click New
6. Add a New Environment variable as:
a. Variable Name: JDEV_USER_HOME
b. Variable Value: D:meta-patchjdevhomejdev

7. Get the dbc file for the oracle apps instance to which you want to connect the jdeveloper. If you are not sure from where to get the DBC file then just ask the DBA to mail you.

8. Once you have the DBC file, paste that file in D:meta-patchJdevhomejdevdbc_files_secure folder.
9. Navigate to D:meta-patchJdevbinjdevbin and double click on the jdev.exe file. This will run JDeveloper on your desktop.

10. Once the Jdeveloper is run, on the left panel just right click on the database option and select New Connection.
11. In the Driver write “thin” without double quotes. For Host Name, JDBC Port and SID just open your DBC file in any text editor and there you will easily get these details. Just copy and paste those details in the corresponding places.
12. Click next and then click on the Test Connection Button, You will see a message as Success!
13. Right click on the workspace to create a new workspace and open Tutorial.jpr file.
14. Double click on the tutorial.jpr file and then enter the runtime connection details in the newly opened window.
15. Point to your DBC file (using Browse), enter a User Name and Password. Make sure that the user name that you are entering has access to the responsibility mentioned in the responsibility Key Field.

16. Right click on Tutorial.jpr select Make Tutorial.jpr
17. Again right click on Tutorial.jpr select rebuild Tutorial.jpr
18. Run Hello world page.
Hope you find this post useful.

Thank you for reading

How to execute a VO on an OA Framework page load

October 28, 2012 by techhoneyadmin

Before telling you how to execute a VO on page load, I assume that you have your VO created and also have attached the VO to the correct AM (Application Module).

Now, let’s assume that the name of your VO is xxTrialVO and also the name of the AM is xxTrialAM.

Let’s take this stepwise for a better understanding.

Step 1 import the AMImpl into your controller attached to the OA Framework page.
To do this just write the following code.
import oracle.apps…..server.XXTrialAMImpl;
Note: the import path will be different for you and will depend on the folder structure that you have defined.

Step 2 import the VOImpl into your controller attached to the OA Framework page.

import oracle.apps…..server.XXTrialVOImpl;
Note: the import path will be different for you and will depend on the folder structure that you have defined.

Steps 3 before the starting of processRequest method create an instance of the xxTrialAMImpl as shown below.

public xxTrialAMImpl am;

Step 4 in the processRequest method you need to instantiate the application module.

am = (xxTrialAMImpl)pageContext.getApplicationModule(webBean);

Step 5 Now we need to create an instance of the xxTrialVOImpl and then execute it.
XXTrialVOImpl TrialVO = (XXTrialVOImpl)am.getXXTrialVO1();
TrialVO.executeQuery();

Thanks for reading.

How to execute a VO on click of a button on an OAF page

October 28, 2012 by techhoneyadmin

Here we will discuss the execution of a VO on click of a submit button.

Now, before starting the discussion I assume that you have created a VO and have the same attached to AM. Also, I assume that you have imported the VOImpl and AMImpl to the controller attached to the page.
One more assumption I would like to make is that the VO name is xxTrialVo, AM name is xxTrialAm and the id of the submit button is xxSubmitButton.

After these assumptions, we are ready to learn how to execute a VO on click of a submit button.

First of all you need to check the click of the submit button. As submit button will post an HTTP request, hence you need to handle the click of the submit button in processFormRequest method. Just see the code below for reference.

if(pageContext.getParameter(“xxSubmitButton”)!=null)
{
pageContext.putSessionValue(“Click”,”Yes”);
pageContext.setForewardURLtoCurrentPage(//pass the required parameters);
}

Now the code above shows that you have caught the event of submit button click.
But our purpose was to execute the VO after submit button click, as we know that once the submit button is clicked the control travels from processFormRequst to processRequest method. Hence, now we will take the advantage of sessionValue that we have put in the code to check whether the control is coming back after submit button click or not. If it is then we will execute the VO.

In order to do this, in the processRequest method, refer to the code below.
if(“Yes”.equals(pageContext.getSessionValue(“Click”))
{
XXTrialVOImpl TrialVO = (XXTrialVOImpl)am.get XXTrialVO1();
TrialVO.executeQuery()
}

Hope you find this informative.
Thanks for reading