Blog entries

OA Framework Architecture

Sushant Sharma — Sun, 19 May 2013 11:46:44 +0100

View (Pages in OAF)

Metadata Service (MDS)

Controller in OAF

Model (BC4J)

http://sushantsharmaa.blogspot.in/2012/09/oa-framework-architecture.html

What is OA Framework ?

Sushant Sharma — Sun, 19 May 2013 11:35:54 +0100

What is Framework ?

Difference b/w API and Framework

OA Framework

http://sushantsharmaa.blogspot.in/2012/09/what-is-oa-framework.html

How to Create hgrid (custom application)

venkat — Thu, 07 Apr 2011 07:41:34 +0100

Hi All,

Any one can help me out to create hgrid(custom application).

step by step code. if any video its very good.

my requirement is if user select add group button it will redirect to add group page once user select apply button then add that group in hgrid

under group -location same as above under location-sub location like that

how to achive this requriement.

thanks

Indexes

Kasiraja — Wed, 23 Mar 2011 16:35:55 +0100

Indexes

There are 4 types of indexes in Oracle8-

a) Btree index

b) Btree index clusters

c) Hash cluster index

d) Bitmap index.

a) Btree index

This is the most commonly used index. It is used for primary key columns, foreign key columns and the columns which are frequently referred in WHERE clause. It can be unique or non-unique, single or composite (based on more than one columns). They are advantageous...

Oracle PL/SQL CODE OPTIMIZATION

Kasiraja — Wed, 16 Mar 2011 16:35:11 +0100

1. Introduction

Programs containing a large number of codes of line and complex structure may consume more time for processing leading to a downfall of performance.

In PL/SQL and modplsql code, computing time plays a vital role. The execution...

How to read the file from filesystem and display it on the OA Framework Page

Sudhakar Mani — Tue, 08 Mar 2011 07:31:11 +0100

Requirement was to build an OAF page which will display the files stored in the filesystem.OA Framework doesn't support this functionality natively.But core java comes in handy during these situations.

Challenges:

1) Dynamically read the files from a specific directory.
2) Create the link items dynamically and provide action type programatically
3) Filter the files by name
4) Open the pdf file using a custom function(OA Framework supports FileDownload from...

How to send email and save the pdf to the file system with BI Publisher

Sudhakar Mani — Tue, 08 Feb 2011 01:54:04 +0100

I got this requirement recently with one of my client to send an email as well as save the pdf on the file system for future audit purpose.The existing program was sending the email attachment with the bursting Control file,but now we have to include the option to save it to the file system after the email is sent.I went with the multiple delivery channel approach to get the functionality working..the code snippet for the bursting file is available below.

<xapi:requestset xmlns...

Java for OA Framework

potdar — Sun, 06 Feb 2011 08:41:43 +0100

I am learning JAVA for OA Framework. From the DOS command prompt I need to
compile the JAVA programs in the online video. I need the url to download the JAVA
compiler. After than how do I set the environmental variables so as to compile the JAVA program in notepad from the C: command prompt in DOS.

How to Update Start Date and End Date of an Oracle Project

Sudhakar Mani — Wed, 19 Jan 2011 04:06:35 +0100

Recently I had this requirement to update the project start date and end date on a oracle project.This requires lot of validations before update can be performed but the below API really simplified my work..Have a look at the below API sample Call

DECLARE

l_return_status VARCHAR2(1);
l_msg_count &...

How to test an Oracle Apps Web Service using SOAP UI

Aarthi — Thu, 09 Dec 2010 23:49:02 +0100

Soap UI tool is used for testing the web service. It can be downloaded from the below link:

http://www.soapui.org/

Below are the steps for testing the Web Service using Soap UI tool:

1. Pick up the WSDL path from Integrated SOA Gateway responsibility.

2.Select the Product Family as "Interface Type".

Incorporating Serial Number

In RTF template layout, for generating a serial number sequentially, you can follow the steps given below:

S No. Var

S No

Invoice Num

Invoice Type

OA Framework Book - R12.1.1

Sudhakar Mani — Sun, 28 Mar 2010 15:56:23 +0100

Full fledged book on OA Framework is released by Chola Press which covers Java Basics for OA Framework developers, Advanced Table Pages, Google Style Auto suggest LOV ,Standard Pages Extension and OA Framework Interview Questions.

You can buy this book and immediately download at

http://www.lulu.com/content/e-book/oa-framework-beginners-guide/8547038

http://www.scribd.com/doc/28535298/OA-Framework-Beginners-Guide-Chola-Press-Books

http://www.doc...

How to Call OAF Page from Workflow Email Notification

Aarthi — Fri, 12 Mar 2010 05:46:36 +0100

There was a requirement with one of my client to open an OAF page from workflow email notification. In R12 below error will occur if you try to open an OAF Page URL link directly.

You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to Proceed.

Note: When you call a standard page this error won't appear. This happens only when you try to open a custom page.

Below ...