Asset Transfer
Date: Mon, 22 Mar 1999 10:11:10 -0400
Date: Tue, 23 Mar 1999 06:50:53 PST
Date: Wed, 24 Mar 1999 12:15:33 -0400
x-------------x
From: Suresh Chhabria [SMTP:chab_suresh@hotmail.com]
From: Palad, Ed (FUSA) [SMTP:EdPalad@firstusa.com]
From: Nicolas Woollaston [SMTP:NWoollaston@swichtec.co.nz]
Date: Fri, 14 May 1999 08:03:50 -0400 Periodic Mass Copy Extra Data To Tax Book
Date: Mon, 22 Mar 1999 16:16:11 -0800
From: "Ynes Coiscou, TRI"
Subject: FA: Error in Asset Transfer
Hello everyone:
I've been trying to transfer an asset and I 'm getting this error:
APP-48165 TRANSFER This user routine had ended with error.
APP-48260 Module TRANSFER USER EXIST had ended with error.
Has any of you found this error before? If so please share your experience
and how you solve it.
TIA
Ynes Coiscou
Analista Sistemas Financieros
MIS, TRICOM
ycoiscou@tricom.com.do
From: "Lakshmi Viswanath"
Subject: RE: FA: Error Transfering an Asset
This error message originates from the flexbuilder rule. Check default
rules for the cost and reserve account.
The code combinations and all the segments must be valid for the above
accounts in GL.There are 4 possible combinations you have to look into
being the cost and reserve acccount for the "from" and "to"
account.(rahter the new and old distribution)
You can do a flexbuilder test (from the Test flexbuilder screen)to
identify where the rule is failing to generate the ccid for all these
combinations.You can get values for the Test thru Help\tools\Examine or
by a simple sql to get ccids from fa_category_books
select ad.asset_number,
ad.asset_id,
cb.book_type_code,
cb.asset_cost_acct,
cb.asset_cost_account_ccid,
cb.deprn_reserve_acct,
cb.reserve_account_ccid,
dh.code_combination_id,
bk.flexbuilder_defaults_ccid
from fa_category_books cb,
fa_additions ad,
fa_book_controls bk,
fa_distribution_history dh
where cb.category_id = ad.asset_category_id
and cb.book_type_code = bk.book_type_code
and dh.asset_id = '&&asset_id'
and ad.asset_id = '&&asset_id'
and dh.date_ineffective is null
and bk.book_type_code in
(select bk1.book_type_code
from fa_books bk1
where bk1.asset_id = '&&asset_id');
If you are runnning Character you might get more detailed error message.
Hope this helps,
Let us know the results
Thanks,
Lakshmi Viswanth.
From: "Ynes Coiscou, TRI"
Subject: RE: FA: Error Transfering an Asset
Lakshmi:
Thanks for your answer. Yes! I execute the SQL and found a account
combination not active.
Ynes Coiscou
Analista Sistemas Financieros
MIS, TRICOM
ycoiscou@tricom.com.do
Subject: Asset Transfer Problem
Date: Thu, 22 Apr 1999 14:34:17 -0400 (EDT)
Hi
I'm doing an Asset Transfer. and when I saved my tran, it gives
me this error :
APP-47184 Depreciation for book FEDERAL TAX has failed, please
re-run depreciation.
Our last run on FEDERAL TAX book is causing an error when it was
last run. Since we are not
using this book anymore I did not want to run depreciation multiple
times until it runs without
errors (you know enabling accounts and flex_values).
But just to make to Asset transfer to work I did this;
update fa_book_controls
set deprn_status 'C'
where book_tye_code 'FEDERAL TAX';
After doing this my transfer works fine.
Is there any problem that will arise because of my doing this? I'm
still reluctant to
implement this in prod. Could somebody provide inputs.
10.7 Char.
Thanks,
Ed Palad
Consultant Oracle Financials, First USA
(302) 985-8591
EMail - EdPalad@FirstUSA.com
Sent: Thursday, May 13, 1999 3:48 PM
Subject: Re: Asset Transfer Problem
ED,
The most important advise is not to use sql plus whenever a problem
occurs.
As the whole ERP application is form based, any sql plus intervention
would not make it a possible solution to track the problem.
Suggestion would be to contact oracle support and undo what you have
done and redo the excercise. Probably there is something with the
depreciation run in the tax book which has a cue to the above problem.
Try doing mass transfer, and then individual asset transfer. If there
is a problem in both then the situation is serious, if either of
them are working, then the problem is localised to that concurrent
program.
Thanks,
Suresh Chhabria
sureshchhabria@yahoo.com
Sent: Friday, May 14, 1999 8:17 AM
Subject: RE: Asset Transfer Problem
Suresh,
I was happy I never had to do it. But Oracle got me the patch fix
and some sql updates
and it worked. Thanks I agree.
Ed
Sent: Thursday, May 13, 1999 4:41 PM
Subject: RE: Asset Transfer Problem
We sometimes need to use that update via sql if a deprn run crashes, in
order to allow a rerun. This is as per advice received from Oracle
support.
Nicolas Woollaston
Analyst Programmer
Swichtec Power Systems
New Zealand
From: "Palad, Ed (FUSA)" EdPalad@firstusa.com
Subject: RE: Asset Transfer Problem
Nicolas,
Oracle gave me a patch 732220 which will avoid this crashes.
Ed
From: Ron Chan
Subject: FA: Periodic Mass Copy Extra Data To Tax Book
Problem
A user of our fixed asset system was mass copying data from our corp
book to the tax book for fiscal year 1998. But instead of stopping after he
had copied Sep-98 (last period in fiscal year) into our tax book, he
continued and copied Oct-98 and Nov-98 into FY98 period of tax book (Oct-98
and Nov-98 data is supposed to go into FY99 tax period). Now we have assets
that are retired/adjusted in FY98 instead of FY99.
Has anyone had a similar problem? What did you do to resolve it so you
could get valid tax reports?
We are attempting to factor out the effects of the "extra" transactions
manually.
How it was supposed to work:
In our corp books we have 12 periods in the fiscal year from Oct-Sep.
In our tax books we have 1 period for the fiscal year from Oct-Sep.
For the 1998 fiscal year, the procedure would be to do 12 periodic mass
copies from Oct-97 to Sep-98 of corp book Fixed Asset data to FY98 period in
tax book. After Sep-98 is copied to tax book, we would run various reports
to verify that the data in the tax book "ties" back to the data in the corp
book. After everything checks out, we can depreciate tax book to close out
FY98 and open FY99.
After running tax reports and doing taxes for Fiscal 1998, we would then
begin copying data for fiscal 1999. Periodic mass copy Oct-98 to FY99, then
copy Nov-98 to FY99 and so on.
*********************************************************************
Ronald Chan, Financial Information Systems Department
Regency II, 1st floor Mailstop A13
Ph 415 472-2211 x26213, Fax 415 444-5033
E-Mail RonChan@FairIsaac.com
*********************************************************************