r12 overview of oracle assets

Copyright © 2007, Oracle. All rights reserved.Copyright © 2007, Oracle. All rights reserved.

Overview of Oracle Asset Management

Release 12 Oracle Asset Management Fundamentals

Copyright © 2007, Oracle. All rights reserved.

Objectives

After completing this module, you should be able to do the following:• Describe the overall Oracle Asset Management

process from Setup through asset data flow to the General Ledger

• Identify the key functional areas that are part of Oracle Asset Management


Agenda

• Asset Management Process Overview• Key Areas within Asset Management


Asset Additions TransfersAdjustments

Retirements

Depreciation

Journal Entries

Reports

Online inquiry

Taxes

ExternalManual CIP

Overview of Oracle Assets


Oracle Payables

Oracle Projects

Oracle Human Resources

Journal Entries

Oracle Purchasing

Suppliers

Spreadsheet

Budget Information

Oracle Inventory

Invoice Lines

Oracle General Ledger

Oracle Assets/iAssets

EmployeesUnits of MeasureItem Information

E-Business Suite Integration

Web ADI

Physical InventoryAsset Additions

CIP assets


Implementation Considerationsfor Oracle Financials

Oracle Applications without customization

Future Oracle upgrades

Costly future upgrades


The Best Project Team for the Job

Implementation consultants

Client experts

End users

Implementation team


Critical Implementation Issues

Identify critical implementation issues that affect multiple business areas:• Shared information• Information flows• Open interfaces• Non-Oracle systems


Oracle Assets Setup Steps

LedgerAsset Key FlexfieldAsset Category FlexfieldLocation FlexfieldSystem ControlsFiscal YearsCalendarsBook ControlsProrate/Retirement

ConventionsAsset Categories

RequiredAccount GeneratorQuickCodesDepreciation Methods

Required w/Defaults

Unit of Measure ClassesUnits of MeasureEmployeesDescriptive FFNumberingSuppliersLocations CombinationsAsset Keys CombinationsSecurityInvestment Tax CreditsPrice IndexesDistribution SetsLeasesWarrantiesProfile OptionsInsurance

Optional


Oracle Assets Key Flexfields

To run the application, three key flexfields must be set up.

Asset CategoryKey Flexfield

Asset LocationKey Flexfield

Asset KeyKey Flexfield


Implementing Oracle Assets

Plan Implementation Setup Asset Mgmt including iAssets

Convert Existing Asset Information

Reconcile With Previous System

1 2

3 4


Asset Books Positioning

Corporate

Tax

Budget

Asset Categories

Asset Calendars

Depreciation Methods

Asset BooksAssets

Assigned to

Assigned to

New assets are assigned to a Category then to a Book


Asset Categories Positioning

Asset Categories

Corporate Book

Tax Book A

Tax Book B

Assets

Assign to

Attached to

Added to

Copied to


Asset Life Cycle

Birth of an Asset

Asset Depreciates

Asset Retired

FA_MASS_ADDITIONS

Oracle Payables

Oracle Projects

Other/ Legacy

Systems

WebADIManual Additions

Quick AdditionsDetail Additions

AssetBooks


Adding Assets Manually

Quick Additions Detail Additions

Assets that require more information

Oracle Assets

Assets added applying default

rules


Mass Asset Additions Process

FA_MASS_ADDITIONS

Oracle Payables

Oracle Projects

Other Systems

Legacy System

Web ADI

Asset Books


Adding and Capitalizinga CIP Asset

Depreciate the asset Capitalize a CIP asset

Add a CIP asset Build a CIP asset


Acquire and Build CIP Assets

CIP ASSET

FA_MASS_ADDITIONS

Oracle Projects

Oracle Payables

Mass Additions

Asset Lines

Manual Additions


Asset Adjustments

Reclass

Unit Change Change

Financial Info

Transfer Changes via APIs

Oracle Assets/iAssets


Asset Adjustment Overview

Adjustment Action Performed Mass

Transaction Available

Reclassification Change Asset Category Yes

Unit Change Change Number of Asset Units

No

Financial Information

Change Asset Cost and/or Depreciation Information

Yes (Prorate Convention, Method, Life

only) Transfer Change Asset Assignment

Information Yes


