Tuesday, August 25, 2009

Oracle Assets - Business Scenarios for CRP's

ADDITIONS :
Create Mass Addition via EPI AP (eg: Computer Equipment, vehicle, land, Office furniture)
Create Mass Addition via PA (EPI)
Create Mass Addition via ADI
Mass Addition (via PO with unit # greater than 1)
Mass Addition (via PO with item #)
Create Mass addition : Split a single invoice line to multiple assets
Create Mass Addition : Merge different invoice line to one asset
Create Mass Addition : Add to existing asset
Update mass addition information : serial number, tag number
Create Assets (post mass addition)
Add assets to subledger in detail
Add assets to subledger with quick addition
Additions of monthly Service Units and Metres (length of Services line) -

New units and metres
Relay units and metres
Adding Inactive Service record

ADJUSTMENT
Update descriptive information (eg description, serial number, model number, manufacturing number)
Updating quantity and costs for Mass Property accounts through AP.
Updating quantity for Mass Property accounts through other interfaces
Process adjustments to prior year asset costs
- asset-detail accounts e.g 472
- mass property accounts units and amount e.g. 475
Adjust NBV and accumulated depreciation

TRANSFER :
Transfer assets between LOB
Transfer assets between FA Book
Transfer assets between Employee
Transfer assets between Location
Mass Transfer between LOB
Mass Transfer between Employee
Mass Transfer between Location

RECLASSIFICATION
Reclassification (category)


RETIREMENT
Retirement on single asset (by cost)
Retirement on single asset with vintage pool
Retirement on single asset (by unit)
Mass Retirement by date place in service /vintage year
Mass Retirement by location
Mass Retirement by category
Mass Retirement from spreadsheet (ECG)
Mass Retirement by asset number
Retirement reversal of a single asset by cost
Retirement reversal of a mass property asset by units.
e.g: 475
Asset-detail partial retirement
FIFO retirement of mass property account
Mass retirement of asset-detail
- retire small tools and work equipment over 15 years
Retiring Inactive Service record

DEPRECIATION
Monthend closing – Depreciation Run
Change Depreciation rate
Review catch up depreciation calculation
Run/review journal entry reserve report
Add multiple depreciation rates
- 3 decimal places
Amortization of lease-hold account and computer software assets
Perform back-dated depreciation


PROCESS JOURNAL ENTRIES
Generate GL journal entries
Review Asset Addition JE, Transfer JE, Adjustment JE, Retirement JE, Depreciation JE

REVALUATION
Set up revaluation book
Run Revaluation (Midcoast/LPL)

INQUIRE ASSETS
Inquire assets based on category
Inquire assets based on location
Inquire assets based on employee
Inquire assets based on asset number
Inquire assets based on FA Book
Inquire assets based on historical project # (ie serial #)
Inquire assets based on storage tank unit # (ie. Manufacturer information)
Drill down to asset source detail
Cross referencing asset group
e.g. Land and building,
Calculate life-to-date, year-to-date and current month depreciation

YEAR END
Plant Asset year-end Allocations
Asset-detail Accounts:

1. allocate all miscellaneous costs within each
2. asset-detail account for current fiscal year.

Plant Asset year-end Allocations
Mass Property Asset Account Allocations

1. allocate all current year miscellaneous costs to current year installed service sizes within regions.
2. allocate all current year miscellaneous costs to current year installed main sizes within regions.
3. allocate all current year miscellaneous costs to current year installed sales stations within regions

Option: Use Project Accounting to handle the costs. (common cost)