Thursday, February 13, 2014

Assets Setup configuration / End to end configuration of Oracle Fixed Assets module

Oracle Assets streamlines operations and simplifies the management of capital investments,  automated business flows, calculate depreciations, managing fixed assets cycle and centralized accounting rules.  Oracle Assets also integrates with external non oracle systems to complete processing of asset transfers, disposals, reclassifications, financial and tax adjustments, and legacy data conversions.
I have produced here end to end configuration of Fixed Assets module. This module is SOB / Ledger based. I have covered even from Sys admin so that users can duplicate and practice to configure entire FA module. Reader should know how to configure GL book / Ledger to practice this.
Oracle Assets integrates with
Oracle Payables – Automate asset additions as part of the procure-to-pay process to interface depreciable capitalized assets.
Oracle Projects – Track construction-in-process project costs and capitalize them via integration with Oracle Projects.
Oracle General Ledger – Central repository ledger to gather accounting and report.
Oracle Application Desktop Integrator – Create assets and import physical inventory from spreadsheets.


Steps to configure FA
1
Define responsibility for FA – super user menu
Define this from Sys admin responsibility.
clip_image002
2
Attach GL book to your FA responsibility
Define this from Sys admin responsibility.
clip_image004
clip_image006
3
Configure 3 KFF - this is one per instance
Define this from Sys admin responsibility.
clip_image008
3 a – Category KFF
Always major category and minor category – two segments
Always major category – independent validation type
Always minor category – dependent validation type
clip_image010
Major category Flexfield qualifier
clip_image012
clip_image014
Minor category will depend on major category
Assets key Flexfield
clip_image016
Location Flexfield
clip_image018
4
Define values for major and minor categories
Define this from Sys admin responsibility.
clip_image020
Define value for major category
clip_image022
Defining values for minor category
clip_image024
5
Asset key Flexfield values
Define this from Sys admin responsibility.
clip_image026
6
Similarly for location Flexfield values – define values for country, city, state and building
Define this from Sys admin responsibility.
7
System control – one per instance
Define this in Oracle Assets module.
clip_image028
Grouping of 3 KFF and defining the assets number logic
Define the first automatic FA number and give provision for manual numbering (for data conversion from legacy to Oracle) while configuring the first auto number.
clip_image030
7
Define Fiscal year
Define this in Oracle Assets module.
clip_image032
Define the year based on the system control year
8
Define FA calendar
Define this in Oracle Assets module.
This name should be same as GL calendar name appears in GL calendar form
Attach FA fiscal year defined in earlier step while defining FA calendar
Always define at least one period before the first period put into use.
clip_image034
8
Prorate convention
Define this in Oracle Assets module.
The date when depreciation is to be calculated
clip_image036
9
Define Corporate book
Define this in Oracle Assets module.
clip_image038
Defining Assets book – Corporate book
clip_image040
clip_image042
clip_image044
clip_image046
10
Define depreciation method
Define this in Oracle Assets module.
clip_image048
Oracle by default will have seeded depreciation methods – WDV, formula, STL etc
clip_image050
11
Define assets categories
Define this in Oracle Assets module.
clip_image052
Attach major and minor categories to our FA book with depreciation method
Here we define assets category with – major and minclip_image054or categories, link to FA book and depreciation method, attach assets cost, depreciation account and asset clearing accounts.
clip_image056
Attach depreciation
clip_image058
Important points
There is no open and close period in FA – it is based on AP
There are three ways to create assets in FA – One create invoice in AP and transfer to FA. Second manually create assets in FA and third quick assets creation in FA. However, second and third options are not recommended as we are force to create again invoice manually in AP. Also capital project invoice can be created from PA to FA.

No comments:

Post a Comment