Oracle R12.2 | Personalization Improvements

New improvements have been introduced into OA Personalization Framework:

• An administrator can create a SQL-based read only view object through Personalizations and bind it to new items on a page. This feature lets administrators declaratively add new content from Oracle E-Business Suite tables to an existing page.

• More item types and layout region types are available to be created and added to a page through Personalizations. Additional layout types supported in this release include header, classic tables, advanced tables, and message component layout. Additional item types supported include submit button, reset button, and rich text editor. 

• You can undo personalizations. The undo features allows administrators to revert the personalizations done in the current browser session if errors are encountered while personalizing the page.

• You can copy a personalization. This capability allows administrators to rapidly copy a personalization done at a specific level value, such as a responsibility, function, or organization, to other levels such as different responsibilities or different functions.

Thanks,
Anil

Improved Record History | Release R12.2

New in release R12.2
Record History now shows user names rather than user IDs for the ‘Last Updated By’ and ‘Created By’ fields.

Release 12.1.1
Record History is a feature that allows a user to see data about a particular record, such as who created the record and when, and who most recently updated the record and when. Record History is now available for Oracle Application Framework based pages.

It can be possible by setting Profile "FND: Record History Enabled" to Yes for the Header and Table objects. This allows users to see who created or last updated data.

However, it has been seen that after implementing these changes, the record history icon will appear in the header sections and as an additional column in tables, but it doesn't work. When users click on the Record History icon, a small window pops up with either an error message, or all values as null. If that is the case then please raise a SR with Oracle.

For eq - The Record History feature requires changes in the java code which have not yet been implemented in the AR/TCA product.

Thanks,
Anil

ADF Integration with Oracle E-Business Suite

     ADF Integration with Oracle apps release 12.1.3

Release 11g applications deployed on an Oracle Fusion Middleware Release 11g container from the Oracle E-Business Suite home page. Each ADF application will have an FND Function of type ‘ADFX’ defined for it.

If such a function is granted to a user, then when the user logs in, the home page automatically builds a link to the external ADF application.  Note that ADF applications do not support some Oracle E-Business Suite features such as flexfields.

For more information, see the FAQ for Integration of Oracle E-Business Suite and Oracle Application Development Framework (ADF) Applications (My Oracle Support Knowledge Document 1296491.1)
OR
write to me I will provide the FAQ.

Thanks,
Anil

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook - Review

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.

Thanks
AJ

Make DFF field required dynamically

I got many mails from user asking for code which can be refer to make DFF bean required dynamically.

Here is the link:

https://community.oracle.com/thread/1124874

Thx,
Anil