Table Of ContentOracle PeopleSoft Enterprise
Financial Management 9.1
Implementation
An exhaustive resource for PeopleSoft Financials
application practitioners to understand core concepts,
configurations, and business processes
o
D Ranjeet Yadav
professional expertise distilled
P U B L I S H I N G
BIRMINGHAM - MUMBAI
Oracle PeopleSoft Enterprise Financial Management 9.1
Implementation
Copyright © 2011 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: June 2011
Production Reference: 1200611
Published by Packt Publishing Ltd.
32 Lincoln Road
Olton
Birmingham, B27 6PA, UK.
ISBN 978-1-849681-46-9
www.packtpub.com
Cover Image by Dan Anderson ([email protected])
Credits
Author Project Coordinator
Ranjeet Yadav Zainab Bagasrawala
Reviewers Proofreader
Tim Lin Lucy Henson
Jennifer Sharp
Sudharsan Srinivasaraghavan Indexer
Monica Ajmera Mehta
Acquisition Editor
Dhwani Devater Graphics
Geetanjali Sawant
Development Editor
Neha Mallik Production Coordinator
Melwyn Dsa
Technical Editors
Aditi Suvarna Cover Work
Melwyn Dsa
Neha Damle
About the Author
Ranjeet Yadav has been working in the IT industry for more than 10 years. He
possesses professional experience of more than 8 years as a functional consultant
with PeopleSoft finance and supply chain applications. He has worked on PeopleSoft
implementations for many world class organizations and performed various roles
such as PeopleSoft consultant, Module lead, Finance track lead, and Project manager.
Although his entry into the PeopleSoft world was rather accidental, he was quickly
impressed by the deep impact such an ERP product can have on an organization's
functioning. He finds the challenge of designing solutions for organizations' critical
business problems quite exciting.
Ranjeet holds an Electronics Engineering degree and a Post Graduate Diploma in
Management with specialization in Information Systems from Indian Institute of
Management, Lucknow.
This book would not have been possible without the support of my
parents. It was their encouragement and unwavering help through
the challenging times that was crucial. It was my wife, Madhavi,
who encouraged me to accept the challenge of writing this book.
Managing the writing as well as the office job was certainly not easy,
but she endured my working late nights and weekends for all these
months. I simply wouldn't have been able to proceed without her
understanding. I dedicate this book to her.
About the Reviewers
Tim Lin has 14 years' experience of functional and technical ERP systems
implementation and support with PeopleSoft, JDE, Taleo, and Saba. He has been
involved in all phases of systems delivery including project management, design,
development, test, and production rollout and support. He has deep functional HR
and Payroll knowledge coupled with strong technical and project management skills.
Tim has implemented complex, high volume HR, and Payroll systems for large
Fortune 500 companies including Federal Express, Manpower International, and Fox
Entertainment Group. He has been a consultant for 15 years, including six years with
Accenture. Currently, he is a Director at Fox Entertainment Group.
Jennifer Sharp has international experience in both the functional and technical
sides of I.T. She has worked in the aerospace, government, healthcare, hospitality,
pharmaceutical, and retail industries; specifically as a Project Manager, System
Administrator, Technical Writer, QA Tester, IS Analyst, and creating
web-based training.
She has worked for the State of Indiana, Eli Lilly and Company, Eli Lilly UK,
Lockheed Martin, and Orlando Health.
For further information, please visit her website at www.jennifersharponline.com.
I would like to thank Nathan, Logan, and Archer for their support
and inspiration.
Retail-PeopleSoft Savoir-Faire, this term perfectly fits Sudharsan
Srinivasaraghavan. Sudharsan has spent the last eight years with major retail
giants of US, helping them to successfully transform business processes, implement
new enterprise systems, and in upgrade of large PeopleSoft programs.
He is a Principal Consultant of Enterprise Solutions Practice at a leading Global
Technology Services Company. He has close to two decade experience in managing
and implementing various ERP applications. He is specialized in PeopleSoft (PS)
Financials and Supply Chain Management applications though. Before entering
the IT Consulting, he was leading the Accounts Payable, Asset Management, and
Corporate Accounts team in a leading Construction Company of India for 6 years.
Sudharsan also presented a paper on PS Maintenance Management in Retail Industry
at Oracle Annual Maintenance Summit 2010.
He has earned a Bachelor's degree in Commerce and Accounting, and he is also a
Cost Accountant.
Sudharsan and his wife, Lakshmi, have a girl, Varsha. He loves to spend time with
his kid.
www.PacktPub.com
Support files, eBooks, discount offers, and more
You might want to visit www.PacktPub.com for support files and downloads related to
your book.
Did you know that Packt offers eBook versions of every book published, with PDF
and ePub files available? You can upgrade to the eBook version at www.PacktPub.
com and, as a print book customer, you are entitled to a discount on the eBook copy.
Get in touch with us at [email protected] for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a
range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.
http://PacktLib.PacktPub.com
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book
library. Here, you can access, read, and search across Packt's entire library of books.
Why subscribe?
• Fully searchable across every book published by Packt
• Copy and paste, print, and bookmark content
• On demand and accessible via web browser
Free access for Packt account holders
If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib
today and view nine entirely free books. Simply use your login credentials for immediate access.
Instant updates on new Packt books
Get notified! Find out when new books are published by following @PacktEnterprise on
Twitter, or the Packt Enterprise Facebook page.
Table of Contents
Preface 1
Chapter 1: PeopleSoft Financials Fundamentals 7
Understanding Chart of Accounts and chartfields 8
Implementation challenge 8
PeopleSoft chartfields 10
Chartfield configuration 11
Standard chartfield configuration 12
Advanced chartfield configuration 15
Understanding Business Units and SetID 16
Business Unit 17
Tableset ID 18
Scenario 1 18
Scenario 2 19
Configuring SetID 19
Configuring TableSet Control 20
Understanding accounting structure—Ledgers and Journals 21
Configuring ledgers and Journal Generator 23
Configuring ledger templates 24
Configuring ledgers 27
Configuring ledger groups 28
Configuring ledgers for a Business Unit 31
Configuring journal sources 37
Configuring accounting entry definitions 40
Configuring journal templates 43
Configuring banks 47
Configuring bank ID qualifiers 48
Configuring banks 49
Configuring bank branches 50
Configuring external bank accounts 52
