Oracle R12 Asset Management

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: OVERVIEW OF THE ORACLE ASSET MANAGEMENT PROCESS

• Overview of Oracle Assets
• Integration
• Assets Key Flexfields
• Implementing Assets
• Asset Books and Categories
• Adding Assets Manually
• Mass Asset Additions Process
• Adding and Capitalizing a CIP Asset
• Acquire and Build CIP Assets
• Asset Adjustments
• Physical Inventory
• Depreciation
• Calculating Depreciation
• Tracking Asset Retirements
• Assets Journal Entries
• Viewing Asset Information On-Line
• Assets Reporting
• Creating A Tax Book
• Entering Information In Tax Books

Session 2: ASSET CONTROLS SET UP

• Oracle Assets Setup Steps
• Setup Steps Flow
• Oracle Assets Key Flexfields
• Defining Key Flexfields
• Asset Category Key Flexfield
• Location Key Flexfield
• Asset Key Key Flexfield
• Creating Key Flexfield Combinations
• Specifying System Controls
• Quick Codes
• Defining Fiscal Years And Calendars
• Setting Up Fiscal Years
• Setting Up Asset Calendars
• Sharing Calendars
• Profile Options
• Maintaining Audit Trails

Session 3: ASSET BOOKS

• Asset Books Positioning
• Asset Books Regions
• Calendar Region
• Accounting Rules Region
• Natural Accounts Region
• Security By Book
• Organisations and Security By Book
• Use of Security By Book Within Process Flow
• Security By Book Set Up Steps
• Troubleshooting Security By Book

Session 4: ASSET CATEGORIES

• Asset Categories
• Asset Categories Set Up

Session 5: MANUAL ASSET ADDITIONS

• Adding Assets Manually
• Asset Additions Required Data
• Quick Additions
• Detail Asset Additions
• Asset Cost Terminology
• Depreciate Check Box Actions
• Detail Additions - Assignments and Source Lines Window
• Manual Asset Additions Journal Entries

Session 6: MASS ASSET ADDITIONS

• Mass Asset Additions Process
• Using The Mass Additions Interface Table
• Adding Assets From Invoice Distribution Lines
• The Mass Additions Process
• Mass Additions Create
• Requirements To Create Mass Addition Lines
• Tracking Expensed Items In Oracle Assets
• Other Mass Additions Considerations
• Prepare Mass Additions
• Mass Addition Queues
• Changing Asset Information
• Merging Mass Addition Lines
• Splitting Mass Addition Lines
• Adding A Mass Addition To An Existing Asset
• Accounting For Cost Adjustments Example
• Post Mass Additions
• Effect On Post Mass Additions On Queue Names
• Delete Mass Additions
• Purge Mass Additions
• Future Transactions
• View Pending Transactions

Session 7: CIP ASSET ADDITIONS

• Adding And Capitalising A CIP Asset
• Acquire And Build CIP Assets
• Automatically Adding CIP Assets To Tax Books
• Modifying The Cost Of CIP Assets
• Capitalising A CIP Asset
• Reversing A Capitalised Asset
• Recording A Capitalisation
  • Adding And Capitalising In The Same Period
  • Adding And Capitalising In Different Periods
• CIP Assets and Oracle Projects
• Capital Projects Flow Integration
• Creating Mass Additions From Oracle Projects
• Integrating Oracle Projects With Oracle Assets

Session 8: ASSET ADJUSTMENTS

• Asset Adjustment Overview
• Single Asset Reclassification
• Mass Reclassification
• Inheriting Depreciation Rules
• Mass Transactions Process
• Adjusting Units
• Adjusting Financial Information
• Expense Or Amortise Depreciation Adjustments
• Using Mass Changes
• Single Asset Transfers
• Mass Asset Transfers
• Performing Physical Inventory
• Entering Physical Inventory
• Physical Inventory Comparison
• Physical Inventory Reconcilliation

Session 9: DEPRECIATION

• Elements Of Depreciation
• Basic Depreciation Calculation
• Depreciation Methods
• Using The Life-Based Method
• Using The Flat-Rate Method
• Prorate Conventions
• Run Depreciation Process
• Depreciation Program Processes
• Projecting Depreciation for an Asset
• Defining a Projection
• Depreciation Forecasts
• Using Depreciation Override
• Depreciation Reports

Session 10: ASSET RETIREMENTS

• Tracking Asset Retirements
• Overview of Retiring an Asset
• Restrictions on Retirements and Reinstatements
• Fully Retiring Assets
• Partially Retiring Assets
• Mass Asset Retirements
• Reinstating Retired Assets
• Calculate Gains and Losses Program
• Retirement Processing Flow
• Processing a Pending Retirement And Reinstatement
• Calculating Depreciation for the Period Retired
• Recording Retirements and Reinstatements
• Retirement Reports

Session 11: ASSET ACCOUNTING

• Assets Journal Entries Flow
• Journal Entries Created
• Account Generator
• Default Account Generator Process for Oracle Assets
• Account Generator Example - Build Asset Cost Account
• Generating Reports to Reconcile to the General Ledger
• Reconciling Asset Cost Accounts
• Reconciling a CIP Cost Account
• Reconciling a Reserve Account
• Reconciling Depreciation Expense
• Reconciling Mass Additions

Session 12: ASSET ENQUIRY AND REPORTING

• Asset Inquiry Options
• Viewing Financial Information
• Viewing Transaction History
• Viewing Transaction Accounting
• Assets Reporting
• Assets Reports Groupings
• Variable Format Reports

Session 13: TAX ACCOUNTING

• Creating a Tax Book
• Asset Books Regions
• Prerequisites for Setting up Tax Book Asset Categories
• Entering Information In Tax Books
• Populating the Tax Book
  • By Initial Mass Copy
  • By Periodic Mass Copy
• Updating a Tax Book Manually
• Tax Rules
• Deferred Depreciation
• Calculating Deferred Depreciation
• Adjusting Accumulated Depreciation
• Adjusting Depreciation Reserve
• Controlling Mass Depreciation Adjustment
• Calculating Mass Depreciation Adjustment
• Automatically Adding CIP Assets to Tax Books
• General Tax Reports
• Special Tax Reports
• Depreciation Adjustment Reports

Session 14: ASSET MANAGEMENT EXERCISES

• Create a Value for an Asset KFF Location
• Create a Location KFF Combination
• Add Quickcode Values
• Create an Assets Calendar
• Define an Asset Book
• Add Asset Category KFF Values
• Define Asset Categories
• Add Asset Categories to an Asset Book
• Add an Asset Using Quick Additions
• Add an Asset Using Detail Additions
• Add an Asset with Multiple Assignments
• Detailed Addition with a Distribution Set
• Create Mass Addition Lines
• Prepare Mass Addition Lines
• Post Mass Additions
• Create a CIP Asset and Add Costs
• Add a CIP Asset Cost Via Mass Additions
• Capitalize a CIP Asset
• Perform Single Asset Adjustments
• Perform a Mass Change
• Create a New Depreciation Method
• Create a Prorate Convention
• Set up a Physical Inventory
• Create and Compare a Physical Inventory using Integrator
• Add Assets using Integrator
• Run Depreciation
• Run a Depreciation Projection
• Perform a Retirement and Reinstatement
• Create and Review Journal Entries
• Perform Asset Inquiries
• Define a Tax Asset Book
• Add Asset Categories to a Tax Book
• Perform an Initial Mass Copy
• Manually add an Asset to a Tax Book
• Run Depreciation for a Tax Book
• Adjust Depreciation Reserve
• Add a Leased Asset