Depreciation Run Error
From: Palad, Ed [SMTP:EdPalad@firstusa.com]
Sent: Wednesday, March 31, 1999 3:22 PM
Subject: Depreciation Run Error
Hello All,
I am having this error when I ran Depreciation Run Final for one of
the books;
Depreciation Program Exception Report
xx
xxCost Initial Journal Entry program completed
xx
xxAPP-00988 ORACLE error 1 in fadaid
xx
xxPrevious Messages (for Support Purposes)
xx
xxAPP-00406 No message explanation found for message '&MESSAGE'
xx
xx
xx
xxAPP-47661 Error: Unable to insert into FA_DEPRN_DETAIL table
xx
xx Cause: You have a database problem.
xx
xx
xx
xx Action: Contact your system administrator.
xx
xxError: function fadaid returned failure (called from faddep)
xx
mxError: function faddep returned failure (called from FADEPR)
I am running this for Book : FEDERAL TAX
Date : FEB-99
When I query Book Controls the last Depreciation Run : 10-FEB-99
Depreciation Run Status :
Error
However when I query FA_DEPRN_DETAIL using the following;
select book_type_code, deprn_source_code, max(deprn_run_date)
from FA_DEPRN_DETAIL
group by book_type_code, deprn_source_code;
I am getting for depreciation with a date of 30-Mar-99. I checked
that there
is no database or extents problems woth the table. I am thinking of
deleting
records that have a date of 30-Mar-99 and rerun, is this a good
option ???
Please help me. Thanks a lot in advance.
Ed Palad
Consultant Oracle Financials, First USA
(302) 985-8591
EMail - EdPalad@FirstUSA.com
From: Vallapareddy, Krishna [SMTP:kvallapareddy@noblestar.com]
Sent: Wednesday, March 31, 1999 3:44 PM
Subject: RE: Depreciation Run Error
Hi,
Were you able to run depreciation for Federal Books earlier? We had a
similar problem with our earlier client
and we diagnosed that depreciation needs to be run for the first period
of
the calendar year and then for the
succeeding months, we had actually brought in data for the previous
months
and years through mass additions.
Krishna Vallapareddy
Oracle Financials Consultant
Noblestar Systems Corporation
(703) 641-2778 ext 2508 or
(800) 470-4668 ext 2508
http://www.noblestar.com
From: Palad, Ed [SMTP:EdPalad@firstusa.com]
Sent: Thursday, April 01, 1999 1:41 PM
Subject: RE: Depreciation Run Error
Krishna,
You are very right, we did not for Jan-99, I still have to figure
out though how to
make this in sync. Did you had to update table FA_DEPRN_PERIODS to
make
the adjustments?
Thanks,
Ed Palad
Date: Fri, 19 Mar 1999 17:29:55 -0600
From: Sesha_Komaravolu@techsol.com
Just get the rollback segment value from your DBA and enter it there.
the problem should be solved.
Date: Thu, 1 Apr 1999 14:54:54 -0500
From: "Vallapareddy, Krishna" kvallapareddy@noblestar.com
Subject: RE: Depreciation Run Error
We tried everything but they did not work. We had to bring data upto Dec'98
through mass additions and
then run the depreciation.
shinu99@yahoo.com on 04/03/99 01:30:10 AM
Subject: DEPRECIATION RUN ERROR
When I run depreciation I get the following error.
Error: function fadcje returned failure (called from FADEPR)
Previous Messages (for Support Purposes)
APP-01756 Value CWS is not defined
APP-01929 FlexBuilder failed to generate a CCID for row 0 in fdfmap
CWS is a valid value for the cost centre segment.
Please help
Regards,
Shinu
Date: Sat, 3 Apr 1999 9:23:07 -0500
From: "Rosemarie H. Truman" Rosemarie.Truman@ey.com
Subject: Re: DEPRECIATION RUN ERROR
Hi Shinu,
This kind of error I've seen frequently in the apps, and it is usally a red herring.
1) Make sure all your manditory flexfieds are defined
2) Check the database to see if you've run out of 'TEMP' or 'SORT' space -- you usally get errors like this when the pl/sql package or c-routine fails and the error messages are not defined for database errors.
3) CHeck the underlying tablespace and extent sizes--normally when I get these kinds of errors, the program is generating data, and the underlying tablespace cannot extend the next extent.
Rosemarie Truman
Date: Sat, 3 Apr 1999 20:49:12 -0800 (PST)
From: gangadhar andru gangaa@yahoo.com
Subject: Re: DEPRECIATION RUN ERROR
Hi,
Look at the flexbuilder definitions. The error is normally associated
with one of the Flexbuilder functions and correct the flexbuilder rule.
You may like to look at the log file more closely.
Gangadhar
Depreciation - 1/2 year problem
Date: Fri, 26 Mar 1999 11:16:37 -0500
From: Scott_Thayer@stratus.com
Subject: FA: 10.7 Char 1/2 Year Depreciation Problem
Has anybody run into problems with 1/2 year depreciation?
We have had problems since converting to 10.7 char from 10.6, using any
method, but in particular 200DB.
About 50% of the time in the year that an asset is retired, it
does not take the 1/2 year of depreciation that it is supposed to,
but a prorated amount based on the month of the year, eg. Feb 3D 2/12
After testing, it does not seem to matter the month or year of
date placed in service, or month or year of retirement.
2 TARS have been openned for 2 weeks, and Oracle has not been
able to determine a cause or patch that would work.
We have applied patches 807256 and 696618, with no difference.
Version: 10.7 Char 16.0SC
OS: HP/UX 10.20
Thanks for any help
scott_thayer@stratus.com
Cutover for First Dep. run
From: Thornton, Steve (UK01) Steve.Thornton@UK.Honeywell.com
Date: Tuesday, March 16, 1999 9:23 AM
Subject: FA: Cutover Question
I'm familiar with several Oracle Financials modules, but not with
FA. This
FA question has just been fired at me from one of our FA
implementation
team. Can anybody help with the accuracy of this statement?
'.......
If we prepare the cutover data say at the end of June 1999 , and we
cutover
with data as at December 1998 , the GL Calendar and FA Calendar
will be out
of synchronisation until the 1999 data through the end of June hsa
been
entered . Depreciation through June 1999 will have been entered to
GL by
the
old Asset System , so therefore the Depreciation Journals for
January
through June will not be posted , but I assume it will not give
rise to a
problem that the two Calendars are not at the same date through
this period .....'
Many Thanks
Steve Thornton
Date: Tue, 16 Mar 1999 13:23:56 -0500 (EST)
From: "Suvir Arora" arora@suvir.freeserve.co.uk
Subject: Re: Cutover Question
Hi!
We have just gone live on FA this month. If you are loading Assets
for
period june99 then it is true that the depreciation from dec98
through june
99 will have to be up loaded from the legacy system.
How depreciation works in FA in a Nut Shell:
1.FA closes the period after depreciation for the period is run.
2. Run Create Journal program. it generate deprn. journals for the
period.
3. If you have to create journal entries and post them in FA from
dec 98
onwards then load your assets in the period dec98, by creating your
book
with starting period dec 98. run deprn for dec 98. Create you
journals for
dec 98.
4. In the first period it will create two journals 1. for asset cost
and 2.
for deprn for the month of dec.98. If the asset cost has been
already been
brought from the legacy system using GL journal import then delete
the asset
cost journal rather than posting them as it would create a duplicate
entry.
5. post the journal for deprn for dec.98.
6. run deprn. for all the periods through to jun 99. and post all
the
journals for all the months through to jun 99.
If you still have any doubts get back to me.
Suvir Arora
Apps Consultant
Mastech, UK.
From: jmcdonald@princesscruises.com
[SMTP:jmcdonald@princesscruises.com]
Sent: Wednesday, March 17, 1999 9:25 AM
Subject: Re: Cutover Question
I'd be careful about step 6 (but then maybe I don't understand it)
which says to
post all the FA journals thru to Jun-99. As I read your question,
Jan-thru Jun
FA activity (costs/deprn/reserve/will already have been converted from
your
legacy GL into Oracle GL.
What I've always done is use the Oracle deprn journals to reconcile to
what's in
the Oracle GL (and they will be different- even if only by pennies)
and adjust
it in the month of actual catch-up. And delete all the FA journals in
GL until
you catch-up.
And I've always loaded assets (except for the one time I had to trick
the system
into remaining value-remaining life calculations) in the first period
of the
current year. That way the YTD is 0 and you have the actual reserve
numbers
that were posted in the legacy system to load via the mass adds table.
jeanne!.
Date: Tue, 16 Mar 1999 18:56:31 -0500 (EST)
From: Schwerdt Mark MARKSCH@melbourne.vic.gov.au
Subject: RE: Cutover Question
I have always loaded assets into the last period of the previous year,
rather than the first period of the new year.
The reason for this is that your current year fixed assets reports will
then only reflect the new activity, and not the converted additions,
thus aiding reconciliation to the GL.
Consider a JUL-JUN fiscal year. Assuming that you have picked up
balances from the legacy system as of end JUN, you load these into the
corresponding JUN period in Assets. You then need to run deprn to roll
over the FA period into JUL. The trick to this is to ensure that JUN
does not calculate any depreciation (as this would have been accounted
for in the converted JUN deprn reserves). This is achieved by setting
the column FA_BOOKS.DEPRECIATE_FLAG to "NO" as part of the conversion,
running JUN deprn, then setting this flag to "YES".
Yes, this needs SQL*Plus to do so. The other gotcha can be when there
are converted assets where the DEPRECIATE_FLAG needs to remain as "NO"
post conversion.
Although this seems a bit messy, your FA reports and journals produced
for the new year will relate only to the post-conversion activity, so
you should be able to reconcile that year's activity to the GL much
easier. You can still use the JUN reports and journals (which you would
generally not post) to reconcile your conversion.
Mark Schwerdt
Frontline Consulting
Melbourne Australia
How NOT to Depreciate
From: Thomas Wieczorek (s) [mailto:twieczo@cap.org]
Sent: Friday, April 09, 1999 6:46 AM
Subject: Fixed Assets
We are implementing are Oracle Fixed Asset System. We are running 10.7SC.
We are using ADI 4.1 to load our information. We have set up the calendar
to go back as far as we need to. We were able to load are information, but
Oracle is going back and recalculating our depreciation. Does anyone know
if there is a step we missed or a flag we have to turnoff to stop Oracle
from recalculating depreciation on the historical data being entered?
Second does anyone know how Oracle treats a non-depreciable asset like land
and how does it need to be set up?
Your assistance is greatly appreciated.
Date: Fri, 9 Apr 1999 08:27:00 -0500
From: "Barker, Dave" DBarker@ENERGY.TWC.com
Subject: RE: Fixed Assets
Tom,
If you enter an amount for accumulated depreciation when you add an asset
FA will not recalculate.
To make an asset non-depreciable you turn the depreciate switch to off.
HTH,
Dave Barker
The Williams Cos.
Energy Services - Oracle FA Team
WS3 - 3West
Tulsa, OK
918-764-4810
Date: Fri, 09 Apr 1999 09:12:20 -0400
From: "Palad, Ed" EdPalad@firstusa.com
Subject: RE: Fixed Assets
1) Set the DEPRECIATE_FLAG to NO.
2) In the Asset Category where this asset belongs set Depreciate to No.
Maintain Dep. at detail level
Date: Fri, 18 Jun 1999 08:43:00 -0400
From: Wendy Thompson wpt9165@ritvax.isc.rit.edu
Subject: Fixed Asset
At the Rochester Institute of Technology, we have a critical need to
maintain depreciation expense at a detail level within the FA module (to
include both department/cost center and project) and at the same time
summarizing the transactions for posting to the general ledger. Our initial
understanding was that Oracle flex builder would allow us to accomplish this
most efficiently.
When we attempted this using flexbuilder, what posted to the ledger was what
was entered as the depr. expense combination at asset set up, not as it was
summarized by flex builder.
Is there a way to accomplish what we're looking for? Ultimately, we must be
able to use FA reports to show depreciation by department and project, if
applicable (detail in FA) and depreciation in the g/l must only reside in
the default department (15000) with no project number (summary).
Any thoughts you might have would be greatly appreciated. Hopefully there is
a way to accomplish through flex builder.
Thanks,
Wendy Thompson
RIT
Date: Fri, 18 Jun 1999 14:54:32 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Fixed Asset
Wendy,
In Flexbuilder, find the Depreciation Expense
Account for your books. Adjust the flexbuilder rules to pick up your Default
Department from another source, for example from the Default Flexbuilder
Account "Default CCID" or from the Asset Cost Accounts "Account CCID". As
another thought adjust the Depreciation Flexbuilder to use a 'Constant' --
the Constants value would be that of the Default Department.
(It's always a good idea to try it in Test first)
Hope this helps.
Many Thanks
:-)
Craig Riffel
System recalculating depreciation
From: oraapps-l@cpa.qc.ca [mailto:oraapps-l@cpa.qc.ca]On
Behalf Of Diane
Dial (s)
Sent: Wednesday, June 30, 1999 6:54 AM
Subject: capital assets
We do not what the Oracle Assets System to recalculate our
depreciation, but it does.
In setting up the books I have UN-X the allow revaluation,
allow amortized
changes, allow mass changes files.
Is there still something else I need to do?
Date: Wed, 30 Jun 1999 08:28:27 -0500
From: "Platt, Bill" Bill.Platt@atmosenergy.com
Subject: RE: capital assets
If this is an initial load, input LTD and YTD amounts when
loading the asset.
Importing accumulated Depreciation
Date: Sat, 03 Jul 1999 11:12:12 LKT
From: Sannidhi Kris sannidhik@hotmail.com
Subject: Data Migration for Fixed Assets
Hi Guys
Can any body tell me how to interface opening balances of Fixed assets in to
the assets module. My conceren is about accumulated Depreciation
Thanks in Advance
Krishna Sannidhi
Date: Sat, 3 Jul 1999 12:23:21 +0530
From: sgupta@dfuture.com
Subject: Re: Data Migration for FA
If you are trying to load historical data through either SQL Loader ,you
have to load the data in the fa_mass_additions table and from there import
in the system.For importing accumulated depreciation , all you have to do
is to populate the field
YTD_DEPRN and LTD_DEPRN.After this when you run depreciation in that system
,the depreciation will get calculated over and above the manually fed
figures.
If the assets are already in the system and you want to change the
accumulated depreciation figures, you could do it by passing an adjustment
entry in the form of Unplanned Depreciation.
HTH,
Shinu
Date: Tue, 6 Jul 1999 10:38:29 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: Data Migration for Fixed Assets
You can load balances into the FA_MASS_ADDITIONS interface table. There are
detailed instructions on how to do this in the 10SC Asset User Guide,
Chapter 2.
Reversing depreciation
Date: Tue, 6 Jul 1999 13:10:36 EDT
From: Luckie2000@aol.com
Subject: FA- Reversing depreciation ???
Hi,
Few days back there was a good discussion on the forum on deleting books or
all entries from the FA system (including SQL delete scripts). Has
anyone tried reversing a period's depreciation?
We have a tax book (thankfully doesn't hit GL) which is completing
messed on running January's depreciation. Can I delete all entries pertaining
to that period counter, date_effective from all relevant tables? Will that
do? How do I reset the current period back to Jan again? Is it by updating
Fa_boook_controls? I will appreciate any tips, tricks and experiences.
Thanks,
Lakshmi Viswanath.
Date: Wed, 7 Jul 1999 22:46:44 MYT-8
From: philip@aleytys.pc.my
To: Luckie2000@aol.com, oraapps-l@cpa.qc.ca
Subject: Re: FA- Reversing depreciation ???
I did that once on 9.4. I don't ever want to do that ever again. Please
think very carefully before doing this. I'd advise you that if there is
any other way, take it.
Having said that, it's very similar to deleting whole books except that
1. You don't delete the rows from the tables which actually define the
book itself.
2. I knew exactly when the user messed up so I used the CREATION_DATE
on some of the tables.
3. On 9.4 the active rows in the transactions tables is identified by
having the TRANSACTION_DATE_OUT and/or TRANSACTION_HEADER_OUT set to
NULL. You need to be very careful here.
4. You also need to be very careful when updating FA_BOOK_CONTROLS and
FA_DEPRN_PERIODS. In many places, Oracle financials doesn't care
about the hours/minutes/seconds in DATE type columns but you can't
assume this to be the case here. Make sure that in SQLPLUS or what
ever tool you are using, that the NLS_DATE format is set to include
HH24:MI:SS
5. Oh yes last but most important, if you ever do this HAVE YOUR DBA DO A
FULL EXPORT OF ALL YOUR FA TABLES before doing anything. Actally do
this twice.
Er, Good Luck, Vaya Con Dios, etc.
Philip
Date: Wed, 07 Jul 1999 18:04:23 PDT
From: Harish K har23@hotmail.com
Subject: Re: FA- Reversing depreciation ???
Hi lakshmi:
There are a bunch of updates that you will need to do:
1) Delete from fa_deprn_summary/detail tables for this book and this period.
2) Update FA_BOOKS.Pd_counter_fully_reserved to null (for assets that become
fully reserved in this period)
3) Update FA_BOOKS.adj_required_status to 'ADD' for assets added in this
period. You need to ensure that the cost_change_flag is 'No' and that the
new row was created by the depreciation run. Join this row with
fa_deprn_detail where deprn_source_code = 'D'
4) Update FA_BOOKS.adjustment_required_status for prior pd transfers.
5) Update FA_BOOKS.recoverable_cost. set recoverable_cost = adjusted cost
for assets added in this period without reserve.
6) Update FA_BOOK_CONTROLS --> period_counter and current_fiscal_year and
deprn_status
7) Delete from FA_DEPRN_PERIODS --> when depreciation completes it would
have created a new row for the next open period. You need to delete that
row.
8)Update FA_DEPRN_PERIODS.Period_Close_Date to null for the current period.
-Harish
Date: Thu, 08 Jul 1999 08:25:40 PDT
From: Lakshmi Viswanath lviswanath@hotmail.com
Subject: Re: FA- Reversing depreciation ???
Hi,
Thanks Harish and Philip for the tips. Our mass copy for Jan had nothing to
copy. So there was no transaction for that period in transaction headers
table and no rows in fa_books with the relevant date_effective. But I need
to make the period_counter_fully_reserved and period_counter_life_complete
null which has the Jan period counter in fa_books. Apart from that, there
are many rows in the fa_adjustments table for Jan and Feb periods. There are
all of source type 'Transfer'. I think its ok to leave them the way it is.
Thanks Guys, I appreciate your help,
Lakshmi
Date: Thu, 08 Jul 1999 09:15:46 PDT
From: Harish K har23@hotmail.com
Subject: Re: FA- Reversing depreciation ???
Hi Lakshmi:
Do not update any rows if you have already performed transactions. If
you have transfer rows in fa_adjustments created for Feb, and perform any
updates.. the chances are likely that the next deprn run will error out.
The period counters in fa_adj, fa_deprn_detail, fa_deprn_periods must be
kept in synch.
-Harish
Signal 11 error on running Depreciation
Date: Thu, 22 Jul 1999 23:09:10 +1200
From: "Stu Keast" s.keast@niwa.cri.nz
Subject: FA:Signal 11 when running Depreciation ;10.7NCA / Solaris 2.5.1/
7.3.4;
Hi all
We are running our fiscal year end Depreciation and the process is
failing with the (descriptive) Signal 11 error after completing Gains
and losses.
All the usual things have been checked ie Tablespace, Objects and
extents, Oracle messages, free memory cpu etc.
I have run in Debug and the process falls over at the same asset
(takes about 30 seconds) but I cant see any problem with it. (has
been around for some years and no recent changes) This is the first
time we have run a Year end with 10.7, Depen has run fine all year
so far.
Any suggestions most welcome
Regards
Stu Keast
M.I.S Manager
NIWA Ltd, Auckland. New Zealand.
Ph +64-9-375-2098, Fax +64-9-375-2092 Cell 025-731-280
Date: Thu, 22 Jul 1999 09:17:32 -0400
From: "Ynes Coiscou, TRI" YCoiscou@tricom.com.do
Subject: RE: Signal 11 when running Depreciation ;10.7NCA / Solaris 2.5.1/
Stu:
We had a similar problem last year running depreciation. I opened a TAR
with oracle support, the problem was a column on FA_BOOKS table. For some
assets Annual_deprn_rounding_flag had a value of 'NULL' and it should be
NULL. They also sent a patch to avoid future ocurring of the same problem.
Hope this help.
Ynes Coiscou
Sub Gerente Sistemas Financieros
MIS, Tricom
Tel. (809) 476-4622
Mail:ycoiscou@tricom.com.do
Date: Fri, 23 Jul 1999 11:40:36 +1200
From: "Stu Keast" s.keast@niwa.cri.nz
Subject: RE: Signal 11 when running Depreciation ;10.7NCA / Solaris 2.5.1/
Thanks for your help, much appreciated.
For others edification what happens is that when an adjustment is
done in FA a new record is created in FA_BOOKS. The new record
is supposed to have a NULL annual_deprn_rounding_flag.
However, the field is populated with the characters NULL and
consequently the process "spits the dummy"!
Easy to fix, update the field where it equals 'NULL" but get Oracle to
tell you to do it of course....
Ran it again and all is sweet, back to the beer and rugby.
I think this bug may have been introduced in Patchset D. E does
not fix it. There is a bug fix available #732032 to ensure it does not
happen again.
cheers