Master Detail Screen In OA Framework Part-I

I would like to touch base upon an important topic "How to build Master Detail Screens in OA Framework?"
Hence I will cover this topic in a series of articles. In this first part, lets do some comparison vis-a-vis D2K [Oracle Forms].

One of the most common data entry screens used in business is of type MASTER-DETAIL.
We know that is simple to build a master detail screen in D2K Forms or in Apex. It isn't too difficult in OA Framework either.

Lets begin with a high level comparison between Forms(D2k) and OA Framework, for a master detail screen.

Create the base table/view
In case of D2k, the blocks are based either on tables or on Database Views.
In case of OA Framework, both the master and the detail regions will be based on View Objects.
Both these View Objects will be based on Entity Objects, if the data in both Master & Detail regions can be modified.

Oracle Forms D2K	OA Framework
Create a database view(or table) for master block and a detail block.	Create an entity object and view object for both master and detail region

Create a relation between the two blocks/regions
In Oracle Forms, we create a relationship between the "two blocks". This relation gets created by means of a join.
However in case of OA Framework, the relation does not exist between two regions.
Instead the relationship exists between the two Entity Objects[Association] and also the two View Objects[via View Link]

Oracle Forms D2K	OA Framework
Create relation between the Master Block and the Detail Block	A) Create an Entity association between both entity objects. B) Next create a view link between both the view objects (This view link can be based upon the Entity Association) C) Attach these view objects to Application Modules

Note: In this case, by default 3 View Object instances will be created against the Application Module.
1. Master VO Instance
2. Detail VO Instance
3. "Detail VO Instance" attached to "Master VO Instance"
The records in third View Object instance are always kept in sync with first View Object. This synchronization is managed automatically by OA Framework engine.
You will find the details in Audio-Video presentation on this topic, in future parts of this article.

Commit Data

Oracle Forms D2K	OA Framework
You do not need to add a button to commit data. "File Save" or Control-S will save changes to database.	You need to add a Submit Form button that submits the form, and then issues a commit call via AM.

How does OA Framework manage to keep child records in sync with Master record?
Detail View Object keeps listening to the changes in master record navigation.
At any given point in time, there can be only one single record in Master ViewObject, that will be flagged as CURRENT RECORD.
Whenever the current record changes in Master Region, the Child/Detail view object gets Re-Queried.
This is made possible by means of Observer Pattern, please see link for details

In D2K, we can use Key-UP or Key-DOWN to change the current Record in block. Is something similar possible in OA Framework?
I am afraid not [at least for now]. To the master region, you will be adding a "Single Selection Item".
"Single Selection Item" is nothing but a Radio Button against each record in Master Region.

Now to recap:-
1. Master detail screens can be built using Advanced Table of OA Framework.
2. You will create a radio button field on master region.
3. The record for which you select the radio button in Master Region, should be flagged as the Current Record.

In the next article, we will see how to create
    a. Entity Objects for both master and detail tables
    b. View Objects for the above Entity Objects
    c. Create associations between entity objects of Master and Detail
    d. Create link between Master & Detail view Objects

Set as favorite

Bookmark

Email This

Comments (20)

Subscribe to this comment's feed

...
written by thirumalai , August 22, 2007

hellow passi sir,
I am new in oracle apps now am joined in company like yantro s/w ltd before one month so how to develope in my apps knowledge from basic.

report abuse

vote down

vote up

Votes: +1

...
written by Aniket Mahajan , August 25, 2007

Dear Anil

I liked your site. I would like to get a clearer picture of how to initiate an API for Order import. Should it happen from a form/report/PLSQL? Suppose I have the data which has to be entered in an Excel file, then how should I go about?

Rgds,
Aniket

report abuse

vote down

vote up

Votes: +0

...
written by pb , August 29, 2007

Hi Anil,

Is there any way to add frames in OAFramework? What I want to achieve is display some data in a region, which would cover just some portion of screen, and if the data is more, there would be scroll bars to scroll down , to see content of that frame region.

Thanks in advance

Puja

report abuse

vote down

vote up

Votes: +0

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

Hi Puja

Not that I am aware of
You cant implement vertical scrollbars in OAF, as yet.

Thanks
Anil

report abuse

vote down

vote up

Votes: +0

...
written by kishorem , September 01, 2007

Hi Anil,
I want to know is there any API to do adjustments to existing offer lines in Trade Management.As of now i am using ozf_offer_pub API to upadate existing offers. But not able to end date the existing offer less than the current date. Please advice.

Thanks,
Kishore M.

report abuse

vote down

vote up

Votes: +0

...
written by Ramakrishna Kandula , September 09, 2007

Hi All,

