Oracle R12 Asset Management
 
 

Oracle R12 Asset Management

Course Code: FAMR12

Duration: 2 days

Our training courses can also be delivered at a location of your choice...

S5

Oracle R12 Asset Management Course Overview

The Oracle R12 Asset Management course is designed for managers and users who are required to set up or work with Oracle Assets on a day to day basis for fixed asset management.

The delegate will learn and acquire skills as follows:

  • Setting up asset controls
  • Defining asset books and categories
  • Setting up depreciation
  • Adding asset additions manually
  • Creating and preparing mass additions
  • Posting mass additions
  • Using CIP asset additions
  • Adjusting and maintaining assets
  • Clearing historical data
  • Transferring assets
  • Depreciating assets and project assets
  • Report reconciliation
  • Retiring and reinstating assets and calculating gains and losses
  • Creating asset management journal entries
  • Using the account generator
  • Performing asset inquiries and reports
  • Tax accounting

Who will the Course Benefit?

The Oracle R12 Asset Management course is suitable for managers and end users such as Fixed Asset Accountants or those who provide first line support to them, who need to set up and use Oracle Assets. It would also be useful for Payables Supervisors so that they can appreciate the integration between Oracle Payables and Oracle Assets. An understanding of basic accounting concepts and the asset management function is required. Knowledge of Oracle Accounts Payable and the General Ledger would be advantageous.

Course Objectives

Delegates will gain an understanding of the asset life cycle. They will be able to add an asset, adjust and revalue an asset, calculate depreciation on an asset, transfer an asset and retire an asset. Delegates will also learn how to use the Mass Additions Process to integrate with Oracle Accounts Payable.

Requirements

An understanding of basic accounting concepts and the asset management function. Knowledge of Oracle Accounts Payable and General Ledger would be advantageous.

Follow-On Courses

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.


 

Course Contents

Oracle R12 Asset Management Training Course

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

Oracle R12 Asset Management Training Course

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
 

Oracle R12 Asset Management

Duration: 2 days

RRP: £1,050.00 exc. VAT 


Upcoming Scheduled Events
Next 12 months

Following Government COVID-19 advice to limit social contact, StayAhead Training have suspended all classroom training for the time being.
Virtual StayAhead Virtual Courses available  & London Schedule
We are running a full Virtual schedule.
Start Date   Spaces Book
04 Jun 2020
StayAhead Virtual Courses available  StayAhead Classroom Courses available 
Spaces StayAhead - Course Running Book
07 Oct 2020
StayAhead Virtual Courses available  StayAhead Classroom Courses available 
Spaces StayAhead - Course Running Book
21 Dec 2020
StayAhead Virtual Courses available  StayAhead Classroom Courses available 
Spaces StayAhead - Course Running Book

Virtual Events StayAhead Virtual Courses available Attend your training using our Live Virtual Classroom solution.

Classroom Events StayAhead Classroom Courses available You can attend in our traditional classroom setting using one of our Training Centres.
In the current climate, attendance at a Training Centre will be reviewed at the time of the request.

Closed Courses Closed Classroom Courses available These Closed Company events can be offered in your own setting or using our Live Virtual Classroom solution.
Delegates can attend from your business location, their home or a location of their choice. A great way to provide training to a group of delegates in a Team environment, even when they are in diverse locations, nationally or even internationally.
 
 
Quick Search....
        Home             Let Us Call You
 

 

Course Deliveries

Public Scheduled and Closed
Virtual
UK and Overseas

OUG

Oracle User Group - Membership Benefits

OUG

Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

StayAhead
Flexibility

Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!

StayAhead Live Virtual Classroom

 
Join live instructor-led classroom training from the comfort of your home or office.

All the convenience and benefits of the classroom experience without the hassle and costs associated to travel and accommodation.
 
 



Our Course Curriculum

 
 
 
 
 



Our Ratings

Instructor
Quality
 

97.35%

Course
Practical
 

92.72%

Overall
Courseware
 

94.36%

Overall
Course
 

96.4%

+44 (0)20 7600 6116
Enquiries@StayAhead.com
Copyright © 2020 StayAhead Training Ltd
Cookies   /   Privacy Policy