Oracle Forms: Saving only Selected Row in database

One of my freind was having a small requirement:
1. Select one row at a time(only one row in Database block)
2. Only selected row should be saved in database, even other non-selected rows has been changed by the user.

Read More.

Oracle Style Master Detail Page without using As and VL

To implement Master detail Page, we need to implement following functionalities:
1. Query lines whenever you are querying Header information
2. While creating New record Foreign key values should be passed from header to lines
3. Whenever we are going to delete header record, lines should also be deleted.
4. Like Oracle Style Forms it used to show some lines in detail block, same thing I've also implemented, whenever you want to create new record it will show you 5 blank rows.

Read More

SOA Registry-Repository

There was a strong need to control and govern the service information artifacts within the SOA Deployment. The artifacts stored and managed were also needed to be consistent.A registry-repository is like your local library.

Read More..

Customizing Query Bean to Extend/Override the functionality of GO button

When we develop Search Page using Query bean it renders a Go button, and OAF handles it's functionality. We need not to write any code for it(when we clicks on GO button it queries VO). But still there may be some situations where we want to write our own code that should be executed on the click of "Go" button like we want modify where clause/add some order by clause or some other operation like changing the property of some items(Based on PPR).

Read More..

Advance Search Page without using Query Bean

Oracle has provided Query bean to implement search pages, but we are having little control over that. If we want to develop custom search pages that we can not develop using Query bean then we have to impelement it without using Query bean.

Read More.

How to Open webADI Document from Excel 2007

There was a VB error when I tried to open the webADI document using Excel 2007.I am pretty sure that
the issue is with macro,but some how I couldn't find the navigation to enable the macro.I had put together an simple screencast to show you how to successfully download the document to Excel 2007.

Read More..

Adding LOV to OAF Page using Personalization

If we want to add an LOV Item to existing page, we can do it using Personalization but to achieve this first we need to develop AM,VO and LOV Region using Jdeveloper and then we can attach this LOV region to item created using Personalization as External LOV.

Read More.

Shared Region and Adding Region to Page using Personalization

Sometimes we need same information on several pages so instead of creating new region on every page we can create a common region and on respective page(where we want to use common information) we'll create one region and extend it to common region by setting region's extends property to common region's fully qualified path. This allows us to reuse the components and we can save development and maintenance cost.

Read More..

Adding the new region to the Application Home Page using Personalization in OAF

In this tutorial we will see how to add a region to the Home page using Personalization which displays the Username,UserId and Email address of the user logged in to the application in the Applications Home Page.

Read More..

How to format code in OA Framework

It was a time consuming task to format the code or style manually in any OAF project.Latest R12 Jdev(10.1.3) has the builtin code styler to format the java code.For previous versions of Jdev,you can use jalopy extension to style the code.Below are the steps and screenshots to use Jdeveloper code formatter.

Read More.

Partial Page Rendering

What is Partial Page Rendering?
PPR is a technology that is used for refreshing only a part of a page when you want a UI change instead of having to refresh the whole page. A source event can trigger events to cause changes in target items.

Read More..

Implementing Dependent LOV in OA Framework

Dependent LOV is a LOV where values of the lov are dependent on the value chosen from an item like poplist or value of an item like a styled text item. Here in this example depending on a poplist value we are going to generate values for the LOV.

Read More..

Multi Org Views are not working in R12

I had a requirement to migrate some of my custom development work from 11.5.10.2 to R12.None of my pages worked as it was using multi org views on the background.I found a way to overcome this issue and made my pages to work in Oracle R12.

Read More..

Using Switch Activity in a BPEL Process

There may be many scenarios where you will be need to execute a set of activities depending upon one value. At that point you make a decision of which set of activities do you want to execute for which value in your BPEL process. This can be achieved by using the Switch process Activity in your BPEL process.

Read More..

AR_RECEIPT_API_PUB.apply_open_receipt API

This is a test script given by oracle which I had used in my project before.

Read More..

Home Page with Tabs for OA Framework

Home Page with Tabs for OA Framework is required in some projects.I always get confused with the steps to be done and here I tried to document the same which will be useful for me as well as others in future.We will create a home page in this tutorial as described in the below screenshot.

Read More..

Using Human Task Actitvity in BPEL

Human Task is one of the process activity in a BPEL process. Human task as the name suggests is used where we need human intervention. So whereever there is a need for human to do some job we use the human task. Here in this example we will see a Order Approval process where a person needs to approve or reject a order.

Read More..

Configuring Application and Integration Server Connection for SOA Suite

Before doing any development the first thing you do after installing SOA suite and Jdeveloper is to create a Application Server connection and Integration Server connection.This article will guide you to create the Application Server connection and Integration Server connection.

Read More..

Learn SOA

Learning SOA may be a little difficult in the initial stages.Here is a list of articles to get started with SOA:

Read More..

Installing SOA Suite in Windows XP

Initially when I started to install SOA suite I had so many problems and the installation was not successful at all. Then there was one simple thing that I had to do which solved my problem. So in this article we will we will see the installation of SOA Suite.

Read More.

Directory Structure in Oracle Applications

There is a specific strcuture in which files are followed in Oracle application.Every directory has a particular strcuture.The R12 directory structure is a little different from the 11i.Not a major change but very few changes. So I thought of making a small article on the directory structure.

Read More..

Steps for VO Extension in OA Framework

VO Extension is a process of extending the existing VO to accomodate new business requirements.Classic example for VO extension is to add an database driven extra field to the page.

Read More..

How to set where clause programmatically in OAF?

This is a very common requirement for any one who is working in OA Framework. It is not always that we set the where clause in the query itself. We mostly will have to set the where clause programatically only. Here is how to set it programatically.

Read More..

Creating Connection Pool and DataSource in SOA

This article has a step by step procedure for creating the connection pool and Data source for SOA suite.

Read More..

Implementing Hide Show region style in OAF

This article will show you how to implement the hide show region style. You can have some details in a page which you dont want to see and only if there is a need you want to see it. So this can be achieved by changing the style of the region to Hide Show.

Read More..

Regions in OA Framework

Regions are containers for for different items in a page.In a page there can be any number of regions inside regions and many number of items inside the region.Every region is a java bean acting as a container for regions under it or items.

Read More..

Creating a Business Event

Business Event as the name suggests is an operation that occurs when something happens in the Oracle ERP of business significance. The event will contain data depending on what type of event. If it is something related to an employee it might contain information like Employee Id,Name ,salary etc.

Read More..

Capturing a Business Event in the BPEL Process

Many of our learners asked us to show how can we capture an Oracle Applications Business event in the BPEL process.

Read More..

FTP Adapter in BPEL Process

The FTP adapter is used for getting or putting any file into the server.In this we will see how to read a file from a directory in the server and write the same file into the server in a different location.

Read More..

Capturing an event in ESB

Capturing an event can be done in ESB as well as BPEL. We have already seen how to capture an event in BPEL.Now let us see in ESB. 1.Create a new ESB Project. Name it as EventDemo.
Whenever we create any ESB process we create a System and assign all the components for that particular project to the group.

Read More..

Few basic navigations in Oracle Apps

Few basic navigations that everyone will do working in Oracle Apps/OAF.I will be updating this article whenever I come across a new one.

Read More..

Calling a BPEL Process from ESB

In this article we will see how to call a BPEL process from ESB.Here in the BPEL process we read a file from one location. We call this process in ESB and then write the contents that we read from BPEL in another location using the ESB file adapter.
1.Create a new ESB Project. In components palette select ESB Services and click Custom Adapter.

Read More..