Book Image

Oracle E-Business Suite 12 Financials Cookbook

By : Yemi Onigbode
Book Image

Oracle E-Business Suite 12 Financials Cookbook

By: Yemi Onigbode

Overview of this book

Oracle EBS Financials Suite is a solution that provides out-of-the-box features to meet global financial reporting and tax requirements with one accounting, tax, banking, and payments model and makes it easy to operate shared services across businesses and regions. Have you ever wondered how the EBS Financials modules integrate with each other, and do you want to know how this is done quickly? If so, this book is for you. You may have read about what EBS financials does, but with this book on your work desk you will see how to do it. The Oracle E-Business Suite 12 Financials Cookbook will enable you to taste the core functionalities of the main modules using bite size recipes. Each recipe is organized in a way that will enable you to learn the core steps to perform in a key business scenario; it then dives deeper into concepts and scenarios. Discover scenario-based recipes, designed to help you understand how the end-to-end processes within EBS R12 Financials modules are linked together, through touch points. With each chapter, this book develops a full business end-to-end scenario to cover the financial modules. You will start by creating items in Inventory, and then purchase items in Procurement. Then you will move on to entering supplier invoices and paying them in Payables and creating and managing assets. See how items are sold and shipped to customers in Order Management, and how funds are received from customer in Receivables. Manage cash and transfer transactions to General Ledger, and then close periods.
Table of Contents (15 chapters)
Oracle E-Business Suite 12 Financials Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface

Preface

Oracle E-Business Suite 12 Financials is a solution that provides out-of-the-box features to meet global financial reporting and tax requirements with one accounting, tax, banking, and payments model, and makes it easy to operate shared services across businesses and regions. You may have read what EBS Financials does, but with this book on your work desk you will see how to do it.

There are many ways of configuring and using E-Business Suite 12 Financials. This cookbook demonstrates how to use E-Business Suite 12 Financials in a way that will enable you to understand the core functionalities of the main Financials modules. Each recipe is presented as a scenario-based topic that details typical business scenarios.

You will start by creating Items in Inventory, and then purchase Items in Procurement. Supplier invoices are entered and paid in Payables and Assets created and managed.

Items are sold and shipped to customers in Order Management, and funds received from customers in Receivables. Cash is managed and transactions transferred to the General Ledger through the Subledger Accounting with the corresponding tax calculations. The periods are then closed in the final chapter. Let's look at each chapter in brief summaries.

What this book covers

Chapter 1, Creating Items in Inventory, includes recipes for creating Items and exploring the Item attributes. It then continues with creating Item templates and exploring Item controls and concludes with adjusting Items in Inventory and classifying Items into categories.

Chapter 2, Purchasing Items in Procurement, covers the Requisition-to-Receiving flow, with recipes covering raising and approving Requisitions, creating Suppliers, Purchase Orders, and receiving Items. The chapter then concludes with reviewing the Procurement Accounting transactions.

Chapter 3, Paying Supplier Invoices in Payables, covers the Invoice-to-Payment flow, with recipes covering entering and managing various types of Invoices. The recipes then cover payment to Suppliers, and conclude with a review of the Payables Accounting transactions.

Chapter 4, Managing Assets, covers adding and adjusting assets. The recipes then cover depreciating and retiring assets and conclude with a review of Asset Accounting transactions.

Chapter 5, Selling Items to Customers in Order Management, covers the Orders-to-Invoice flow, with recipes covering creating customers and different types of sales orders. The recipes then cover adding Items to a Price List, reviewing Order Management workflow, and the management, releasing, and shipping of orders, and then conclude with creating invoices for customers.

Chapter 6, Receiving Funds in Receivables, covers the Invoice-to-Receipt flow, with recipes covering creating and adjusting invoices, entering receipts, and managing debts. It concludes with reviewing the Receivables Accounting transactions.

Chapter 7, Managing Cash, covers creating a bank account, and entering and reconciling bank statements. It then goes on to creating Cash Forecasts, and concludes with a review of Cash Accounting transactions.

Chapter 8, Defining Transactions for the General Ledger, covers defining the Chart of Accounts, and setting up the ledger. It then covers defining Subledger Accounting and concludes with defining E-Business tax accounting.

Chapter 9, End of Period Processing, covers closing Payables, Purchasing, Receivables, Inventory, and the General Ledger.

What you need for this book

You will need access to the standard Oracle E-Business Suite 12 demonstration Vision database. This can be downloaded from http://edelivery.oracle.com.

Who this book is for

This book is for E-Business Suite Financials specialists who want a broader understanding of particular areas of the Financials modules. Businesses can use this book to identify key functionalities of the financial modules, and very quickly demonstrate a pilot to obtain the core requirements.

If you are a business analyst, functional consultant, technical consultant, project sponsor, project manager, project team member, system accountant or solution designer, testing team member, training team member or support team member, then this book is for you.

This book assumes that you have basic navigation skills and you understand some key E-Business Suite terminology.

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Search for the PRD20001 Item."

Note

Warnings or important notes appear in a box like this.

Note

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to, and mention the book title via the subject of your message.

If there is a book that you need and would like to see us publish, please send us a note in the SUGGEST A TITLE form on www.packtpub.com or e-mail.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books maybe a mistake in the text or the code we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/support, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.

Piracy

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

Questions

You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.