Oracle R12 Fixed Assets Changes From 11i

R12 Fixed Assets Overview

New and Changed Features in R12

 Process Efficiency • Enhanced Mass Additions for Legacy conversions • Automatic Depreciation Rollback • Automatic Preparation of Mass Additions  Industry Enhancements • Enhanced Functionality for Energy Industry  Flexible Accounting  Uptake of Subledger Accounting Architecture  Flexible Reporting • Reporting using XML publisher

Enhanced Mass Additions

Mass Additions Process in 11i Oracle Payables Oracle Projects

Legacy System

ADI

FA Mass Additions

Review Mass Additions Asset Category to Default asset depreciation rules

FA Asset Books

R12 Enhanced Mass Additions

R12 New Features New attributes added to FA_MASS_ADDITIONS

• • • • • • • •

Asset Life Depreciation Method Prorate Convention Bonus Rule Allowed Depreciation limit Allowed Depreciation limit amount Salvage type Percent salvage value

Web ADI Mass Additions template enhanced to include new columns

Enhanced Mass Additions Legacy conversions Web ADI template for Asset Mass additions enhanced to add additional columns

New columns added

Automatic Depreciation Rollback

Roll Back Process in 11i Asset Book

Run Depreciation

Adjustment required for Asset

Rollback Depreciation for entire Book

Create Adjustment

Run Depreciation

RollBack - R12 New Feature

Adjustment required for Asset

Asset Book

Run Depreciation

Create Adjustment

Automatic Rollback of Depreciation for asset Run Depreciation (Adjusted asset)

Automatic Depreciation Rollback  Conditions for Automatic Rollback: • Depreciation processed for the period and • The period is not closed  Adjusted Asset depreciated in next depreciation run.  Rollback Depreciation program (R11i) is now obsolete

Automatic Preparation of Mass Additions

Automatic Preparation Mass Additions

 Auto Prepare Mass addition lines to avoid manual intervention.  Auto populate required fields such as Expense Account, Asset Category etc.  Use default rule or use custom extension.  New Concurrent Program: Prepare Mass Additions

Automatic Preparation Mass Additions Choice of 3 types of rules to Prepare Mass Additions: Use Default Use Custom Use Custom Energy

Automatic Preparation Mass Additions

Mass Addition Rules • Default Rule : – Asset Category derived from Asset Clearing Account if one to one match is

available – Expense account derived from Asset clearing account, by replacing natural account segment. • Custom Rule: Rule defined in API FA_MASSADD_PREPARE_PKG • Custom Energy: Energy industry custom rule

Enhanced Functionality for Energy Industries

Enhanced Functionality for Energy Industry

– Units of Production method now allowed for Group Assets. – Custom Energy Industry rule for Automatic creation of assets through Mass Additions.

UOP method for Group Assets Group Asset Year 1 Acquisition of Rig

• Cost = $100,000 • Life = 14 yrs • Capacity: 18 million barrels

Year 2 Repair/ Refurbishment $ 50,000 Capacity: 12 million barrels

Year 4 Repair/ Refurbishment $ 75,000 Capacity: 9 million barrels

UOP Method for Group Assets • New Energy Units of Production Method for Group Assets Depreciation amount = Net Book Value x ( Production for the Period / Net Remaining Production Capacity) Net Remaining Production Capacity = Total Capacity – Production used to date

Uptake of Subledger Accounting Architecture

SLA Uptake  Oracle Assets fully integrated with Subledger Accounting.  Transactions in Assets are denoted by different Event Classes.  Event Classes are grouped into the following Event entities:  Transactions: Additions, Adjustments, Capitalizations, Reclassification, Retirements, Unit Adjustments, Unplanned Depreciation etc.  Depreciation : Depreciation & Depreciation Rollback.  Inter Asset Transfers: Source Line transfers, Reserve Transfers etc.  Deferred Depreciation: Deferred Depreciation.

SLA Uptake  Users can use the seeded Account Derivation definitions or modify them.  Continue to support Account Generator functionality for existing Asset Books.    

FA: Use Workflow Account Generation = Yes Create Journal Entries replaced by Create Accounting program. SLA options in the Menu for online enquiry. Account Drilldown report replaced by SLA Account Analysis report

Viewing transaction events in SLA

Reporting Using XML Publisher

Reporting using XML publisher

– Major Asset Transaction reports modified to support XML publisher. – Users can modify seeded templates or use new templates to view report output.

Reporting using XML publisher  XML reporting is available for major Asset Transaction reports:             

Asset Transfers Report Transaction History Report Asset Reclassification Report Mass Additions Create Report Cost Adjustment Report Cost Summary Report CIP Summary Report Reserve Summary Journal Entry Reserve Ledger Asset Additions Report CIP Capitalization Report Mass Additions Posting Asset Retirements

Reporting using XML publisher Change report output Format to XML (in System Administrator responsibility > Concurrent program definition)

Report showing Text Output

Report using XML output

Join our growing Network at www.OracleERP.org