I need some help on cash management - Bank Statement Inbound Interface

Scenario:

Payables outbound interface is populating bank statement related information into a custom table from there we are picking up the data and loading into open interface tables of cash management.

The data is getting inserted into open interface tables but when we run the bank statement import program the data is not getting loaded into base tables.

CE_STATEMENT_HEADERS_ALL and CE_STATEMENT_LINES_ALL.

The statement number is still being show an "Negotiable" when i navigate to cash management super user ressponsibility and check in "Payments" function.

I need some information like:
> What is the mandatory data that is required to be passed to Bank Statement import program.
currently i am passing P_option,bank_branch_name and bank_branch_id

Please help regarding this...

report abuse

vote down

vote up

Votes: +0

...
written by Pravin , September 10, 2007

Hi,
I find ur site very helpful...Thanks a lot.

Sir request you plz if we can get the next article on Master-detail Screen(detail article).

Thanks

report abuse

vote down

vote up

Votes: +0

...
written by Pravin , September 11, 2007

Hi Anil,
Thanks for all your article.But i have one request....can u plz show one demo (say downloading one xml file and customizing it and uploading the same) using OA Framework.

Thanks

report abuse

vote down

vote up

Votes: +0

Master-Detail in OAF
written by prudhvi , October 10, 2007

Hi Anil,

Thanks for the information on Master Detail relation ships in OAF.
But can you please clarify me a bit more on this.

Here is my requirement.
lets say we have two tables ( EMP , DEPT ) and deptno is the common column in both the tables.

Requirement is :

I need to build a OAF page that displays all employees of the same department in a single row as differnt columns.

Example:

DEPT table

deptno dname
10 comp
20 civil
30 testing

EMP table

empno ename deptno
101 mike 10
102 john 10
103 ram 20
104 krish 20
105 bal 20
106 gopi 30

Desired Output

Deptno empno ename empno1 empname1 empno2 empname2
10 101 mike 102 john
20 103 ram 104 krish 105 bal
30 106 gopi

Can you please help me on this ?
Is this kind of output is possible with OAF ?
if so can you please explain how we can acheive .

Thanks
krishna

report abuse

vote down

vote up

Votes: +0

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

Hi Krishna

You can create a view object on a SQL that returns records from a FUNCTION

For example, see the steps below

CREATE OR REPLACE TYPE xx_emp_records IS OBJECT
(
emp_id INTEGER,
emp_name VARCHAR2(100),
emp_id_1 INTEGER,
emp_name_1 VARCHAR2(100)
);
/

CREATE OR REPLACE TYPE xx_emp_tables AS TABLE OF xx_emp_records;
/

CREATE OR REPLACE FUNCTION xx_get_emp(dept_cur SYS_REFCURSOR)
RETURN xx_emp_tables
PIPELINED IS
loop_variable_emp_id INTEGER := 1000;
loop_variable_emp_name VARCHAR2(100) := 'Anil';
loop_variable_emp_id_1 INTEGER := 1001;
loop_variable_emp_name_1 VARCHAR2(100) := 'Passi';
BEGIN
--LOOP for specific dept id
PIPE ROW(xx_emp_records(loop_variable_emp_id, loop_variable_emp_name,loop_variable_emp_id_1, loop_variable_emp_name_1));
--END LOOP ;
END xx_get_emp;
/

SELECT *
FROM TABLE (xx_get_emp(CURSOR (SELECT d.deptno, d.dname
FROM scott.dept d)))
/

Now your view object will be based on the above select statement.

You will haev to agree upfront for the number of records that you wish to display horizontally.

If you want to have unlimited[in theory] number of columns, then I suggest you create a RawText item, and programatically build HTML to create the desired columns.

Thanks,
Anil Passi

report abuse

vote down

vote up

Votes: +0

Thanks a lot
written by prudhvi , October 15, 2007

Thanks a lot anil.

report abuse

vote down

vote up

Votes: +0

Master-Detail OAFramework
written by Natraj , October 18, 2007

Hi Anil,
It would be nice,if you can post an Audio-Video version of Master-Detail screen.
Thanks,
Natarajan

report abuse

vote down

vote up

Votes: +0

...
written by tk , December 07, 2007

Hey, Anil,

I want to thank you for your session. It is very helpful. I have an opposite request from prudhvi's. Here is my assignment.

I have a master table like transaction and two detail tables, payment_method and transaction_fees. The record is as the following.

Transaction table
id, transaction key
1, 111
2, 112
3, 113

payment_method
transaction_fk_key, method_name
1, visa
2, mastercard
3, cashcheck

transaction_fee
transaction_fk_key, seller_fee, buyer_fee, shipping_fee
1, Y, N, Y
2, N, Y, Y
3, N, N, N

