In March 2013, First book dedicatedly on OAF was published. This book “Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook” is authored by Andy Penver, who is having around 18 years of experience around Oracle E-Business Suite applications. In this post I will share my review for this book for you.
Out of the 8 chapters of the book, five of them are dedicated to Oracle Application Framework’s personalization and customization of OAF pages within E-Business Suite Applications. This book is suitable for both beginners who have little knowledge on OAF as well as for experience developers who wants to know additional advanced OAF features and concept. It provides step to step guide for performing various personalization and customization of E-Business Suite Applications. Here is the list of contents that are covered as part of this book
- Chapter 1, Personalizing OA Framework Pages
Provides detailed and step to step information for performing various personalizations in E-Business Suite Applications. It explains different types of personalizations, its levels, and various profile options that needs to be set for performing personalization. Also, it explains details about responsibilities that are used for administering and migrating personalizations.
- Chapter 2, Getting Started with OA Framework Pages
Gives an overview of the architecture and methodology of OA Framework and various components of OA Framework. It also provides detailed information on setting up the development environment for development of OAF pages. Also, it gives a step to step guide for creating a query page in OAF.
- Chapter 3, Creating a Master Detail Page in OA Framework
Explains the concept of Master-Details pages and provides a good understanding on the development of Master Detail page using OA Framework. It explains the deployment process for OAF pages and their registration within E-Business Suite Applications.
- Chapter 4, Adding a Creation Page and LOV Region in OA Framework
Focuses on steps involved in creation of a page that allows to insert and update records to the database. It shows how we can write programmatic logic in various classes such as Entity Object Class, Application Module Class etc. It also has a section that explains how we can debug OA pages using Jdeveloper debugger.
- Chapter 5, Advanced OA Framework
Is about the advanced features of OA Framework. It explains about programmatic navigation between OAF pages, passing parameters between pages, adding validations to entity object class and calling PLSQL from OAF pages. Another important concept that is explained as part of this chapter is Partial Page Rendering.
- Chapter 6, BI Publisher
This chapter provides an overview on how we can integrate BI Publisher with E-Business Suite Applications. It provides recipes to create report templates, generating XML data and support for different output formats.
- Chapter 7, Desktop Integration
This chapter explains the details about integration of desktop applications such as Microsoft Word, Excel etc. with Oracle Applications using WebADI.
- Chapter 8, Utilities
It explains about some of the utilities provided by oracle for migrating objects between environments. Also, it explains detailed step to step guide on who we can create a custom schema within oracle applications.
Overall, “Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook” by Andy Penver is a great book and a must buy for all the E-Business Suite Developers who want to learn the basics as well as advanced features on Oracle Application Framework. You can buy the book from here.