1
RAJU CHINTHAPATLA
Agenda
• Process Overview
• Integration with Modules
• Transactional Overview
Asset Addition
Asset Maintenance
Asset Retirement
Depreciation
• Capital Budgeting
• Physical Inventory
• Security
• Open Interface
• Reports
2
RAJU CHINTHAPATLA
R12 Fixed Assets
PROCESS OVERVIEW
3
RAJU CHINTHAPATLA
Process Overview
Adjustments Asset Additions Transfers
Manual Oracle/External CIP
Retirements
Online inquiry
Depreciation
Reports Taxes
Journal Entries
4
RAJU CHINTHAPATLA
R12 Fixed Assets
INTEGRATION WITH OTHER
MODULES
5
RAJU CHINTHAPATLA
Integration
Invoice Supplier
lines information
Oracle Payables Oracle Purchasing
Budget information CIP assets
Oracle
Spreadsheet Oracle Assets Projects
Journal entries
Employees Units of measure item
information
Oracle Human Oracle
Resources Oracle General Inventory
Ledger
6
RAJU CHINTHAPATLA
Integration with GL
Shared Information
Chart of accounts
Currency
Oracle Oracle
General Ledger Calendar Assets
Post entries
Journal entries
GL_JE_BATCHES sent
GL_JE_HEADERS
GL_JE_LINES
General Ledger tables
7
RAJU CHINTHAPATLA
R12 Fixed Assets
TRANSACTIONAL OVERVIEW
: ASSET ADDITION
8
RAJU CHINTHAPATLA
Asset Addition
Quick
Addition
Add invoice lines Detail
Addition
Mass Additions
Oracle Oracle Payables process
Purchasing or other system
Oracle Assets
Add CIP asset lines Run
depreciation
Oracle Projects
Create journal entries
Depreciation journal 9
RAJU CHINTHAPATLA
Manual Addition
10
RAJU CHINTHAPATLA
Mass Addition in 11i
Oracle
Payables
Oracle
ADI
Projects
FA Mass Additions FA_Mass_Additions
Legacy
System
Review
Mass Additions
Asset Category to
Default asset depreciation FA Asset Books
rules
11
RAJU CHINTHAPATLA
R12 Enhanced Mass Addition
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
RAJU CHINTHAPATLA
12
R12 Enhanced Mass Addition
Legacy Conversions
Web ADI template for Asset Mass additions enhanced to add additional columns
New columns added
13
RAJU CHINTHAPATLA
R12 Fixed Assets
TRANSACTIONAL OVERVIEW
: ASSET MAINTENANCE
14
RAJU CHINTHAPATLA
Asset Maintenance
Reclassification Adjust Financial
Info
Transfer Oracle Assets Unit change
Retirements
15
RAJU CHINTHAPATLA
Asset Reclassification
16
RAJU CHINTHAPATLA
Asset Transfer
17
RAJU CHINTHAPATLA
Mass Changes
18
RAJU CHINTHAPATLA
Mass Revaluation
19
RAJU CHINTHAPATLA
R12 Fixed Assets
TRANSACTIONAL OVERVIEW
: ASSET RETIREMENT
20
RAJU CHINTHAPATLA
Restriction on Retirement
Desired Action Can Be Performed When
Retire an asset The asset is in service in the current
fiscal year and was added in a prior
period
Reinstate an asset The asset was retired in the current
fiscal year
Reinstate partially an No transactions have occurred
asset since the partial retirement
21
RAJU CHINTHAPATLA
Mass Retirement
22
RAJU CHINTHAPATLA
R12 Fixed Assets
TRANSACTIONAL OVERVIEW
: DEPRICIATION
23
RAJU CHINTHAPATLA
Depreciation Rollback – 11i
Asset
Book
Rollback
Run Adjustment Depreciation Create
Depreciation required for for entire Adjustment
Asset Book
Run
Depreciation
24
RAJU CHINTHAPATLA
Depreciation Rollback – R12
Asset Adjustment
Book required for
Asset
Automatic
Run Create Rollback of
Depreciation Adjustment Depreciation
for asset
Run
Depreciation
(Adjusted asset)
25
RAJU CHINTHAPATLA
Depreciation Projection
Asset
Period 1:
$120,000
Period 4:
$60,000
Period
6: ? Depreciation
Projection
Estimated Report
Period 6:
$20,000
26
RAJU CHINTHAPATLA
What if Analysis
27
RAJU CHINTHAPATLA
What if Analysis
28
RAJU CHINTHAPATLA
R12 Fixed Assets
PHYSICAL INVENTORY
29
RAJU CHINTHAPATLA
Physical Inventory
Enter physical Run inventory View
inventory comparison comparison
Reconcile
differences
Update
assets
manually
30
RAJU CHINTHAPATLA
Physical Inventory
31
RAJU CHINTHAPATLA
R12 Fixed Assets
SECURITY
32
RAJU CHINTHAPATLA
SECURITY
Security By Book Functional Security
[Link] User access to Oracle Asset
[Link] a flexible hierarchy of asset Functions
organization [Link] your responsibilities to
[Link] a Responsibility depreciation restrict access
book [Link] Responsibilities to Users
[Link] Access to Each depreciation
book
Responsibility
Users
Manage assets
Run depreciation
and close books
View reports 33
RAJU CHINTHAPATLA
R12 Fixed Assets
OPEN INTERFACE
34
RAJU CHINTHAPATLA
Open Interface
FA_MASS_ADDITIONS
[Link] Asset from another
Mass Addition Interface payable system
[Link] from other
systems
FA_BUDGET_INTERFACE
Budget Open Interface 1. Upload Budget from External
system
35
RAJU CHINTHAPATLA
R12 Fixed Assets
REPORTING
36
RAJU CHINTHAPATLA
XML Reporting
XML reporting is available for major Asset Transaction reports:
• Asset Transfers Report
Major Asset Transaction reports modified to
• Transaction History Report
support XML publisher.
• Asset Reclassification Report
• Mass Additions Create Report Users can modify seeded templates or use new
• Cost Adjustment Report templates to view report output.
• Cost Summary Report
• CIP Summary Report
• Reserve Summary
• Journal Entry Reserve Ledger
• Asset Additions Report
• CIP Capitalization Report
• Mass Additions Posting
• Asset Retirements
37
RAJU CHINTHAPATLA
XML Reporting
Change report output Format to XML (in System Administrator
responsibility > Concurrent program definition)
38
RAJU CHINTHAPATLA
Text Output
39
RAJU CHINTHAPATLA
XML Output
40
RAJU CHINTHAPATLA
41
RAJU CHINTHAPATLA