Apps To Fusion

 

When designing OA Framework Pages we commonly come across situation when we need to show data in the form of master detail. To do this we use the Show/Hide, Detail Disclosure Table-in-Table and Advance table-In-Advance Table Regions.

The most common issue faced with the master details implementation is the data inconsistency. The details region will show same child data for all master records. In this article i will be discussing about the mandatory steps to be performed to avoid this data inconsistency with Master-Details region.

To create a master details region we need
1) Master View Object.
2) Detail View Object.
3) View Link Between Master View Object and Detail View Object.

In most cases the view link between the master view object and detail view object created based on the attributes that form the unique keys of view objects. In this cases, the master details shows consistent data.

In some cases the view link might not be on the unique key columns. In this case the view link is not able to get the detail records properly and shows incorrect data.

In order to avoid this we will have to mark the attributes used to create the view link as Key Attribute.

For example,

If you want to create a master detail between supplier and supplier site, then your view object will be based on PO_VENDORS and PO_VENDOR_SITES_ALL. The viewlink will be based on PO_VENDORS.Vendor_Id and PO_VENDOR_SITES_ALL.vendor_Id. Yow will have to mark the VendorId attribute in both the view object as Key Attribute.