Depreciation Overcharged
Date: Mon, 6 Sep 1999 16:51:12 +1000
From: admin@mdp.com.au
To: OraApps-L@cpa.qc.ca
Subject: Help Oracle Assets
We have a problem with some of our Assets where we have over depreciated
them
that is we have a Negative Net Book Value.The assets have reached the end
of their
usefull life for eg 3 yrs 8 months = 44 months.
How can I change the Net Book Value to be 0 if I can't change it through
the Applicattion.
Cheers,
Nigel Stewart
Mitsubishi Development Pty Ltd
Date: Mon, 6 Sep 1999 12:13:30 +0200
From: Craig Riffel CraigR@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Help Oracle Assets
Nigel,
You could 'correct' the depreciation taken by using the 'Unplanned
Depreciation' functionality. This would have the effect of correcting your
YTD Depreciation, Accumulated Depreciation and Net Book Value. You also have
the choice of entering either negative or positive amounts.
Navigate to Assets Workbench--Find the asset--Books--Unplanned
Depreciation.
Date: Mon, 6 Sep 1999 16:08:41 +0530
From: sgupta@dfuture.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Oracle Assets
Hi Nigel,
There are three ways in which you can bring your NBV to 0.
1) By changing the data placed in service.(i.e, you can postpone the DPIS
in such a way that it results in 0 nbv)
2) By changing the rate at which the asset has depreciated in such a way,
so that it comes to 0 NBV.
3) Change the YTD-Deprn,deprn_reserve in the fa_deprn_summary table from
the backend.
You cannot Use Unplanned depreciation in this case because it will not let
you enter any amount more than your NBV.
HTH
Shinu Gupta
Date: Mon, 06 Sep 1999 05:15:45 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Oracle Assets
Nigel,
Have u run the depreciation & posted journals to GL? If not, you can change
the depreciation rate to make the NBV 0.
Ravi
Date: Mon, 06 Sep 1999 17:06:45 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply: Help Oracle Assets
Hi
Just an addition. Take a decision prior to using Unplanned Dep. on whether
you would want the amount amortised or expensed within the period itself.
Not too sure about this: but I would suggest that you extend the life of the
assets too. However, this has other implications that may conflict with the
corporate financial policy.
Further, if you are on Release 11.0.2, Unplanned Depreciation is a bug. This
has since been patched. ButI would suggest that you look into this too. I
can't immediately recall the patch no. - but will let you know if you are on
a Rel. 11.0.2 instance.
Hope this helps
Ananth
Senior Applications Consultant
Date: Mon, 06 Sep 1999 10:07:56 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Oracle Assets
Hi Shinu,
I have never run unplanned depreciation. So I am not operationally clear.
From help I got the following line
"Unless you are entering unplanned depreciation for a credit asset, the
unplanned depreciation amount cannot exceed the net book value of the
asset."
What does it mean? In this case the asset value is in credit, so we should
be able to enter an unplanned depreciation higher than the book value?
Can anybody clarify please?
regards
Prasanna Jena
Date: Mon, 06 Sep 1999 17:23:58 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply(): Help Oracle Assets
Hi Prasanna
I would assume that you can enter a negative amount as the unplanned
depreciation.
I have used this to perform normal adjustments. But to use this to rework an
asset cost whose NBV is zero - the ideal method will be to perform a
revaluation. However, it is possible that a few companies may not perform
asset revaluations due to the financial policy in force. In such a case, it
does seem possible that unplanned depreciation can be used. The catch being
- enter a negative amount. Or so I think. Frankly, I haven't tried it. But I
think this should work.
After thought - Another way could be to perform an adjustment.
I don't have access to a demo instance here. Could you let me know if this
worked? I'll try this out too soon enough and get back on the results.
Thanks and hope this helped.
Ananth
Senior Applications Consultant
Date: Tue, 7 Sep 1999 09:25:58 +1000
From: admin@mdp.com.au
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Oracle Assets
Hi Shinu,
The assets in question have reached their maximum life in months ie 3 yrs 8
months & we are stuck with a huge negative NBV for a lot of assets.
Would you please explain how we can change the YTD-Deprn,deprn_reserve in
the fa_deprn_summary table from sqlplus.
Thanks for your help.
Regards,
Nigel Stewart
Mitsubishi Development Pty Ltd
Date: Tue, 7 Sep 1999 09:41:56 +1000
From: admin@mdp.com.au
To: oraapps-l@cpa.qc.ca
Subject: RE: Help Oracle Assets
Craig,
What version of Oracle Assets is this functionality as we are on 10.7
Character Mode?
Thanks,
Nigel Stewart
Date: Tue, 7 Sep 1999 09:43:57 +1000
From: admin@mdp.com.au
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Oracle Assets
Ravi,
Yes we have run Dep'n BUT we don't interface with GL we only create dummy
GL entries.
Thanks,
Nigel Stewart
Mitsubishi Development Pty Ltd
Date: Tue, 7 Sep 1999 08:46:06 +0200
From: Craig Riffel CraigR@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Help Oracle Assets
Nigel,
We are on 10.7 NCA
Date: Wed, 8 Sep 1999 10:10:21 +0530
From: sgupta@dfuture.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Help Oracle Assets
Hi Prasanna,
Credit Assets have to have negative cost.In the case Nigel has
mentioned,the assets seems to have positive cost and has depreciated beyond
its useful life.So, in this case to make nbv 0,one ill have to enter
positive unplanned depreciation.This is something system would not allow as
it would be greater than the present nbv. Unplanned Depreciation feature is
available from 10.7 (GUI) onwards.
HTH
Shinu Gupta
Historical Data upload
Date: Wed, 1 Sep 1999 16:26:30 -0400
From: "Bill Keenan" billek@ccai.net
To: "Oracle Forum" OraApps-L@cpa.qc.ca
Subject: FA Historical Data Upload???
Hi,
I am beginning the process of researching how to extract historical data
from our Fixed Assets legacy system (FAS), and uploading it to Oracle
Assets. I am hoping to get some suggestions/experiences from people who
have successfully converted assets. We have an estimated 20,000 assets we
would like converted from our legacy system to Oracle, including monthly
depreciation. My questions:
1. Is it possible to upload these assets/depreciation thru ADI?
2. If not, does Assets have an API which I could SQL Load?
3. If not, is it the norm to write a PL/SQL conversion program and load the
assets/depreciation
directly into the Oracle tables?
Thank you in advance for you help/guidance.
Bill
Date: Thu, 02 Sep 1999 07:38:38 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FA Historical Data Upload???
Bill,
We are also converting from FAS2000 into FA. I'll try to answer your
questions but recgnize we are literally in the middle of testing ADI vs
SQL loader to upload, so I'll try my best.
1) We are on 10.7SC, Prod 16.1 and using ADI 5.0. All documentation says
that in ADI 5.0, the "Create Assets" feature should NOT work, however, I
saw it work just the other day at another site. I'm trying my own "test"
today and will let you know. In ADI create assets, you are given the
ability to create a template with fields like YTD Depreciation and
Depreciation reserve, incase you wanted to bring in the FAS depreciation,
instead of having Oracle calculate it for you.
2 + 3) In our initial load of about 50% of our Assets, we used SQL Loader.
We followed the steps in the Oracle Assets manual on what fields are
required, but you can also figure this out by seeing what is requred for
the ADI upload. Unfortunately, I don't have all of the technical info -
I'm the functional user here.
I'm fortunate to only have about 3500 assets to load but will have 5 books
(1 Corp and 4 Tax). If you'd like to talk more about conversion or asset
implemetation strategies, please feel free to give me a call.
Good luck,
Sue
617-796-5021
Date: Thu, 2 Sep 1999 08:48:37 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA Historical Data Upload???
Hi Bill,
Recently I converted Assets using SQL Loader. It worked fine for me.
FA_MASS_ADDITIONS is the interface table that you need to populate with the
assets you are converting. There are certain required fields that need to be
populated for the conversion to work. You will have to generate your
sequence of Mass_Addition_Id which is the primary key for the table. Besides
the Mass_Addition_Id, you will also have to populate
Expense_Code_Combination_ID, Payables_Code_Combination_ID, Location_ID,
Asset_Category_ID, Tag_Number, among other columns. If you choose to allow
Oracle Assets to assign the asset number, you should leave the field blank.
Tag numbers have to be unique.
The value for the Queue_Name and Queue_Status should be 'POST'.
Ensure that all the Quickcodes Columns have appropriate values.
I had posted a problem last week and Mark Smith
(email-mark.smith@pdg-consulting.com) had written saying he used ADI 5.0 for
conversion. It appears that it had worked fine for him.
Your third option will not be supported by Oracle. It is advisable that you
do not load directly into the tables.
Hope this helps.
Gopal
Date: Thu, 2 Sep 1999 10:41:54 -0400
From: "Bill Keenan" billek@ccai.net
To: "Oracle Forum" OraApps-L@cpa.qc.ca, suel@wma.clarkshoe.com
Subject: Re: FA Historical Data Upload???
Hi Sue,
Thank you for your help/suggestions on this. I'm going to look into ADI
here (we don't even have it installed yet). Please let me know how your
testing goes with regards to uploading the assets thru ADI. We will have
the data in excel, so obviously it would be nice if we could upload thru
ADI.
I may call you in the next week or two to discuss any issues we encounter
(I'll keep it brief). I appreciate the offer.
Again, thank you for your help.
Bill
Date: Mon, 6 Sep 1999 12:37:19 +0200
From: Craig Riffel CraigR@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FA Historical Data Upload???
Hi, Bill
Just to add to what Mas has said, you could also load you YTD Depreciation
and Depreciation Reserve.
And once again,it is advisable that you do not load directly into the
tables.
Date: Mon, 6 Sep 1999 16:15:07 +0100
From: "Mark Smith" mark.smith@pdg-consulting.com
To: oraapps-l@cpa.qc.ca
Subject: RE: FA Historical Data Upload???
Bill,
I have loaded Assets via ADI 5.0 as well. We are on 10.7 prod 16.1 on NT.
One problem encountered is that we cannot currently load the assets into the
Mass Additions table to view them before posting to the Asset Register - we
have to Post them directly, which works fine.
One drawback with loading assets via ADI 5.0 is that you cannot load the
Life_in_months for each Asset. The system wil default in the life from the
Asset Category. We overcame this by changing the life through SQL (too many
assets to go into the Asset Workbench for each).
Hope this helps.
Regards
Mark Smith
PDG Consulting Ltd
5 St. Johns Lane
London
EC1M 4BH
Tel: 0171-250-4736
Fax: 0171-250-4737
http://www.pdg-consulting.com
Date: Mon, 06 Sep 1999 17:13:46 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply: FA Historical Data Upload???
Hi
ADI works fine in Relase 11 too. No problems as yet. Ofcourse in an MRC
enabled install, this can become quite a nag. But there are workaronds to
the problem. The bottomline being - ADI is certainly a very useful tool now.
Ananth
Senior Applications Consultant
Date: Tue, 7 Sep 1999 10:47:25 -0400
From: "Bill Keenan" billek@ccai.net
To: oraapps-l@cpa.qc.ca
Subject: Re: FA Historical Data Upload???
Mark,
Thank you for your help/comments. I am pursuing the ADI route as we
speak!!!
Thanks again,
Bill
Mass Copy - Close FY of Corp Book
Date: Tue, 07 Sep 1999 02:59:32 PDT
From: "simon daniel" ora_apps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: FA: Mass copy
Hi ,
how do we close the fiscal year for different corporate books in FA.?
I have defined a corporate book for fiscal year 1997 and one tax book for
year 1998. I have added assets to the corporate book and i am doing a mass
copy (initial) to the tax book. the system gives me a error message saying
"You have not closed the fiscal year for the associated corporate book".
Appreciate if anyone could lead me beyond this.
Thanks
Daniel
Date: Wed, 8 Sep 1999 10:17:05 +0530
From: sgupta@dfuture.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FA: Mass copy
Hi Simon,
You can close fiscal periods in Assets only by running depreciation for
that period.Till the time you run depreciation for the period and close it
,you will not be able to run mass copy to tax books.If your first period in
tax books is 1998 and in your corporate book 1997 is open,then you have to
first close 1997 and then 1998. After this you will be able to run
mass-copy to your tax books.
HTH
Shinu Gupta
Account Generator - customize
Date: Thu, 9 Sep 1999 11:24:04 -0400 (EDT)
From: satyam@sri.lanka.net
To: OraApps-L@cpa.qc.ca
Cc: Sinteract@listbot.com
Subject: Customization of Account Generator in Fixed Assets
Hi All,
I have a doubt in customization of Account Generator in Fixed Assets.
Capital Budgeting Porcess of the client requires that the asset cost
account journal entries should capture the respective cost centers from the
assignments in the asset level and not the single cost ceter (default) as
specified in the Asset Categories.
By default, Oracle Assets creates journal entries without cost center level
detail, except for depreciation expense. Using the default assignments, it
creates journal entries using the balancing segment from the distribution
line in the Assignments window and the account segment from the asset
category or book, depending on the account type. For additions entry, it
picks up the asset cost account cost center from the respective asset
category.
Therefore the account generator need to be customized to pick the cost
center from the assignments (depr. expense assignment) at the asset level
for creation of journal entries affecting the asset cost account, instead
of the corporate cost center in the asset categories. I would like to know
what all standard report will be affected by this customization.
Kindly let me know what impact will it have on what all standard reports.
Your comments are requested ASAP.
Thanks in anticipation.
Alok
Date: Thu, 9 Sep 1999 08:10:59 +0200
From: Zaman Joan ZamanJ@mail.europcar.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Customization of Account Generator in Fixed Assets
Account generator is written a way that it is supposed to be customized.
All you need to do is change the workflow process and/or create a
corresponding pl/sql package ... done in the proper way you would not
have to change any reports ...
Hope this helps.
Joan Zaman
Zadra Consulting
+32.496.41.99.22
Transfer of asset - Inter Location
Date: Fri, 10 Sep 1999 19:13:54 LKT
From: "Sannidhi Kris" sannidhik@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FA - Tfr. of assets from one location to another - balancing
segment - error
Hi,
I am having a problem in posting journal entries relating to transfer of
assets from one location to another where the location segment is the
balancing segment. The following are the details:
Brief History
· Changed the assignment from one location to another location and provided
the new account assignment - by making changes to the location and cost
center values for the particular asset in the Assignment Form. (Please note
that the location segment in our set of books is the balancing segment).
· Thereafter, ran corporate and tax depreciation which worked out fine (per
a review of the pertinent reports in Oracle Assets).
· Transferred the Journal entries to the G/L.
· Upon query of the journal entry for the month (specific to transfers),
noted that some lines relating to the transferee location - specifically
cost, accumulated depreciation (for the new assignments) and "transfer
intercompany AR and/or AP accounts" were not reflected, though the journal
entry was balanced. The following error message appears:
APP-00588: Program error: An error has occurred while looking up a flexfield
segment combination. Please inform your support representative that:
The FND_FLEX_SERVER validation function has encountered a null or negative
combination ID (-1) while trying to look up the segment values for this
combination. This may indicate an invalid entry in the unique ID column of
the combinations table.
On posting the transfer entry, the following information is available in the
Concurrent Report though it is successfully completed:
Error: Invalid Journal Entry Lines
Line #: Accounting Flexfield does not exist
Line #. Accounting Flexfield does not exist
Question:
If somebody has encountered this problem, please let us know why this error
is occurring and what changes are required. We are using default
flexbuilder accounts. It is possible that this problem may arise once again
if we were to sell/retire an asset to another location. Please advise
a.s.a.p.
Date: Fri, 10 Sep 1999 14:41:32 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'sannidhik@hotmail.com'" sannidhik@hotmail.com
Subject: RE: FA - Tfr. of assets from one location to another - balancing
Hi Kris,
If you have used a new combination, I would check to see if a valid
combination for the new location exists. If there is no combination and =
if
your dynamic inserts is not checked, there may be ni CCID for the new
combination.
Another thing which I can think of is whether your new combination =
violates
any cross validation rule.
HTH