Table Of ContentOracle-Regular / Oracle Fusion Applications Development and Extensibility Handbook / Ajvaz / 369-3
®
Oracle Fusion Applications
Development and
Extensibility Handbook
00-FM.indd 1 11/12/13 3:50 PM
Oracle-Regular / Oracle Fusion Applications Development and Extensibility Handbook / Ajvaz / 369-3
About the Authors
Vladimir Ajvaz is an Oracle expert and has been working with the Oracle E-Business
Suite and, more recently, Oracle Fusion Applications for the past 15+ years. He
worked at Oracle Corporation for many years, and was fortunate enough to work on
some of Oracle’s best teams across the globe where he gained in-depth knowledge of
Oracle technologies. The practical experiences from numerous projects in a wide
range of industries inspired Vladimir to coauthor Oracle E-Business Suite Development
& Extensibility Handbook, which was his first book published by McGraw-Hill
Education (Oracle Press). Today, he provides independent advice and consulting
services to companies around the globe but also inspires and participates in the
development of new enterprise-class products and services.
Anil Passi is an Oracle ACE, with implementation experience across various Oracle
products that include Fusion Applications, Financial Accounting Hub, planning and
modeling tools, Identity & Access Governance, and OFSAA. He is an independent
IT advisor to various financial services organizations in Europe. Anil is also a cofounder
of iTouchVision, a company specializing in public-facing multichannel SaaS CRM
products. In addition, he cofounded a company named Focusthread that gives online
trainings across various Oracle products.
Dhaval Mehta is a Group Development Manager for Fusion Applications in Oracle
Corporation. Previously Dhaval worked on Oracle E-Business Suite applications
development within Oracle Corporation. Dhaval has worked on building Oracle
Sales Cloud applications from their inception to current releases.
About the Technical Editor
Gustavo Gonzalez is an Oracle ACE Director and Chief Technology Officer at IT
Convergence, leading the decision of technology strategy for technology platforms,
partnerships, and external relationships. Specializing in E-Business Suite, Oracle
Business Intelligence, and Fusion Applications, with more than 15 years implementing
and upgrading Oracle Applications for worldwide organizations, Gustavo has led
early adopter programs for Oracle E-Business Suite and Oracle Fusion Applications.
Based in Argentina, he enjoys traveling for business and leisure with his family
around the world.
00-FM.indd 2 11/8/13 5:36 PM
Oracle-Regular / Oracle Fusion Applications Development and Extensibility Handbook / Ajvaz / 369-3
®
Oracle Fusion Applications
Development and
Extensibility Handbook
Vladimir Ajvaz
Anil Passi
Dhaval Mehta
New York Chicago San Francisco
Athens London Madrid Mexico City
Milan New Delhi Singapore Sydney Toronto
00-FM.indd 3 11/12/13 11:21 AM
Copyright © 2014 by McGraw-Hill Education (Publisher). All rights reserved. Printed in the United States of America.
Except as permitted under the Copyright Act of 1976, no part of this publication may be reproduced or distributed in any
form or by any means, or stored in a database or retrieval system, without the prior written permission of publisher, with
the exception that the program listings may be entered, stored, and executed in a computer system, but they may not be
reproduced for publication.
ISBN: 978-0-07-174370-9
MHID: 0-07-174370-7
e-book conversion by Cenveo® Publisher Services
Version 1.0
The material in this e-book also appears in the print version of this title: ISBN: 978-0-07-174369-3,
MHID: 0-07-174369-3
McGraw-Hill Education e-books are available at special quantity discounts to use as premiums and sales
promotions, or for use in corporate training programs. To contact a representative, please visit the Contact Us
pages at www.mhprofessional.com.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. All other trademarks are the property of their
respective owners, and McGraw-Hill Education makes no claim of ownership by the mention of products that contain
these marks.
Screen displays of copyrighted Oracle software programs have been reproduced herein with the permission of Oracle
Corporation and/or its affiliates.
Information has been obtained by McGraw-Hill Education from sources believed to be reliable. However, because of the
possibility of human or mechanical error by our sources, McGraw-Hill Education, or others, McGraw-Hill Education
does not guarantee the accuracy, adequacy, or completeness of any information and is not responsible for any errors or
omissions or the results obtained from the use of such information.
Oracle Corporation does not make any representations or warranties as to the accuracy, adequacy, or completeness of any
information contained in this Work, and is not responsible for any errors or omissions.
TERMS OF USE
This is a copyrighted work and McGraw-Hill Education (“McGraw-Hill”) and its licensors reserve all rights in and to the
work. Use of this work is subject to these terms. Except as permitted under the Copyright Act of 1976 and the right to
store and retrieve one copy of the work, you may not decompile, disassemble, reverse engineer, reproduce, modify, create
derivative works based upon, transmit, distribute, disseminate, sell, publish or sublicense the work or any part of it without
McGraw-Hill’s prior consent. You may use the work for your own noncommercial and personal use; any other use of the
work is strictly prohibited. Your right to use the work may be terminated if you fail to comply with these terms.
THE WORK IS PROVIDED “AS IS.” McGRAW-HILL AND ITS LICENSORS MAKE NO GUARANTEES OR
WARRANTIES AS TO THE ACCURACY, ADEQUACY OR COMPLETENESS OF OR RESULTS TO BE OBTAINED
FROM USING THE WORK, INCLUDING ANY INFORMATION THAT CAN BE ACCESSED THROUGH THE
WORK VIA HYPERLINK OR OTHERWISE, AND EXPRESSLY DISCLAIM ANY WARRANTY, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS
FOR A PARTICULAR PURPOSE. McGraw-Hill and its licensors do not warrant or guarantee that the functions contained
in the work will meet your requirements or that its operation will be uninterrupted or error free. Neither McGraw-Hill nor
its licensors shall be liable to you or anyone else for any inaccuracy, error or omission, regardless of cause, in the work or
for any damages resulting therefrom. McGraw-Hill has no responsibility for the content of any information accessed
through the work. Under no circumstances shall McGraw-Hill and/or its licensors be liable for any indirect, incidental,
special, punitive, consequential or similar damages that result from the use of or inability to use the work, even if any of
them has been advised of the possibility of such damages. This limitation of liability shall apply to any claim or cause
whatsoever whether such claim or cause arises in contract, tort or otherwise.
eBook 369-3cr_pg.indd 1 11/12/13 5:33 PM
Oracle-Regular / Oracle Fusion Applications Development and Extensibility Handbook / Ajvaz / 369-3
To my wife, Milica, and our daughter, Anja—love you both.
—Vladimir Ajvaz
I dedicate this book to my wife Anjali and
two gorgeous sons, Nikhil and Anshu.
—Anil Passi
Dedicated to my lovely wife, Bhumi,
and our beautiful daughter, Aanya.
—Dhaval Mehta
00-FM.indd 5 11/12/13 11:18 AM
Oracle-Regular / Oracle Fusion Applications Development and Extensibility Handbook / Ajvaz / 369-3
This page has been intentionally left blank
00-FM.indd 6 11/8/13 5:36 PM
Contents at a Glance
1 Introduction to Technical Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
2 Introduction to Customization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
3 Flexfields in Oracle Fusion Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .39
4 Security in Fusion Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .67
5 Run-time Customization with Oracle Page Composer . . . . . . . . . . . . . . . . . . . . .109
6 Extending CRM with Oracle Application Composer . . . . . . . . . . . . . . . . . . . . . .141
7 Customizing with Oracle JDeveloper . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .201
8 Building a New User Interface with ADF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .237
9 Business Process Management (BPM) in Fusion Applications . . . . . . . . . . . . . . .295
10 Run-time and Design-time Customizations
of SOA Components in Fusion Applications . . . . . . . . . . . . . . . . . . . . . . . . . .309
11 Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .347
12 Analytics in Fusion Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .383
13 Enterprise Scheduler Jobs and Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .409
14 Custom Look and Feel with ADF Skinning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .433
15 Integration with Fusion Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .453
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .505
vii
00-FM.indd 7 11/8/13 5:36 PM
Oracle-Regular / Oracle Fusion Applications Development and Extensibility Handbook / Ajvaz / 369-3
This page has been intentionally left blank
00-FM.indd 8 11/8/13 5:36 PM
Contents
Acknowledgments ............................................ xv
Introduction ................................................. xvii
1 Introduction to Technical Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Technical Architecture Overview ................................. 2
Fusion Middleware Components ................................. 2
Oracle WebLogic Server .................................. 4
Fusion Applications Product Families .............................. 7
Fusion Middleware Infrastructure Components for Fusion Applications .... 10
Oracle Fusion Middleware Extensions
for Applications ...................................... 11
Oracle Enterprise Scheduler (ESS) ........................... 12
Oracle Enterprise Crawl and Search Framework (ECSF) ........... 13
Oracle Database and Oracle Essbase .............................. 14
Enterprise Manager Controls (Administration Tools) ................... 15
Summary ................................................... 15
2 Introduction to Customization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Understanding Types of Customization ............................ 18
Personalization ......................................... 18
Run-Time Customization .................................. 19
Application Extensions ................................... 19
Design-Time Customization and Extension .................... 20
Other Customizations .................................... 22
Understanding Customization Run-Time Behavior .................... 22
Metadata Services Repository .............................. 22
Customization Layers .................................... 23
ix
00-FM.indd 9 11/8/13 5:36 PM
Description:Master Oracle Fusion Applications Design and PersonalizationDeliver highly adaptable business applications that bolster productivity and drive informed decision-making. Oracle Fusion Applications Development and Extensibility Handbook contains best practices, real-world case studies, and technical d
