Oracle E-Business Suite Financials R12: A Functionality Guide

336 Pages·2012·7.836 MB·English

by  Mohan Iyer

Oracle E-Business Suite Financials
R12: A Functionality Guide
Know what Oracle E-Business Suite can do before
you implement it
Mohan Iyer
BIRMINGHAM - MUMBAI
Oracle E-Business Suite Financials R12:
A Functionality Guide
Copyright © 2012 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval
system, or transmitted in any form or by any means, without the prior written
permission of the publisher, except in the case of brief quotations embedded in
critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy
of the information presented. However, the information contained in this book is
sold without warranty, either express or implied. Neither the author, nor Packt
Publishing, and its dealers and distributors will be held liable for any damages
caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the
companies and products mentioned in this book by the appropriate use of capitals.
However, Packt Publishing cannot guarantee the accuracy of this information.
First published: April 2012
Production Reference: 1180412
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-84968-062-2
www.packtpub.com
Cover Image by David Gutierrez ([email protected])
Credits
Author Project Coordinator
Mohan Iyer Shubhanjan Chatterjee
Reviewers Proofreader
Brian R. Bouchard Aaron Nash
Faun deHenry
Alex Fiteni Indexers
Monica Ajmera Mehta
Scott Gordon
Tejal Daruwale
Jeffery T. Hare
John Peters
Graphics
Ajay Pradhan
Valentina D'Silva
Thomas Simkiss
Manu Joseph
Ketan J Thanki
Production Coordinators
Acquisition Editor Aparna Bhagat
Rukshana Khambatta
Nilesh R. Mohite
Lead Technical Editors
Cover Work
Arun Nadar
Aparna Bhagat
Meeta Rajani
Technical Editors
Joyslita D'Souza
Veronica Fernandes