Performing Physical Inventory

Enter physical inventory

Viewcomparison

Update assetsmanually

Reconciledifferences

Run inventorycomparison


Elements of Depreciation

Asset Books

Prorate Convention

Prorate Calendar

Depreciation Method

Depreciation Ceilings

Investment Tax Credits

Units of Measure

Price Indexes

Depreciation

Optional Elements

Depreciation Calendar


Basic Depreciation Calculation

Apr15

May1

Prorate Convention FOL Month

ProrateCalendar

Rate Table

R = 20%

Get Rate

Multiply by Cost or Net Book Value

Annual Depreciation

Depreciation Expense per

period

Prorate Period

Depreciation Calendar, Divide Depreciation flag, and Depreciate When Placed in Service flag

Journal Entry

Date Placed in Service

Prorate Date


Tracking Asset Retirements

Invoice

Depreciation

Createjournal entries

Asset LifeManual

addition

Transfer

Automated addition

Adjustment


Assets Journal Entries Flow

In Asset Books:-Allow GL Posting-GL Ledger Name

Run Depreciation to Generate Accounts

Run Create Accounting

Send entries to General Ledger

Post entries

Yes

No

Run Transfer Journal Entries to GL

Set up SLA


Default Account Generator Process for Oracle Assets

For example, the Operations Accounting flexfield structure from the Vision demo database is used.

Company-Cost Center-Account-Product-SubAccount

Segment Name Default Segment Sources

Company (Balancing Segment)

Distribution CCID (Assignments screen)

Cost Center (Cost Center Segment)

Default CCID (Book Controls screen)

Account (Natural Account Segment)

Account Segment Value

Product Default CCID (Book Controls screen)

Sub-Account Default CCID (Book Controls screen)

CCID = Code Combination ID


Oracle Payables

Oracle Projects

Oracle General Ledger

Oracle Assets

Reconciling Data in Oracle Assets


Viewing Asset Information Online

Depreciation Book

Financial Information

Employee Purchasing Information

Invoice Supplier

Inquiry

Location


Oracle Assets Reporting

Oracle Assets Reports

Standard Reports

Variable Format Reports (RXi)

Report Manager


Assets Reports Groupings

Budget Reports

CIP Reports

Asset Listings

Maintenance Reports

Setup Data Listings

Depreciation Reports

Accounting Reports

Responsibility Reports

TaxReports

Transaction History

Additions Reports

Mass Addition Reports

AdjustmentReports

TransfersReports

ReclassificationReports

RetirementReports

Mass TransactionReports


Creating a Tax Book

Corporate book

Tax book

Monthly calendar

Quarterly calendar

Asset 325

Asset 843

Asset 325

Asset 843

FURNITURE.DESKS Straight-line 5 years MID-MONTHVEHICLE.OWNLUXURY Straight-line 4 years MID-MONTH

FURNITURE.DESKS MACRS 5 years HALF-YEAR

VEHICLE.OWNLUXURY MACRS 4 years HALF-YEAR

Assets in Independent Asset Books


Entering Information in Tax Books

Corporate Book

Tax Book Tax Book Tax Book

Initial Mass Copy Periodic Mass Copy Manual Entry


Transaction APIs

Submit transactions directly thru PL/SQL using APIs.• Additions• Adjustments• Retirements and Reinstatements• Transfer and Unit Adjustments• Reclassifications• Capitalizations• Unplanned Depreciation• Asset Description


Business Events

Business Events were first introduced in Oracle Workflow to:• Provide subscription-based & cross-system

processing for streamlined cross-product integration

• Eliminate trigger-based solutions or modification of standard code

• Simplifies implementation of custom programsDefine post-event actions in the Event Subscription to:• Pass information back to the system that originates

the transaction• Generate exception reports for trouble-shooting• Send notifications to users


Asset Business Event Triggers

Asset Addition

Asset Transfer

Asset Retirement


Summary

After completing this module, you should now be able to:• Describe the overall Oracle Asset Management

process from Setup through asset data flow to the General Ledger

• Identify the key functional areas that are part of Oracle Asset Management

r12 overview of oracle assets

Documents

general ledger

key functional

book controls

asset data

oracle asset

default ccid

financial

asset categories