I need to display the master/detail with radio button to display the detail record by chosen master record as the following.

master...
1 visa -- picked
2 master
3 cashcheck

detail ...
transaction id:1
buyer_fee Y/N (Message Choice)
seller_fee Y/N (Message Choice)
shipping_fee Y/N (Message Choice)

I am new to OA framework. I am not for sure if the detail record could be converting to an arry from a row record. Can you give me some direction? I shall very appreciate your helps.

-Tawen

report abuse

vote down

vote up

Votes: +0

Master Detail on the Same PG
written by ksivasan123 , December 15, 2007

Hi Anil,

Excellent Work.

Can you please tell us the Master Detail OA framework with Insert/Update/Delete using PPR.

Regards
Kumar

report abuse

vote down

vote up

Votes: +0

master/detail report
written by james , February 22, 2008

anil
any plans on posting an Audio-Video version of Master-Detail screen creation steps. your website and input is appreciated.
james

report abuse

vote down

vote up

Votes: +1

advance table in advance table
written by Munish , July 26, 2008

Hello all,
I am new to Oracle application as well as OA framework.I have an assignment.
I want to show the data like

Header (advance table)
-------data
-------Detail region
----------lines (advance table)
------------data
------------Detail Region
----------------Deliverables (advance table)

i am able to show the data up to lines (advance table)
but when i click on the show link of lines (advance table), i got this error
java.lang.ClassCastException
at oracle.apps.fnd.framework.webui.event.OAAdvancedTableEventHandler.handleDisclosureEvent(OAAdvancedTableEventHandler.java:773)
at oracle.apps.fnd.framework.webui.event.OAAdvancedTableEventHandler.handleEvent(OAAdvancedTableEventHandler.java:167)

can any one suggest me why i am getting this exception or

the hierarchy i want to get is it really possible or not....

report abuse

vote down

vote up

Votes: +0

Unable to update the Detail Record attribute in Master-Detail
written by Krishna Nand , September 19, 2008

Hi,
Anil,
I am new for jdeveloper .i am using jdev 9.0.3.
I am implementing the Master-Detail form in jdev
by using viewlink.

My viewlink has cardinality 1 to *
and i have selected generate accessors for both source and destination
with both options.
In View Object
In Entity Object

Now about VO

My Master VO and Detail VO are based on EOs.

For UI:

I have two region in my Page Region A and Region B of Header Type.
Region B is Child of A
Following properties I set for Region A.
Child view instance: MasterVO Instance
Child view Attribute: Primary Key For master VO
View Link Instance: MyViewLink Instance
And For region B
Child view instance: Detail VO Instance populated by View Link
Child view Attribute: Reference Key(Common in both Master and Detail VO)
View Link Instance: MyViewLink Instance
Page coming like:

Master Record
Detail Record.
Detail Record.
Master Record
Detail Record
Detail Record.

Problem: When i try to update detail record attribute,It's not being update in
Database.

Please Help Me to solve this problem.

Thanks in Advance,

Krish

report abuse

vote down

vote up

Votes: +0

...
written by Anil- , September 19, 2008

Hello Krish

Please raise on our forum
http://apps2fusion.com/forums

http://apps2fusion.com/forums

report abuse

vote down

vote up

Votes: +0

Master-Detail Part II
written by Akila , May 29, 2009

Hi Anil,
Could you please provide the link for Master-Detail screen in OAF Part II.

I am new to OAF and I am trying to create a Master-Detail Page.
I followed the steps you provided in Part I and I could see the data from Master Region. But once I include the detail region, I do not see any data even in the Master Region.
I am not sure what I am missing.

It would be a great help if you could post the second portion on creating the Master-Detail OAF page.

Your articles are simply superb and thanks a lot for all your efforts.

Regards,
Akila

report abuse

vote down

vote up

Votes: +1

detail disclosure
written by Sanju , September 01, 2009

Hi,

Has someone implemented Advanced Table in Advanced Table in OAF. I need detail disclosure implemented with view links since my child table is from a different view object. Please send some reference code if you have.

Basically i tried using the dev guide and facing an issue. My page's look anf eel is as expected but when i click on Show on any of the row in the master table, the detail query does not fire and it says " No serach conducted". I made some changes to the view link etc etc..and now i am getting an error OAAdvancedTableHelper.updateInnerTableProperties. But the system does not tell me which inner table properties are missing.

Can you please help. I have posted the same request in another thread as well - not sure of how this website works but have heard tht its very helpful.. Kindly assist.

Thank you,
Sanjana

report abuse

vote down

vote up

Votes: +0

Write comment

Name

Title

Comment