Foreword
I have known Mohan Iyer for many years, first professionally and now personally.
Mohan is a tireless advocate for the development of best practices and for making
the Oracle E-Business Suite world a better place. He is one of those guys who digs
into issues and understands it both technically and functionally before making
a recommendation to a client. Mohan is also a great asset to the user community
through Oracle Applications Users Group (OAUG), NorCal Users Group, and
other forums.
This book is the culmination of many, many years of Mohan's experience and
research. Readers of this book will be blessed with great insight and comprehensive
analysis of the functionality and best practices related to Oracle's R12 E-Business
Suite release. I am pleased to be able to recommend this book.
This book focuses primarily on issues related to functionality. If you have questions
on internal controls or security relating to this content, feel free to e-mail me at
[email protected].
Jeffrey T. Hare, CPA CISA CIA
CEO, ERP Risk Advisors
About the Author
Mohan Iyer has more than 20 years' experience in system implementations with
the last 15 years implementing Oracle Financials. He has a strong background in
Finance and Accounting, having had these as his major subjects in college. He has
an Accounting degree from the University of Bombay (Mumbai), India.
His skill set includes a full range of financial applications in Oracle Applications
and related modules where there is a financial impact. His broad range of skills
have helped him with his implementation of, Record to Report, Procure to Pay, and
Quote to Cash processes, with reengineering and crystallizing processes during
implementations. His tenure as a Consultant and a Manager of financial applications
in corporate America, brings to the table a wide range of experience with financial
processes that include inter-company, multi-currency, statutory needs, and process
flows to manage operational changes that will lead to efficiency and appropriate
accounting results. He has been a board member of the NorCal OAUG and
Multi-National SIG. He is the coordinator of the GL SIG and has presented
various papers at OAUG and related conferences.
He lives in California with his wife and two kids. He can be contacted at
[email protected] or on 408 859 4484.
Visit www.fscpsolutions.com for a peek at training material (the training material
can be found under the "Training Collateral" link) and other content that he has
presented at various conferences and public meetings. The presentation collateral
can be found under the link "Presentation Collateral".
He has worked on multiple projects where training has been a key deliverable and
has developed multiple formats of delivering effective training.
FSCP Solutions Inc. also has generic training material and is building content that
will help the finance user get an easy path to effectively use the E-Business Suite.
The training collateral on the website is generic training material.
Acknowledgement
I have to acknowledge the support and patience from my wife and her continued
support in allowing me the time to research and write this book. It would not have
been possible to make this effort a success without her support. I would also like to
extend an acknowledgement to people who are my peers and helped me immensely
in reviewing the book and giving me valuable feedback regarding content and
writing style. My heartfelt gratitude and thanks go to – Alex Fiteni, Ajay Pradhan,
Brian R. Bouchard, Faun deHenry, John Peters, Ketan J Thanki, Scott Gordon, and
Thomas Simkiss.
I would also like to thank the many others that I have reached out to ask specific
questions related to content in some of the chapters where their expertise was far
higher than mine.
Last of all and once again, I would like to thank my family, my wife and two kids
who bore the brunt of the long hours when I researched and wrote the book.
About the Reviewers
Brian R. Bouchard is a passionate person who enjoys helping others understand
the complexities around Oracle Financials applications. He was introduced to
Oracle Applications back in the 90s when he served as the Fixed Assets Manager
at Motorola. Playing an integral role in the implementation and rollout of the
application, he decided to change career paths from Accountant to Consultant. In
his consulting career, he has designed, developed, and implemented over 50 full life
cycles of Oracle EBS Applications ranging from Release 9 – Release 12.1.3. He has
always strived to help others and to find the most efficient ways to perform tasks
and to utilize the system. This characteristic led him to develop bolt-on products for
Oracle Assets and he opened the doors of his own company in 2006. As President
and CEO of Chi-Star Technology SM, he is striving to improve the utilization of
Oracle Assets and to streamline manual efforts by automating some of the most
tedious processes in Oracle Assets. Due to his passion to educate people on the
complexities of Oracle Applications, he has also conducted well over 200 training
sessions on various applications and releases. In the summer of 2009, he founded the
CST Education Network, which was started to offer low cost education on Oracle
Applications via webinars and video training.
He realized the areas of opportunity in Oracle Assets: Asset Transfers and
Reconciliation. In April 2006, the introduction of AssetCross® came to the market
as a solution to the manual asset transfer procedure. The AssetCross® software will
transfer single or multiple assets between corporate depreciation books, transfer
full or partial (cost or units) assets, translate transferred amounts to the receiving
depreciation book's currency, and maintain an audit trail with the original asset.
In June 2008, the introduction of AssetTie® came to the market as a solution to the
reconciling Oracle Assets procedure. The AssetTie® software will capture balances
from Oracle General Leger and compare them to balances in Oracle Assets and
identify variances. The same technology is used to compare the transactions copied
from Corporate Books to the Associated Tax Books. Within seconds of posting
a journal entry from Oracle Assets, the user can determine if there are any
reconciling differences.
The introduction of AssetCross® and AssetTie® to the business world has
revolutionized the asset transfer and reconciling processes. Fortune 500 corporations
as well as mid-sized family-owned companies can all benefit from this software.
Visit Chi-Star Technology at http://www.chistartech.com to learn more about
the bolt-on products and education session/training offered.
I would like to acknowledge my family who have been with me
every step and who have endured the schedule of a business
traveler.
Faun deHenry is President and CEO of FMT Systems of Texas, Inc. Her
appreciation for business process excellence and love of teaching have lead her into
a very successful career. She has worked more than 15 years operating regional and
national consulting organizations before embarking on her own corporation.
She is a recognized speaker and writer on topics including managing and
sustaining virtual teams, business process innovation, Oracle's E-Business Suite, and
business intelligence. She has co-authored Business Process and More (e-book series
published by FMT Systems of Texas, Inc.) and Installing, Upgrading and Maintaining
Oracle E-Business Suite Applications Release 11.5.10+ with Solution Beacon, LLC;
additionally she is an accomplished contributor with the BPM Institute and her
own site at processconnectionsblog.com.
I'd like to thank my many friends and family members who have
supported me through the lengthy process of reviewing Mohan's
book. They have each played their integral part in my success by
bringing me Cook Out shakes during the late night editing sessions
and by walking Meg during the "wee" hours of the morning. But
mostly, I'd like to thank Hope Malone, for just being Hope.

*Tosses kisses loftily into the wind.*