Oracle E-Business Suite 12 Financials Cookbook

Oracle E-Business Suite 12 Financials Cookbook

by Yemi Onigbode
Released August 2011
Publisher(s): Packt Publishing
ISBN: 9781849683104

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Take the hard work out of your daily interactions with Oracle E-Business Suite 12 Financials with this book and eBook

  • Delivers practical solutions that can be easily applied in functional EBS environments
  • A step-by-step tour through the EBS R12 Financials core modules in this book and eBook
  • Demonstrates the functional integration points between the EBS R12 Financial modules

In Detail

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.

Quickly master EBS R12 Financials best practices—an ideal quick demo of how it works

Table of contents

  1. Oracle E-Business Suite 12 Financials Cookbook
    1. Table of Contents
    2. Oracle E-Business Suite 12 Financials Cookbook
    3. Credits
    4. About the Author
    5. About the Reviewer
    6. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why subscribe?
        2. Free access for Packt account holders
        3. Instant Updates on New Packt Books
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Errata
        2. Piracy
        3. Questions
    8. 1. Creating Items in Inventory
      1. Introduction
      2. Creating Items
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Assigning Items to inventory organizations
          2. Assigning Items to categories
        5. See also
      3. Exploring Item attributes
        1. How to do it...
      4. Creating Item templates
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Amending the template
          2. Creating an Item and applying the template to the Item
      5. Exploring Item controls
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Storing Items by Subinventories
          2. Storing Items by locators
          3. Identifying Items by lot control
          4. Tracking Items using serial control
          5. Controlling Items using revisions
      6. Adjusting Items in Inventory
        1. How to do it...
        2. There's more...
          1. Searching for Items
      7. Classifying Items
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Viewing the Item Categories structure
          2. Viewing the values in the structure
          3. Creating catalogs
          4. Assigning a catalog description to an Item
          5. Searching for Items using catalog attributes
    9. 2. Purchasing Items in Procurement
      1. Introduction
      2. Raising requisitions for Items
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Smart forms
          2. Accounting codes
          3. Copying a requisition
          4. Correcting a requisition
          5. Canceling a requisition
        5. See also
      3. Approving requisitions
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Reviewing the employee setup
          2. Reviewing the Position Hierarchy
          3. Reviewing the document types
          4. Reviewing the approval groups
          5. Reviewing the approvals assignment
      4. Creating suppliers
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Creating a contact
          2. Creating a bank account
          3. Reviewing the accounting details
          4. Reviewing the purchasing options
          5. Setting the receiving options
          6. Setting the payment details
      5. Creating purchase orders
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Using Blanket Purchase Agreements (BPA)
          2. Viewing the agreement in iProcurement
          3. Using Contract Purchase Agreements (CPAs)
          4. Using the contract in iProcurement
          5. Reviewing the purchasing options
          6. Approving purchase orders and agreements
        4. See also
      6. Receiving Items
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Express Receiving
          2. Returning Items
          3. Correcting receipts
          4. Viewing receipts
          5. Reviewing receiving options
      7. Reviewing procurement accounting transactions
        1. How to do it...
        2. How it works...
        3. There's more...
          1. The Receiving Inventory Account
          2. Inventory AP Accrual Account
          3. Expense AP Accrual Account
          4. Material Cost Account
          5. PO Distribution Charge Account
          6. Financial options
        4. See also
    10. 3. Paying Supplier Invoices in Payables
      1. Entering invoices
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      2. Entering a prepayment
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Entering a quick invoice for a prepayment
          2. Applying a prepayment to an invoice
      3. Entering credit memos
        1. Getting ready
        2. How to do it...
      4. Applying holds to an invoice
        1. Getting ready
        2. How to do it...
        3. H ow it works...
        4. There's more...
          1. Reviewing invoice management holds
        5. See also
      5. Canceling an invoice
        1. Getting ready
        2. How to do it...
      6. Paying invoices
        1. Getting ready
        2. How to do it...
        3. How it works...
      7. Creating a payment process template
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Creating a scheduled payment
      8. Voiding a payment
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Stopping a payment
      9. Reviewing payables accounting transactions
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Creating accounting transactions for multiple invoices
        5. See also
    11. 4. Managing Assets
      1. Introduction
      2. Adding assets
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Manually entering assets
          2. Adding assets to the CIP asset
          3. Mass posting of assets
          4. Merging assets
        5. See also
      3. Adjusting assets
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Adjusting Expense Accounts and Locations
          2. Adjusting assets categories
          3. Adjusting asset values
          4. Transferring costs
      4. Depreciating assets
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Reviewing depreciation methods
          2. Reviewing prorate conventions
        5. See also
      5. Retiring assets
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Partial retirement
          2. Calculating gains and losses
          3. Mass retirements
      6. Reviewing asset accounting
        1. How to do it...
        2. How it works...
        3. There's more...
        4. See also
    12. 5. Selling Items to Customers in Order Management
      1. Introduction
      2. Creating customers
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Adding a customer site
          2. Adding contacts
          3. Adding profile details
      3. Entering sales orders
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Entering orders quickly
        5. See also
      4. Adding Items to price list
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Applying a discount to the price
          2. Viewing modifiers
          3. Mass adding of Items to a price list
          4. Adjusting the price of Items
        5. See also
      5. Reviewing Order Management workflow
        1. How to do it...
        2. How it works...
        3. There's more...
          1. Transaction Types
      6. Creating Drop Ship orders
        1. How to do it...
        2. How it works...
        3. See also
      7. Creating Back-to-Back orders
        1. How to do it...
        2. How it works...
        3. See also
      8. Creating a return
        1. How to do it...
        2. See also
      9. Applying holds
        1. How to do it...
        2. See also
      10. Releasing orders
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Viewing the Pick Slip report
        5. See also
      11. Shipping orders
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Generated reports
      12. Creating invoices
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
    13. 6. Receiving Funds in Receivables
      1. Introduction
      2. Creating an invoice
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Generating accounting
          2. Entering Quick Transactions
          3. Entering deposits
          4. Entering a credit memo
        5. See also
      3. Adjusting invoices
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Adjusting revenue
      4. Entering receipts
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Miscellaneous receipts
          2. Reversing receipts
        5. See also
      5. Managing debt
        1. Getting ready
        2. How to do it...
      6. Reviewing Receivables' accounting transactions
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
    14. 7. Managing Cash
      1. Introduction
      2. Creating bank accounts
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Creating transaction codes
        4. See also
      3. Entering bank statements
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Entering bank statements manually
      4. Reconciling bank statements
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Manual reconciliation
          2. Entering AR receipts
          3. Entering AP payments
          4. Reversing transactions
        5. See also
      5. Creating cash forecasting
        1. Getting ready
        2. How to do it...
      6. Reviewing accounting transactions
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Viewing Transactions in General Ledger
        4. See also
    15. 8. Defining Transactions for the General Ledger
      1. Introduction
      2. Defining the chart of accounts
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Entering Flexfield values
          2. Entering natural account values
      3. Setting up the ledger
        1. How to do it...
        2. There's more...
          1. Reviewing the calendar
          2. Defining the ledger options
          3. Creating the reporting currency
          4. Assigning the Balancing Segment Values (BSV) to the ledger
          5. Defining the operating units
          6. Assigning the ledger to a responsibility
          7. Opening the first general ledger period
          8. Creating journals
      4. Defining Subledger accounting
        1. How to do it...
        2. How it works...
        3. See also
      5. Defining E-Business Tax
        1. Getting ready
        2. How to do it...
        3. See also
    16. 9. End of Period Processing
      1. Introduction
      2. Closing Payables
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Reconciling Payables
          2. Opening the next period
          3. Closing Assets
        4. See also
      3. Closing Purchasing
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Closing Receivables
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Closing Order Management
        4. See also
      5. Closing Inventory
        1. Getting ready
        2. How to do it...
      6. Closing the General Ledger
        1. Getting ready
        2. How to do it...
        3. See also
    17. Index

Product information

  • Title: Oracle E-Business Suite 12 Financials Cookbook
  • Author(s): Yemi Onigbode
  • Release date: August 2011
  • Publisher(s): Packt Publishing
  • ISBN: 9781849683104