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 1 st level of master-detail hierarchy. Define view link for 2 nd leve...