Mass Edits in Fixed Assets
Date: Tue, 13 Jul 1999 13:36:17 +0300
From: Andrei.Guseletov@Kvazar-Micro.com
Subject: FA:FA:Mass Edits in Fixed Assets
Hello all.
We are implementing Oracle Assets 10.7.
The old asset system is still alive and we need to bring its transactions of
Mass Edit (reassignments, etc.) over to Oracle FA. Does the programm
mechanism of such transfers exist?
Would appreciate any suggestions on the matter.
Andrew
Creating second Tax Book
Date: Tue, 13 Jul 1999 13:18:31 -0700
From: SCross@littonapd.com
Subject: FA Creating second tax book
We currently have one Corporate Book and one tax book. We need to separate
some of the assets which belong to a foreign office for our tax accountant.
We're thinking the easiest way is to keep everything in one Corporate book
but make two different tax books. Can we just create a second tax book? If
so, can we copy the foreign assets from the first tax book to the new one?
Or do we do a mass copy from the corporate book to the new tax book? If so,
how do we get rid of the foreign assets in the original tax book? Has
anyone tried anything like this or have any ideas?
Susan
scross@littonapd.com
Litton Aero Products
818 226-2637
Managing 2 Asset Clearing Accounts
Date: Wed, 14 Jul 1999 13:44:04 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: FA - Mass Additions C reate
Hi FA Experts,
I have created an Asset Category with 2 books. The Asset Clearing account's
for both books are different. I entered invoice transactions in AP using
both clearing accounts. When I run Mass Additions Create program in AP for
Book 1, it creates Asset lines even for Asset Clearing account - Book 2
lines. Further, I cannot edit the Book in the Prepare Mass Additions Form.
Is this a known problem. Is there any patch to resolve this issue.
Thanks in Advance.
Regards,
Chetan
Date: Wed, 14 Jul 1999 09:10:05 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Subject: RE: FA - Mass Additions C reate
Check to see if you have set up both books to relate to the same GL Set of
Books.
Gopal
Date: Wed, 14 Jul 1999 17:39:07 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: RE: FA - Mass Additions C reate
Gopal,
We have a single set of books in GL with 4 companies and 4 Asset books
pointing to the same GL Set of Book.
Thanks,
Chetan
How to create and use a FA calendar from 10 years back
Date: Thu, 15 Jul 1999 19:21:09 IST
From: "Michelle Smith" oracle_mot@hotmail.com
Subject: FA
Hi,
Could anyone help me with the calendar setup in FA?
I've setup the calendar from year 1999 in FA module, but should be around 10
years back, ie. 1989... the question is how should I reset it back and start
from 1989 calendar year?
Btw, I'm on 10.7 Character.
Appreciate any help or advise and Thanks a million for any reply.
cheers,
MS
Date: Fri, 16 Jul 1999 09:28:56 -0400
From: "Michael Licardi" mlicardi@divcomp.com
Subject: RE: FA
Michelle,
If you have already opened a period you cannot go back. You will need to
set up a new calendar.
Michael
Michael Licardi
Senior Consultant
Oracle Applications
Diversified Computer Consultants
904-332-7511
904-332-8210(fax)
Date: Sat, 17 Jul 1999 01:39:16 PDT
From: "Thomas Kuglen" tkuglen@hotmail.com
Subject: RE: FA
When you first set up FA, you need to specify the earliest placed in
service
date you will use. Your calendars need to be defined from that date.
From: Roger Drolet rdrolet@netscape.net
Reply-To: oraapps-l@cpa.qc.ca
Subject: Re: [FA]
Date: Sun, 18 Jul 1999 08:46:27 -0400 (EDT)
Michelle,
What did you define as your earliest date placed in service? I don't bel=
ieve
you can define a calendar that is prior to your earliest date placed in
service.
Roger
Date: Mon, 19 Jul 1999 19:53:39 IST
From: "Michelle Smith" oracle_mot@hotmail.com
Subject: RE: [FA]
Thanks Michael & Thomas for your useful info. It's getting on fine now.
Roger, what I did was the initial setup on the calendar in FA beginning
early this year without any other info or integration with other modules,
just to get it started and well... the earliest date placed in service which
by right should be years back, and my calendar was obviously started
incorrectly and could not be reuse... believe it? ;-)
ThanX and Cheers,
MS
FA and GL in diff currency
Date: Sat, 17 Jul 1999 16:46:01 +0800
From: Lee Joseph-EMLY54 Joseph.Lee.Tat.Kee@motorola.com
Subject: RE: FA
Can we set up Fixed Asset in one Currency and GL with other module is in
another currency? Has anyone has any experience on this that can share with
us? Thanks.
Revaluation of Assets with 0 %
Date: Mon, 26 Jul 1999 17:09:00 +0930
From: "Henwood, Sue" Sue.Henwood@boral.com.au
Subject: Asset revaluation with 0%
We have a problem where we are trying to revalue assets to comply with the
accounting standard for the revaluation of assets (ie must be revalued by
category every 3 years). Some of the assets need to be increased in value,
others don't, so we need to apply a zero % to the assets that don't.
However, the system will not write back the depreciation for those that
have not changed value but have still been depreciated. Oracle Support
tell us the software works OK, but we can't get it to work! I was
wondering if anyone has had any problems at all with revaluations of
assets or with the zero %? We are using 10.7SC Prod 16.1.
Calculate Gain & Loss program completes with Application error
Date: Thu, 5 Aug 1999 11:22:07 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: FA - Calcualte Gain & Loss program
HI;
We are implemeting Ora- Apps 10.7 SC 161 on WInNT 4.0. We are having the
following problem in Fixed Assets when the program Calculate Gain/ Loss is
run,
1 When I run the program, Calculate Gain & Loss, the program completes
error. It also generates a DR Watson error at server level, which is given
hereunder;
An application error has occurred and an application error
log is being generated
Faret.exe
Exception access violation (Ox0000005) Address 0x0034ecd0
2. The request log generates the following ;
For the log file please click here
3. We have modified the Flexbuilder. We also tried to run the program
with dynamic insert on, but the same error comes up.
Has anyone faced similar problem. The problem has been logged iwth local
support for quiet long, but still unresolved.
Shall appreciate help.
Regards,
Chetan Banglorewala
Account Generator giving problems
Date: Mon, 9 Aug 1999 16:39:40 +0300
From: Siva Siva@nrec.com.kw
Subject: RE: WIP: Remnants and New Items
Hi Everybody.
Have you configured Account Generator in FA.
I have modified the Account Generator Process in Vision DB
and now i have done the same configuration in TEST DB.
The system is not creating Accumulated Dep A/c, It is
charging to Depreciation Exp A/c both Debit and Credit entires.
Similarly when i transfer from one CC to Another CC, it is
not creating any entry with Values, it is simply giving amount as
ZERO.
My requirement is to get all the Segment Values except
Natual Account from the Distribution Given at Assignments level.
Is there any patch or something.
Has Anybody encountered this problem earlier.
Satish
FA Setup - mixed queries
Date: Wed, 11 Aug 1999 10:02:40 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
Subject: FA Tax Book Setup Q's-HELP!!!!!
All,
I have been reading some prior notes from the group on the do's and
don't of the FA Tax book setups. I have never worked with FA previously
and have no prior "tax" experience.
Environment Background: Oracle 10.7SC, Prod 16.1, Win NT. Other Oracle
modules include GL, AR, AP and implementing FA, INV and Cost by y/e.
The following are the current "hot" questions that my Tax dept has come up
with and I am writing to hear the opinions and "war stories" of those who
have lived thru this previously. Any and all comments are appreciated.
1) Depreciation Calendar and Frequency of running depreciation in
corporate book vs tax book? Currently we are looking at implementing one
corporate book and 4 tax books. Our current system (FAS 2000) gave us
this setup and allowed us to run depreciation monthly in the Corp book,
and only once per year in each tax book. However, the one big defference
is that the old system allowed you to "reset" depreciation if you made a
mistake in setting up an asset life/method etc.
My instincts tell me that no matter what system you're on, you reallly
should never re-run depreciation. However, because the old system gave my
users that ability they cannot understand why Oracle won't do the recalc.
I would like to setup our corp and tax books with same depreciatin
calendar. However, only run the depreciation for tax on maybe a quarterly
basis to catch any errors. And then be able to correct the errors before
year-end, instead of waiting until y/e to see that I have problems - after
I've already run depreciation.
2) Different Fiscal years for corp vs tax
Currently we are in fiscal yr 2000 in corp but only 1999 for tax, until
they complete the 1999 tax returns in Oct. Can I have my corp book at
Sep-99 but keep my tax book at Jan-99?
Or in other words, the tax group wants to bring over the accum depcn
values for each asset from my legacy system with Corp as Sep-99 and Tax as
Jan-99. Is that even possible?? I don't think this would work. I believe
that, if you don't want Oracle to calcualte your accum depcn for you for
any prior periods, you would have to bring over your asset accum values
all at the same time period. However, at this point, I'm not sure.
Please help.
3) 40% Asset addition tax rule?????
My understanding here is that the tax authority requires that you test
your asset additions by each year end to see if you have added 40% or more
of your physical assets in the last quarter. If yes, then you must recalc
depreciation by a "mid-quarter" convention for all assets. Has anyone
else dealt with this? Is yes, how do you set it up or prepare for it in
your setup?
Again, any help is appreciated.
Thanks,
Sue
Clarks Companies, N.A.
617-796-5021
Initial Mass Copy - Import of ITD accumulated values of Assets
Date: Wed, 11 Aug 1999 12:42:13 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
Subject: Initial Mass Copy requirements
Thanks for the responses so far on my 1st e-mail on FA implementation.
Follow-up on my FA Implementation questions from earlier:
1) Initial Mass Copy and Accum Depcn values from legacy -=20
Current setup is as follows:
FY 2000 in Corp book (FY 31-jan-1999 to 29-jan-2000)
FY 1999 in Tax Book(FY 01-feb-1998 to 30-jan-1999)
Want to bring over ITD Accum values for Assets into Corp book as of
9/30/99 b/c we prefer to NOT have Oracle calc Deprcn for 1st 9 mos for us.
But I keep reading that I have to CLOSE the FISCAL year before I can do
my initial Mass Copy into the Tax Books. Well, my fiscal year won't end
until Jan-2000 and the reason why we're going onto Oracle is because our
current tax system is not Y2K compliant, so I can't wait until Jan to do
my upload.
The other option is to load my corp book with accum values as of 1/99
(equal to tax) and have Oracle calc depreciation for me. I guess I would
then write off the differences from my current b/s amounts vs what Oracle
calculates. But would I have to do that on an asset by asset basis?? We
have about 3500 assets (not a lot but we don't have much time either)
Also, wouldn't I have to replicate all transactions I did in old legacy
for 1st 9 months - retirements, disposals etc??? We disposed of about
2000 assets in the 1st 6 months.
Help is appreciated.
Thanks,
Sue
Asset category setup issues
Date: Thu, 12 Aug 1999 11:25:53 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
Subject: Asset Cat Setups Q's
I am starting to put in my asset categories for the corporate book. When
I go to put in LAND.UNIDENTIFIED as a category, Oracle allows me to put in
all info and then in the default rules screen, even if I Unclick the
depreciate button, it still forces me to put in a depreciation method as
well as a prorate convention. Why?? if I've unclicked the depreciate
box?? Is it Oracle's way of making sure I go thru the entire setup no
matter what book I'm in???
Also, the date placed in service = date of my earliest asset. However,
even thought the manual says you can change this, Oracle tells me that the
field is protected against update. Why?
Thanks in advance,
Sue
Date: Fri, 13 Aug 1999 09:23:09 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Asset Cat Setups Q's
Hi Sue,
I would say that Oracle ensures you put in all
information necessary to run Assets because you could have an instance where
individual assets would not depreciate within a depreciating category or
where individual assets would depreciate in a non depreciating category.
The Date placed in service does necessarily equal
the Earliest Date as per the System Control Set up, and once you enter a
date in the category set up you cannot change this date afterwards. It seems
this date represents you open period in assets.
The date placed in service can be changed for live
assets once loaded/captured.
Hope this helps, let me know.
Thanks Much
:-) I used to have a handle on life, but it broke.
Craig Riffel
Date: Fri, 13 Aug 1999 09:10:44 -0500
From: James Aesoph jaesoph@ConAgra.com
Subject: RE: Asset Cat Setups Q's
Craig, In regards to the "date placed in service/earliest date" comment.
Are
you saying you can load assets that have an inservice date that is older
than
the system date. I have assets that date back to 1901 and I am dreading
setting
up the calendar and prorate conventions. If I can get around this by
setting up
the calendars and prorates for assets that are still depreciating, ie assets
with 40 year life, It would save some work.
Date: Mon, 16 Aug 1999 09:08:56 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Asset Cat Setups Q's
James,
What I meant was that when you set up your asset
categories the date you use could be any date after the Earliest Date as set
up in System Controls. In other words, if your Earliest Date is say
01-Oct-1901, none of your assets can have a Date Placed in Service before
this date.
I had in fact set up the calendar and a monthly
prorate convention from Oct-1941, but used the Excel Macro for SC.
Thanks Much
Craig Riffel
How to import asset costs and Depreciation along with adjustments from legacy system
Date: Fri, 13 Aug 1999 15:42:26 +0000
From: Patrick_Trinkwon@baa.co.uk
Subject: ORACLE Assets : Take on of Historical Data from legacy systems
We are about in implement ORACLE Assets need to bring in asset details from
the
existing system.
The existing system has in excess of 20000 assets the majority of which are
having their depreciation calculated by dividing the Net Book Value by the
remaining life.
Where a cost adjustment has occurred it has been added to the NBV prior to
calculating depreciation.
ORACLE assets does not hold NBV and we are therefore unable to replicate a
similar method of depreciation. If we bring in the historic data as it is
then
ORACLE Assets will calculate depreciation based upon cost and asset life.
Where
assets have had cost adjustments made to them [most have] the depreciation
charge calculated by ORACLE Assets will be in correct.
Has anyone got a clue how I can get the historic information in so that cost
and
depreciation will be correct?
Thanks in advance.
Patrick
Date: Mon, 16 Aug 1999 09:27:33 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: ORACLE Assets : Take on of Historical Data from legacy system
Patrick,
When you set up a depreciation method, you can
specify whether Oracle applies the rate to the Cost or the beginning of the
year NBV.
Thanks Much
Craig Riffel
Date: Mon, 16 Aug 1999 09:24:39 +0000
From: Patrick_Trinkwon@baa.co.uk
To: oraapps-l@cpa.qc.ca
Subject: RE: ORACLE Assets : Take on of Historical Data from legacy system
Thanks but I don't think that this helps me. As the depreciation is
calculated
by reference to remaining life then the rate would have to be changed each
period.
Example:
Take on:
Year 1 NPV = 10000
Remaining Life = 10 years
Depreciation = 1000
Rate = 10 %
Depreciation = 1000
Year 2 NPV = 9000
Remaining Life = 9 years
Depreciation = 1000
Rate = 10 %
Depreciation = 900
Am I missing the obvious?
Accidental Depreciation run on Corp Book
Date: Fri, 13 Aug 1999 10:26:48 -0700
From: "sean smith" kiowasean@zdnetmail.com
Subject: FA: Accidental run of Depreciation on Corp Book
Here is the scenario.
A user, intending to Run Depreciation for a TAX book for July 99, instead
ran for the Corp. Book for Aug 99.
The user promptly "TERMINATED" the job, knowing that letting it complete
would effectively "close" Aug 99 from future entry.
Oracle provided us a script that sets the Depreciation Status flag to
"Error" and should allow us to process Aug 99 business, however, the current
Create Mass Additions form, won't allow us to run the process (returns
"Depreciation Running, Try again later") without the application of a one
off patch, which we don't really want to install.
Without applying the patch to the Create Mass Additions form, does anyone
have any ideas how we can continue processing Aug business?
Date: Fri, 13 Aug 1999 11:32:28 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: Re: FA: Accidental run of Depreciation on Corp Book
Hi,
The following may be of help:
1.The concurrent request may still be running on the OS. If you can
kill the process it may be of help.
2. You can alternatively continue the depreciation and post it into gl
and reverse the journals in GL or modify the journals as gl allows you
to change the period name for the journals.
3.Then for the depreciated amounts you can add back the asset manually.
4.Till the time you run the depreciation on the corporate book again
you can manually add or modify the asset info. thereby avoiding the
prepare mass addition form.
Murthy.
Autonumbering of Assets in multiple FA books
Date: Tue, 17 Aug 1999 12:56:22 +0000
From: Seda.Siddikoglu@teba.com
Subject: FA Numbering
Hi,
We have totallly 6 FA books for two companies on our system. Each has 3
books on different currencies. But as we have only one system controls
set-up independent of the number of books, it seems that one unique
operator will be valid for all of my 6 books. Is this true or can I
differentiate automatic numbering among my FA books.
I would appreciate any answer.
Thanks
Seda
Date: Tue, 17 Aug 1999 13:20:50 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: FA Numbering
Seda,
We have virtually the same scenario and because the
Asset Numbering is set as Automatic Oracle is going to allocate numbers on a
'first come first serve' basis. I did not attempt to try and differentiate
the numbering (don't know if is possible) since I used the Location FF to
give me assets within each FA Book.
Date: Fri, 20 Aug 1999 11:18:00 -0500
From: William Platt wplatt@csac.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FA Asset Numbering
If you have only one GL set of books, then the automatic numbering
will be across all of the books. To avoid this you can give supply the
asset number and not let FA generate the number. (auto number
occurs only if you do not provide the asset number)
Hope this helps
Date: Tue, 24 Aug 1999 11:00:39 +0000
From: Seda.Siddikoglu@teba.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FA Asset Numbering
Hi William,
We have 2 GL set of books and each has three related FA books. Then can I
differentiate assey numbering across those two set of books?
Thanks in advance
Seda
Date: Tue, 24 Aug 1999 09:10:14 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA Asset Numbering
Seda,
As far as I know, the only way that asset numbering can be differentiated
across two different sets of books is by MANUALLY adding asset number in a
non-numeric sequence (e.g. A0001, A0002 ...) for one set of books and using
the asset numbering available in your system control for the other set of
books. Otherwise, Oracle Assets will be assigning an asset number in the
sequence defined in your system control, across your books on a first come
first served basis.
May I know why you need to identify the assets in your different sets of
books by different sequences? The asset number uniquely identifies EACH
ASSET. I am wondering why you need different sequences to identify assets in
different sets of books.
Gopal
Date: Tue, 24 Aug 1999 20:10:35 -0400 (EDT)
From: satyam@sri.lanka.net
Subject: RE: FA Asset Numbering
Seda,
Did You say you have 3 different FA Books in different currencies attached
to a single GL Set of Books. Tell me how did you do it? Cause, the FA Books
can have the transactions stored only in the functional currency of the GL
Set of Books. In case of you using MRC, the asset numbers will be the same
as the Original Base Currency FA Book.
Am i missing anything here!
Prabu
Setup of Prorate and Retirement Convention
Date: Wed, 18 Aug 1999 05:30:50 -0700 (PDT)
From: Ashok kumar_a_s@yahoo.com
Subject: Urgent in Fixed Assets (Calendar Setup)
Hi,
How do I set up the Prorate and Retirement Convention
if my requirement is as follows:
Our clients requirement is in the month of purchase,
the system has to prorate the depreciation for the
number of days in the month. In the last month of the
life, the system should not calculate any
depreciation. The month before the last month of the
life should take one and a half months depreciation.
For e.g.
Asset Cost = 12000
Life 1 Year
Date Placed in Service 16-Apr-99
Date of Retirement 15-Apr-2000
Following has to be the depreciation calculation
Depreciation for Apr 99 - 12000/12 * 15/30 = 1000
Depreciation for Mar 2000 - 3000
Depreciation for Apr 2000 - Nil
Can anyone help me in setting up the calendar.
Regards
Ashok
FA Implementation time
Date: Wed, 18 Aug 1999 10:03:05 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: FA-Implementation
Hi Implementation Gurus,
Can any one give me a clue about approximate time duration for implementing
FA (10.7 NCA Single Org and Single SoB)? At present the client is using a
third party system(Best Software system); I do not foresee any major
customization though.....
TIA
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Date: Wed, 18 Aug 1999 13:27:36 -0400
From: Wendy Thompson wpt9165@ritvax.isc.rit.edu
To: OraApps-L@cpa.qc.ca
Subject: RE: FA-Implementation
Rochester Institute of Technology is just finishing implementation of
Oracle Fixed Assets. We began January 1999. Our homegrown Property
Control System was the base for our conversion. We are running 10.7 NCA,
single organization, with one set of books. Oracle General Ledger,
Accounts Payable and Purchasing were already running.
This implementation was staffed by employees of RIT. We had some employees
assigned full time to the project (1 team lead, 1 systems analyst and 1
programmer). The rest of the employees were part time (1 project manager,
1 Financial Reporting analyst and 1 accountant). We also had an Oracle
consultant provide nine days of support over this period on an "as needed"
basis. Often, we found Oracle Support for FA to be "weak".
Hope this helps!
Wendy Thompson
Sr. Systems Analyst, Rochester Institute of Technology