Implement 3-level master detail hierarchy using table region in OA framework.


Implement 3-level master detail hierarchy using table region in OA framework.

After depth searching on various oracle forums, I came to know that multi-level hierarchy in advance table is not achievable by easy means. There could be at the most one detail region inside an advance table.  If the business requirement is to display records in master->detail->detail format then advance table won’t be effective. For e.g. If the requirement is to show item transaction details year wise and when user clicks on show-hide region against any record will navigate to the month wise details and when user clicks on show-hide region against any record will navigate to the day wise details such hierarchy is possible, The OA framework provides the table region to achieve the same functionality.

Procedure:
Create view object for corresponding master – detail – detail regions.
Define view link for 1st level of master-detail hierarchy.


Define view link for 2nd level of master-detail hierarchy.

Add transient attribute of type string to each master View object so as to display corresponding detail region and default it to N. Make this transient attribute as always updatable.  While developing I have attached one transient attribute “showFlag” to Master View object xxQcItemReceiptXsactionsYrlyVO. And “showFlag1” to master view object xxQcItemReceiptXsactionsMnthlyVO who is child of xxQcItemReceiptXsactionsYrlyVO.


Attaching view objects to AM. Select the appropriate view object and shuttle it to right side.
First shuttle the master VO then shuttle detail VO to right side then click on apply.


Create table region by selecting page region right click -> new ->region using wizard. 


After creating table select newly created table region right click -> new -> detail.

It will create detail region table.

Select detail region and attach new table region inside.





Set the properties for master – detail region. Specify view link instance name for master VO and specify detail view attribute name to show-hide detail region.


Specify view link instance for detail region and detail view attribute to display detail region inside it.


Specify view link instance for inner most detail region. 

Table region with 3 level of mater detail hierarchy.

Comments

  1. Unknown27 October 2013 at 04:45

    Its not working for me please assist in case you knows the solution for the below problem :

    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition ThirdLevelVO of type Attribute not found in FirstLevelVO1

    --FirstVO Query
    select location_id,location_code,description from hr_locations_all

    --SecondVO Query
    select location_id, organization_id, name, type
    from hr_all_organization_units

    --ThirdVO Query
    select paaf.location_id,
    paaf.organization_id,
    papf.person_id,
    paaf.assignment_id,
    papf.full_name
    from per_all_people_f papf, per_all_assignments_f paaf
    where papf.person_id = paaf.person_id
    and trunc(sysdate) between paaf.effective_start_date and
    paaf.effective_end_date
    and trunc(sysdate) between papf.effective_start_date and
    papf.effective_end_date

    ReplyDelete
    Replies
    1. Unknown12 July 2016 at 22:59

      I am also having the same problem. Did u get a solution?-could you please share?
      Thanks

      Delete
    2. Unknown15 November 2016 at 09:25

      Please let me know what is the work around in this issue. Even I am facing the same issue as mentioned by Sanjil.

      Thanks Avishek

      Delete
  2. Test30 October 2013 at 03:35

    This comment has been removed by the author.

    ReplyDelete
  3. Test30 October 2013 at 03:38

    I would like to achieve the same, my developed Page is running , but Regions are not getting rendered correctly. First details table is getting rendered within show-hide region of the master table.
    Here(https://www.dropbox.com/sh/yaok8l8whfvlh0d/Z4fD0J4j5s) I am attaching the project folder.

    Regards
    Apurba K Saha

    ReplyDelete
  4. Unknown6 October 2014 at 00:55

    This comment has been removed by the author.

    ReplyDelete
  5. Unknown17 December 2016 at 04:23

    This comment has been removed by the author.

    ReplyDelete
  6. Unknown17 December 2016 at 04:24

    I would like to achieve the same, my developed Page is running , but Regions are not getting rendered correctly. First details table is getting rendered within show-hide region of the master table.

    Please help me sir.

    ReplyDelete
  7. ERP7 March 2017 at 01:46

    yes as i have the same target to develop page better than present. now i can handle the same issue with the help of this article thank you for sharing

    from
    Oracle Fusion HCM Online Training

    ReplyDelete

Post a Comment

Popular posts from this blog

Search on Master-detail table in OAF

Search on Master-detail table in OAF Hello friends, Oracle application framework provides me another opportunity to work on and to get more acquainted with. So here I am eager to share another short article on OAF.  Just finished a project on OAF and came across various fact and findings about the framework. You guys may have come across master – detail relationship in OAF and ‘how-to’ behind that as well.  I have recently read articles on how to insert a row into child table. Well this article is quite a different one. While developing an application, there might be a requirement wherein we need to work on master detail relationship.  In my case, the requirement was to develop the search page having result table including master and detail table records.  The user may enter any search criteria that may fall under master table and/or detail table. Depending upon the search performed by the user, the master and detail table records must be populated. For...
Read more

Shuttle Control in OA Framework

Image
Shuttle Control in OA Framework While working on various business scenarios, we may come across multiple situations wherein we need to select specific values from the list and require moving to another list which will be considered as final list.  OA framework provides shuttle control to fulfill the same. For e.g.  In Jdeveloper, while attaching view object to the application module we need to select correct view object from view object definition list in left side panel and move it to right side panel/list so as to include view object definition into the  application module. Well, to achieve such operations Oracle application framework provides such option by means of shuttle control.  Shuttle Control allows user to move values from one list region to other. Design:  Select page region and right click -> new region set region style property of this region to shuttle.  After setting region style you will get shuttle region with default leading l...
Read more