Adjust cost values during Mass Copy
Date: Wed, 18 Aug 1999 10:35:34 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
To: oraapps-l@cpa.qc.ca
Subject: Fa Conversion-Cost/Accum Values
All,
We are about to begin the conversion of our legacy data into FA. Not
being a tax expert, I thought that I could set up my Corporate book and
then do the initial Mass Copy into each of our 4 tax books. Since, we do
not want Oracle to calculate our depreciation (tax people request), I
recognized that I would probably have to manually input the accum depc'n
values into ach tax book (4) for all 4,000 assets (Total = 16,000 assets-ouch).
However, now my tax people are telling me that the cost basis is
different on some of the assets in each of the tax books for various
reasons. When I do the Mass copy, am I allowed to adjust the asset cost
values as well?
Please help.
Thanks,
Sue
Amortization adjustments - tables where recorded
Date: Wed, 18 Aug 1999 18:11:18 -0700
From: "Raj, Chidanbara BGI SF" Chidanbara.Raj@barclaysglobal.com
To: "OraApps-L (E-mail)" OraApps-L@cpa.qc.ca
Subject: ? on Fixed Assets
Hi,
Anybody know the column in fixed assets tables to find out the assets on
which the amortization adjustment was done?
Found one as in FA_TRANSACTION_HEADERS with the subtype = 'AMORTIZED'. Is
this the only place where I need to
Check for the list of assets on which amortization adjustment was done?
Thanx in advance.
Date: Thu, 19 Aug 1999 12:28:15 -0500
From: April Stooksberry astooksb@csac.com
To: Chidanbara.Raj@barclaysglobal.com
Subject: Re: ? on Fixed Assets
Raj,
You can get the list from that table. Updates are also
made to FA_BOOKS (current record is "ineffective" dated and
new record is inserted with RATE_ADJUSTMENT_FACTOR, etc) and
I believe that FA_ADJUSTMENTS is also inserted into for this
type of transaction.
April
April Stooksberry Computer Systems Authority
Applications Practice Director 6380 LBJ Freeway Suite 181
(972) 960.0180 X264 Dallas, TX 75240
Handling Large Volumes
Date: Fri, 20 Aug 1999 12:03:08 -0500
From: April Stooksberry astooksb@csac.com
To: oraapps-l@cpa.qc.ca
Subject: Large Data Volumes on FA
My client is implementing several Oracle Applications including
Oracle Assets. We are implementing R10.7 NCA.
The client is in the hotel business so basically from
construction to operation, everything that is purchased for
a hotel (property) as well as the normal corporate assets
(chairs, desks, PCs) becomes an asset record in Oracle Assets.
We have been struggling with the conversion of the history
data and encountering problems in the applications with long
runtimes for jobs (Depreciation, Calculate Gains / Losses,
Mass Additions Post) as well as database issues like running
out of tablespace, running out of index space, and rollback
segments growing too "old" while a process is running. The
client will be converting 275,000 historical assets and will
probably add between 5,000 and 10,000 a month after we go
live.
Just wondering if any other clients running Oracle Assets
with this type of volume are encountering the same types of
problems (or even if any other clients have this level of
volume!).
Any information would be appreciated.
Thanks,
April
=============================================================
April Stooksberry Computer Systems Authority
Applications Practice Director 6380 LBJ Freeway Suite 181
(972) 960.0180 X264 Dallas, TX 75240
Coversion of assets - one Corp book to another
Date: Wed, 25 Aug 1999 17:51:45 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Subject: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Hi FA Experts,
I am trying to convert assets from our existing corp
book(OLD_CORP) to a new corp (NEW_CORP) book, both mapped to the same GL set
of Books. We extracted the asset information from several tables pertaining
to OLD_CORP and used SQL*Loader to populate the FA_MASS_ADDITIONS with the
Book Name as NEW_CORP.
The assets were populated in the FA_MASS_ADDITIONS table,
allright, but when I tried to post the assets or change any of the fields
like 'Description' or 'Category' etc., it gave an application error as
follows:
AP-48289 : UNKNOWN ERROR. PLEASE CONTACT YOUR SYSTEM
ADMINISTRATOR.
Next, I created and approved an invoice in AP and ran the
Mass Additions Create program. The first time, in the parameters, I gave
the name of the NEW_CORP. The concurrent request completed with an Error.
The request log read as follows:
APP-00606 : Cannot read value for Profile option
FA_CACHE_USAGE
APP-00606 : Cannot read value for Profile option
TIME_DIAGNOSTIC
Request ID xxxxxx
Processing Expensed Mass Addition
Number of Records Inserted : 0
Book: NEW_CORP
Request ID xxxxxx
Updating AP Distribution Lines brought over to FA system to
'Y'
Number of Records Updated : 0
Chart of Accounts = xxx
Mass Additions Update program is now updating the 'Posted'
AP Distribution lines which do not belong to Fixed Assets accounts to 'N'
APP-47270 Error executing an immediate SQL statement
Cause: You have a data base problem
Action : Contact your system administrator
APP-47340 ORA-00936 : Missing Expression
Debugging message to display the Oracle Error.
Number of Failures :0
However, when I gave the name of OLD_CORP in the parameters
of the Mass Additions Create program, the request ran with a status of
Completed and the invoice was populated in the FA_MASS_ADDITIONS table. But,
when I tried to post the invoice, I got the same error as before.
I set up the NEW_CORP exactly the same way as OLD_CORP, the
only changes being the CURRENT DATE field and the LAST RUN DATE (in the LAST
DEPRECIATION RUN zone) in the CALENDAR Alternative region in the Book
Controls form. The Current Date was one period earlier in the NEW_CORP as
compared to the OLD_CORP and the Last Run Date defaulted to the day I set up
NEW_CORP with hours as 00:00:00.
Can anyone tell me what is happening here that it will not
allow me to change any field in the Mass Additions form or post any of the
assets.
Any help or thoughts is much appreciated.
Thanks in advance
Gopal Krishna
Consultant-Mastech
Family Dollar Stores
Corporate Office
Tel: 704-847-6961 X4911
E-mail- gkrishna@familydollar.com
Date: Wed, 25 Aug 1999 23:10:54 -0500
From: William Platt wplatt@csac.com
Subject: Re: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Did you inactivate the old corp book and attach the
categories to the new corp book?
Date: Thu, 26 Aug 1999 09:12:12 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Cc: "'wplatt@csac.com'" wplatt@csac.com
Subject: RE: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Many thanks for your response, Bill.
Is it necessary to inactivate the OLD_CORP book? Can I not have two CORP
books active at the same time, both referring to the same GL set of books?
Where do I attach Categories to a CORP Book?
I am using the same categories for the NEW_CORP as I am using for the
OLD_CORP.
Gopal
Date: Thu, 26 Aug 1999 14:43:28 +0100
From: "Mark Smith" mark.smith@pdg-consulting.com
Subject: RE: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Gopal,
You can have more than one FA CORPORATE SOB active at the same time and you
can associated both with the same set of books in GL. I cannot comment on
your error with the Assets, but if you are having trouble loading Assets via
SQL*Loader, you can use ADI 5.0 to load them via Excel. (I have done this
recently and it works against 10.7 or 11). We did have trouble loading
assets into MASS ADDITIONS, but overcame this by posting directly from ADI.
You attach categories to a corporate set of books in the ASSET CATEGORIES
(navigate Setup-Asset System -Asset Categories), then in the bottom half
of the screen, enter details for each book.
On the old corp book, you should inactivate it to stop any postings to GL.
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: Thu, 26 Aug 1999 10:10:37 -0500
From: William Platt wplatt@csac.com
Subject: Re: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Oracle Allows only one Corporate book per GL set of books.
There is an implications that you need to inactivate the original
corp book. (I haven't been able to find it in the documentation,
I may have just missed it)
As far as attaching it to the categories, this is done in the category
set up just the same as any other book.
Hope this helps.
Bill
Date: Thu, 26 Aug 1999 10:20:11 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
Subject: RE: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
That is not true. I have 2 corp books attached to the same set of books. I
am encountering no problems. I am in 10.7sc 16.1.
I do agree that you should inactivate the old book, but just to make sure no
unwanted information from the old book gets into the gl.
Date: Thu, 26 Aug 1999 09:18:59 -0500
From: "Krzes, Joe" JKrzes@smith.com
Subject: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Not True for 10.7 character. We run multiple corp books that post to a
single GL SOB, but different Companies (balancing segment).
Joe
Date: Thu, 26 Aug 1999 10:56:32 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Subject: RE: CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
I want to thank everyone of you for your valuable inputs. As soon as I have
tested the conversion, I shall let you know how it went.
You have all been a great help!!
Gopal
Date: Thu, 26 Aug 1999 17:04:26 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Gopal:
This information is incorrect. Oracle Assets allows you maintain as many
Corporate Books as you like. However, since FA is segregated by SOB Id you
need to ensure that all these Corporate Books point to the same SOB.
You can use ADI to upload asset information into FA. You will find that this
method is much more simpler and convineint than SQL Loader.
You can setup Asset categories by book.
The Mass Additions process in AP will provide you the option of loading
information into any of the Corporate Books you have. And this is where you
need to exercise internal control procedures. Therefore, it will be prudent
to deactivate all other Corporate Books save one. Further, in case you need
any management reporting on parameters other than those which are used to
report in financial statements, you can make judicious use of Tax Books for
the purpose.
Hope the helps.
Ananth
Senior Applications Consultant
Date: Thu, 26 Aug 1999 19:31:18 +0200
From: Jean-Guy_Duba@ernst-young.fr
Subject: Re: Reply: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Agree with one of the last answer : you can have several FA corporate books
attached to the same SOB.
Coming back to the initial message:
1) Please carefully check if there is no discrepancies in the various FA
calendars and systems controls (oldest date placed in service).
2) Did you recreate all the FA keys combinaisons (Location and Asset keys)
before loading the extracted assets.
Regards.
Date: Thu, 26 Aug 1999 17:03:15 -0400
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Cc: "'Jean-Guy_Duba@ernst-young.fr'" Jean-Guy_Duba@ernst-young.fr
Subject: RE: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Merci Beacoup for your help, Jean.
On your first point, I have simply copied all the assets from the OLD_CORP
book to the NEW_CORP book. There are no discrepancies in Calendars or the
system controls.
On your second point, I did not understand your suggestion. Do I need to
create Location and Asset Key combinations, at all? I have used the same
combinations as are already existing. In any case, if I try to re-create
existing combinations, it will not allow me to create, saying that the
record/combination already exists.
I shall appreciate if you will explain what you meant.
Many thanks
Gopal
Date: Thu, 26 Aug 1999 14:34:47 PDT
From: "Harish K" har23@hotmail.com
Subject: RE: FA:CONVERSION OF ASSETS FROM ONE CORP BOOK TO ANOTHER
Gopal:
Just as a long shot... can you ensure that the asset numbers and tag
numbers are unique. What I mean is that you cannot have the same asset
numbering/tag numbering in 2 corporate books.
-Harish
Depreciation Reserve Values - upload legacy values
Date: Thu, 26 Aug 1999 15:48:33 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
Subject: Upload FA Legacy Depcn Reserve Values
All,
Thanks for all of the helpful info I've been getting for my FA implementation
already. I have another question about the upload of legacy data and
the subsequent running of the 1st depreciation in Corp Book.
We are on 10,7SC, Prod 16.1. Ultimately, had wanted to bring over
legacy assets with depreciation as of Sep99. However, our fiscal yr is
Feb99 to Jan00, so recognizing that we couldn't copy all assets from Corp
to Tax books until we close fiscal year, I have decided to load Accum
values as of 1/99 and then run depreciation in Oracle to see "how close we
get" to what our legacy systemhas calculated. (Acct'g doesn't want Oracle
to calculate depcn from beg of time)
My question is, if I manually added one asset into Jan99 and then ran
depreciation - does that leave the door open to then bring in all of my
assets at Sep99 and also give me the ability to copy all of these assets
into my Tax books, since I've now closed the prior fiscal year??? Or am I
forced to run depcn in Jan99 for ALL assets to be able to copy them into
the tax books??? I have a feeling the latter is the way I have to go but
I figured I'd ask the experts.
Thanks for your help,
Sue
Date: Fri, 27 Aug 1999 09:46:00 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Upload FA Legacy Depcn Reserve Values
Sue,
What we had done was to load our legacy assets via
the Mass Additions Table with the relevant YTD Depreciation & Accumulated
Depreciation as at the month end before the go live month, i.e. we went live
as at 01-Jun-99 and therefore loaded legacy as at end of May-99. (which
satisfied accounting). Oracle then calculates depreciation for the future.
Any discrepancies in the calculation Oracle will adjust in the last month of
the life of the asset.
Once we had closed of the first live period
(Jun-99), we ran a Periodic Mass Copy into the Tax Book. The problem here
was that Oracle saw these as new assets and as such we had to manually load
the YTD & Accumulated Wear & Tear (Tax Depreciation) in the Tax Book for
Jun-99, before closing off the Tax Book for Jun-99.
Hope this helps
Thanks Much
Craig Riffel
Date: Fri, 27 Aug 1999 10:19:59 +0100
From: "Mark Smith" mark.smith@pdg-consulting.com
Subject: RE: Upload FA Legacy Depcn Reserve Values
Craig / Sue,
We did exactly the same ! It works.
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
Depreciation run - APP 47169 error
Date: Fri, 27 Aug 1999 07:31:34 GMT
From: "GopalaKrishna Surapaneni" srisri47@hotmail.com
Cc: Rao_kvc@hotmail.com
Subject: FA:Depreciation Problem
Hi All,
When trying to run depreciation, the concurrent process terminates
with the following error status.
Error in log file: APP 48208
dist_ccid in fadoflx = 1224
h_rtn_ccid = -1
error: function fafbgcc returned failure (called from fadodlx)
error: function fadosgl returned failure (called from faxinaj)
error: function faxinaj returned failure (called from fadcje)
APP 47169: This asset has no distribution history information
APP 47125: The following requires adjustment but has
no distribution history information
Did I miss anything.
Thanks In Advance
Gopal
Date: Fri, 27 Aug 1999 19:08:41 -0400 (EDT)
From: satyam@sri.lanka.net
Subject: Re: FA:Depreciation Problem
Hi Gopal,
Check the value for the profile option, Validate flexfield on
Server.
Change the value from the Default value and then try.
Pl revert with results.
Prabu