Uploading Legacy Asset values
From: "Quinto, Joel" jquinto@ameritrade.com
Subject: Fixed Assets R11
Date: Thu, 29 Jul 1999 12:30:43 -0400 (EDT)
Hello,
I have two questions related to uploading legacy asset values to Assets:
1. Does Assets have a preference when asset values are loaded. For
example, an asset with a:
Cost $500
svc date of 14-Feb-95, current Open period Jul99
5yr life
STL, monthly period
depr accum $450
Should I enter the asset in Feb95, then run depreciation monthly all
the way up to the current period letting Oracle
calculate depreciation?
Or can enter the asset in the current period, enter accum amt and
run depreciation for Jul99?
Are there any gotchas in either method. Of course, I would prefer
the 2nd method, but will it calculate depr for the out
months correctly?
2. The other question relates to ADI. The values upload correctly to
Assets except Location flexfield and Expense account didn't show? My
version of ADI is 5.0.3.14.6. Is this a bug? I've opened a TAR with Oracle
just recently.
Thanks,
Joel
Date: Thu, 29 Jul 1999 23:17:19 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Fixed Assets R11
Hi Joel
The first method of upload will result in a discrepancy in depreciation with
you current setup. You will then have to perform an adjusting transaction to
adjust depreciation/NBV in Oracle FA to bring it in line with your current
setup.
The second method is advisable.
However, you need to consider statutory audit requirements if you are
mid-way through your financial year. You may want to create a custom report
on the legacy upload to meet these requirements.
Your question on ADI: I'll have to check this out. Give me a few.
Hope this helps
Ananth
Senior Applications Consultant
Date: Fri, 30 Jul 1999 10:23:39 +0530
From: sgupta@dfuture.com
Subject: Re: Reply: Fixed Assets R11
Hi Joel,
The first method definitely has problems.
If you manually enter the asset with accumulated depreciation in say July
99 with date placed in service in Feb-95,and then run the depreciation,the
system will not calculate for periods before July,99.I guess it assumes
that since you are manually populating the accumulated depreciation
field,it has to disregard the Date placed in Service.
The second method is therefore a better but with other problems.
If you enter the depreciation till date manually and then run depreciation
thro' the system,your depreciation calculations would be done properly but
on a later date if you want to do a cost-adjustment or reclassifiaction,the
system will make the manually entered figure zero and recalculate the
depreciation from the beginning.
Maybe a way out is to enter the asset in July99 with Date Placed in service
in Feb-95 and run the depreciation thro' the system.And if you have any
accumulated depreciation prior to Feb-95 which you want to book,you could
do that thro an adjustment entry in the period Aug-99,i.e if your company
policy allows it,because it will distort the year to date depreciation for
the current year.
The choice is yours to make..
HTH,
Shinu Gupta
Date: Fri, 30 Jul 1999 09:19:08 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply(2): Fixed Assets R11
Joel:
Shinu is right here. The point to analyse is this:
You need to go live in your system and ensure that the opening balances
correspond with your legacy system. And this is possible with the second
method. Ofcourse, in case of any adjustments in the "future", the system
will throw the depreciation figure out of sync.
You need to ensure that the balances in your proposed system and those in
your legacy system are correct and correspond. For this is the primary need.
In case of any differences occuring in future due to a cost adjustment (how
likely is it?) or a reclassification (Again - how likely is it?) one can
definitly evolve work arounds to deal with disclosure issues in so far as
stakeholders are concerned. I don't think you should be too concerned about
this at all.
Hope this helps
Ananth
Senior Applications Consultant
'Initial Mass Copy Execution Report' process ends with Signal 11 error
Date: Mon, 26 Jul 1999 15:51:00 -0400
From: "Challa, Anand" Anand_Challa@csx.com
Subject: Error during Process
Hi Asset Gurus,
During the Process of the Concurrent Program Initial Mass Copy Execution
Report,
the error reflected was ----
APP-00969 Program was terminated by signal 11.
On a normal frequency by month ... , this program was running fine.
I appreciate your help.
Thanks in advance
Anand .
Date: Tue, 27 Jul 1999 08:41:30 +1200
From: "Stu Keast" s.keast@niwa.cri.nz
Subject: Re: Error during Process
Hi Anand
Although you may have a problem with a lack of memory (check
this out with your DBA) I have found this problem in Assets to be a
data thing i.e. an asset may have something about it that the copy
program does not like. Try running in debug mode and review the log
file to see what asset the process dies on. This should provide a
clue where to look.
good luck
Multiple Set of Books in FA
Date: Mon, 2 Aug 1999 08:26:24 -0500
From: "Quinto, Joel" jquinto@ameritrade.com
Subject: FA: Multiple Sets of Books?
Hello again,
Thanks to Ananth and those who responded to my previous question. Here's
another:
We have set up our GL to have one set of book. The company has a parent and
at least 5 companies (subsidiaries). However, each company purchases its
own asset and would like to record those assets in their respective
companies. As Payables is set up similar to GL, what is my best option to
capture the data coming from payables. i.e., Payables is recording each line
to reflect the proper accounting flexfield, location, key etc.
We want to have multiple sets of books in FA to reflect each company then
close each of those companies each period and post to GL.
Questions: Would Payables accommodate the above scenario? Given that each
time it download info to Assets, the name of the set of books is required to
post to Assets. Also, how does Oracle "know" that with each closing process
from Payables that it must "post" to the company indicated on the invoice
line (location flex, accounting segment, etc)?
Thanks,
Joel
Date: Mon, 2 Aug 1999 10:11:37 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Subject: RE: Multiple Sets of Books?
Joel,
I have been working on a set up which is similar to yours. There is,
however, just one Corporate book in FA. The necessity to set up more than
one corporate book in FA arises when there is more than one GL set of books.
Otherwise, you can change the Flexbuilder default settings to make the FA
entries imbibe the values from the AP invoice distribution lines. When you
have one GL set of books, you will no doubt have a Balancing Segment( your
companies). You will be able to track assets by companies, through the
balancing segment.
The long and short of it is, you do not need additional Corp books in FA,
you do not have to set up anything in AP except to turn the Track as Asset
flag when it encounters a GL natural account which has been defined as an
asset and tailor your flexbuilder settings to suit your needs.
I hope I have been of help.
Gopal
Date: Mon, 2 Aug 1999 16:05:33 -0400
From: "Scott Frost" sfrost@noblestar.com
Subject: Re: Does Oracle Assets support multi SOBs?
Joel,
You might want to look at setting up Multi-Org for your applications
instance. Multi-Org upgrade will allow you to have multiple sets of books.
This is also helpful if you are doing any custom setups in HRMS related to
your unique organization structure.
Oracle has a white paper available at metalink support.oracle.com on
multi-org.
good luck!
Scott
Scott Frost
HRMS Consultant
Nobelstar Systems Corporation
703.464.4000 x2549
Date: Tue, 3 Aug 1999 09:16:24 +0530
From: Ashish Behera ABehera@usit.co.in
Subject: RE: Does Oracle Assets support multi SOBs?
You don't need to open the Corporates books company wise . By Using
Flexbuilders you can Get the Asset company wise posted to GL. However it
is possible if you have Company as one of the Key segments.
regards
ashish
Date: Tue, 03 Aug 1999 07:23:56 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Does Oracle Assets support multi SOBs?
Hi Joel:
From the description of your need, Multi-Org is NOT your solution. Infact,
far from it.
What you might need to do is to customise Account Generator (you will need
Workflow Builder for this). In Rel 10.7 SC you need to customise
Flexbuilder.
In case you do not want to get into customising Flexbuilder/Account
Generator - then you may have to define as many Corporate Books as there are
companies. Ofcourse a few other setup steps will also be necessary to
achieve the desired result.
Hope this helps.
Ananth
Senior Applications Consultant
Asset retirement transaction status
Date: Sun, 1 Aug 1999 15:34:59 +0300
From: Siva Siva@nrec.com.kw
Subject: Asset Retirement Problems
Dear All.
When ever you retire assets during the period the system process the
transaction with status as Pending before
closing the period or if you do not run Calculate Gains or Losses program.
Once you run the Calculate Gains and Losses program the system updates the
status as Processed.
This program will run automatically whenever you close the period or you can
run any time during the period.
When we are triying to retire an Asset, the system is retiring the Asset but
it is not updating the
status, when we are running the program Calculate Gains and Losses, it is
resulting in Error. But when we
undo retirement, the system is reverting the Asset status back.
When we tried to close the period the system is giving the same error and
not closing the period.
The Retirements program is not working properly.
Satish Josyula.
Date: Tue, 3 Aug 1999 16:04:07 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Subject: RE: Asset Retirement Problems
Check if you were trying to retire the asset in
1.the same period as it was added
2.a period prior to the date placed in service or
3.a period which is not open (i.e. a future period).
Gopal
Oracle Asset satisfies FERC requirements ?
Date: Mon, 02 Aug 1999 08:53:22 EDT
From: "Bankim Bhatt" bhatt_bankim@hotmail.com
Subject: Fixed Asset
Hi,
I am new to User group.
I need to find out whether Oracle Asset module can handle different
practises & methods necessary for FERC ( Federal Energy Regulatory
Commission ) property ?
Any help will be greatly appreciated - THANKS IN ADVANCE.
Bankim Bhatt
Date: Mon, 02 Aug 1999 08:23:30 -0500
From: William PLatt wplatt@csac.com
Subject: Re: Fixed Asset
What paticular practises are you refering to?
If you are talking about group assets in a regulated
environment, then Standard FA does not fit without
workarounds. You might want to investigate Oracle for Utilities.
Managing fully depreciated assets
Date: Tue, 10 Aug 1999 16:35:24 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Subject: FA:Fully Depreciated Assets
Hi FA users,
Can Oracle Assets handle the following business requirement:
Assets continue to be in physical use even after they are fully depreciated.
The accounting policy that is followed is to reduce the cost and accumulated
depreciation of the fully depreciated assets from the total cost and total
accumulated depreciation in the general ledger. However, the assets are not
retired in Oracle Assets and therefore continue to be included in the total
asset cost and total accumulated depreciation in Oracle Assets. This would
create a difference between the General Ledger and Oracle Assets.
Is there any way in which these assets can be excluded from cost and
accumulated depreciation so that I can avoid this difference? Has anyone
experienced a similar situation? Is there any work around?
Any help on this is appreciated.
Thanks in advance.
Gopal
Date: Tue, 10 Aug 1999 14:09:39 -0700
From: "Heman Randhawa" hRandhawa@mvsn.com
Subject: Re: FA:Fully Depreciated Assets
Well if you do not want the cost to be issue, then either change the
adjusted
cost to be 0. However, the acc dep will remain the same. Or retire the asset
and
create a new one with 0 cost and acc dep.
Heman
Date: Tue, 10 Aug 1999 17:59:06 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Subject: RE: FA:Fully Depreciated Assets
Thanks for your reply, Heman,
Your second option of retiring the asset and creating a new one with 0 cost
would work. Will it appear in the "Fully Reserved Assets Report"? Also, will
not the asset number change when you add a new asset?
Gopal
Date: Tue, 10 Aug 1999 17:58:09 -0700
From: "Heman Randhawa" hRandhawa@mvsn.com
Subject: Re: FA:Fully Depreciated Assets
Yes the asset # would change. However, just make a note in the Asset Tag #.
It
depends whether you are querying that asset by asset # or by Tag#.
Heman
List of Key Segment Values
Date: Thu, 12 Aug 1999 10:28:07 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
Subject: FA List of Key Segment Values
Can I run a report in FA that lists out my segment values for say major
and minor categories, instead of just exporting data into Excel?
Thanks,
Sue
Date: Fri, 13 Aug 1999 09:12:22 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: FA List of Key Segment Values
Hi Sue,
We are running 10.7 NCA. A standard report in FA
that will help is the "Asset Category Listing" which gives you all Asset
Category Combinations (e.g.: Land-Unspecified), Natural Account Segment
Values Dep Method, etc.
Thanks Much
:-) I used to have a handle on life, but it broke.
Craig Riffel
fa_reserve_ledger table populating
rom:
John Sweeney jsweeney@goaa.org Mass Additions - merge lines
Date: Mon, 04 Oct 1999 07:15:21 PDT
Date: Fri, 15 Oct 1999 16:12:44 -0400
10/15/99 2:06 AM
Subject:
[orafin] FA:Populating the FA_RESERVE_LEDGER table
To:
"'orafin@mail-list.com'"
How does the FA_RESERVE_LEDGER table get populated? The Oracle Assets
technical reference manual implies that when you submit a Reserve Ledger
Report, Oracle Assets deletes any data in this table before running the
report. Does the code used for this report include something that populates
this table prior to running the report?
Our goal is to generate a depreciation report that includes all assets (both
depreciable and non-depreciable).
GOAA is currently running version 10.7 SC161 of the following applications
on Oracle dbms 8.0.5/Sun Solaris 2.6:
Oracle Government General Ledger
Oracle Government Receivables
Oracle Government Payables
Oracle Government Purchasing
Oracle Project Billing
Oracle Project Costing
Oracle Inventory
Oracle Assets
Oracle Order Entry
Oracle Human Resources
Oracle Alert
Financial Analyzer 6.0
Discoverer 3.1
John Sweeney
GOAA, IT Department
407-825-3280
From: "Lakshmi Viswanath" lviswanath@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: FA- Mass Additions merging lines
Hi,
We have a spreadsheet that has over 2000 lines of small dollar amounts that
need to be merged into one asset. In other words they all should be visible
as lines for one asset inside Oracle.
The problem is, Mass Additions Post requires the asset numbers to be unique.
We don't want to do the parent asset concept.
As far as I can see, Oracle doesn't provide a control or shift click ,
select all option to merge many lines into one asset in the prepare mass
additions area.
Do I update fa_asset_invoices after the Post and fool around with the
tables? I am sure Oracle support won't be happy to hear that.
I will appreciate any thoughts, suggestions,
Thanks,
Lakshmi.
From: "Farber, Andy" farban@consumer.org
Subject: RE: FA- Mass Additions merging lines
Can you set them up as a Construction In Process (CIP), and merge the many
invoices that way? (We are using CIP to combine multiple invoices for
software development projects to a single asset.)
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531