Loading of Exchange rate variations on assets
Date: Sat, 01 May 1999 04:20:54 -0700
From: "Saranath P" saran_p@mailcity.com
Subject: FA : Loading of Exchange rate variations on assets
Hi all,
We have a large volume of assets which have unpaid foreign currency(FC) component. At the end of each period, the unpaid FC liability has to be revalued and the difference has to be loaded on all the assets which were created from the invoice. Currently we have approx 500 assets on which this kind of loading has to take place on every month. The unpaid FC portion has been captured in the Asset Key Flexfield in one of the segments.
Has anybody worked on automating this process by which cost adjustment lines can be created and brought to the Mass addition table?.
We are on Apps 10.7.
Thanks in advance
Prabu B
Date: Sat, 1 May 1999 17:47:23 +0530
From: "Madhavi Ghodke" madhavi@pn2.vsnl.net.in
Subject: Re: Loading of Exchange rate variations on assets
Try Option of 'Add to Asset' thru Prepare Mass Addition Form.
You will get the Queue Name as Cost Adjustment.
Hope this works.
Do tell me know.
Madhavi
Date: Sat, 1 May 1999 21:27:10 +0400
From: PeriasamyR@mashreqbank.com
Subject: Solution for Loading of Exchange rate variations on assets
Dear Prabhu,
We had faced this situation before and we have done it as a functional
workaround for more or less a simillar no. of assets lines. We had entered
the increase in foreign currency liability due to revaluation as a invoice
against the respt vendors, with the distribution pointing to a few of these
assets clearing accounts ( CIP Network Equipment, which were imported GSM
base station kits). These were then interfaced to FA, where this line was
split in the reqd. ratio and/as well as by certain pre-determined values and
added to the respt. assets. Note that unlike in your case, we had the
outstanding values against the assets maintained manually in spreadsheets.
The description of the lines clearly indicate that these were due to
currency revaluation difference of the outstanding amounts of original
invoice lines.
You can extend the idea further, and later even bring down the asset value
due to say a downward fall of outstanding invoice liability by entering a
credit note.
We had these requirements esp. in India, to conform to accounting standards.
Hope it helps
Date: Sat, 1 May 1999 21:31:44 +0400
From: PeriasamyR@mashreqbank.com
Subject: Oops...RE: Solution for Loading of Exchange rate variations on asset
Ooops, I forgot, we did these sort of cost adjustments on a annual basis,
and not monthly like in your case. So what I had suggested may not be
efficient if done monthly !!!! BTW, are the impact of doing so monthly as
compared to annually so material ? In our case this was required only at the
time of finalizing their published accounts. For monthly reporting, the
increase in foreign currency component of the invoice liability is provided
for, but the actual assets costs or depreciation were not adjusted.
Regards
Peri
Mixed Queries
Date: Sat, 01 May 1999 23:12:55 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
Subject: Re: FA
9:17 AM 5/2/99
Hi FA Gurus!
i am implementing Fixed Assets for the first time & i have the following
queries:
1). How do you update opening balances & the tables involved?
2). When running the Mass addition from payables module the FA module is not
getting updated. Have we not categorised FA items as capital items? What
other aspects need to be reckoned in the purchase module?
3). Where do you update FA items sale? We have Cash module also & how to
integrate this transaction?
4). Can we delete the items totally from the Fa module?
Thanks in advance for your assistance.
Ravi
Date: Sun, 2 May 1999 17:21:18 +0400
From: PeriasamyR@mashreqbank.com
Subject: RE: FA
Hello Ravi,
1) You could use the Mass Additions Interface table to load opening balances
of assets and accumulated depreciation into FA.
2) Check to see if the Invoice Distribution lines point to an Asset Clearing
account - i.e. has been specified as a Asset or CIP Clearing account in any
of the FA Asset Category setups. Mass Additions import would only consider
Invoice lines having Asset or CIP Clearing account distributions for
transfer to FA.
3) Accounting for sale of assets are handled though clearing accounts -
"Proceeds of Sale" account in the Book or Category setup. (pls check as I
forgot where). Later in AR you could enter the receipt pointing to this
clearing account or even use a manual GL journal to clear it against cash
recd. Cash module, which I assume is Cash Mgmt module is not relevant here
as it used only for reconciling bank receipts and payments.
4)Subject to certain restrictions, you could delete assets from FA module.
You could also purge old assets which are completely written down if you so
wish.
Hope these 'broad' hints help.
Regards
Peri
Account Generator never completes
From: Logan, Ernie Ernie_Logan@bmc.com
Date: Monday, May 03, 1999 11:43 AM
Subject: FA: R11 Account Generator never completes?!?!
Is anyone else having a problem with the FA Account Generator never running
to completion even after running for days? We finally end up killing the
process after days of execution at 100% of a HP K580 processor. It seems to
generate a few thousand accounts at most.
We just completed our R11 upgrade. We will be running depreciation
(hopefully) later this week. OWWS is no help whatsoever.
---
Ernie Logan, Jr. | She put me on Earth to accomplish
Ernie_Logan@bmc.com | a certain number of things. Right
(713) 918-3649 | now, I'm so far behind, I will never
918-1313 (FAX) | die.
From: Richard [mailto:oraapps1@prodigy.net]
Sent: Monday, May 03, 1999 11:25 AM
Subject: Re: R11 Account Generator never completes?!?!
Yes!! We have the same problem on an NT platform. It works sometimes, and at
other times fails, running for hours and hogging the whole CPU. Have you
got depreciation running in debug mode? Try turning it off and resubmitting.
Also, check that you have your rollback segment defined in your fixed assets
profile option, and that you have debug mode off for the account generator
option. Also, clean up the workflow debug tables - we found 350000 records
in the trace table, and when we cleaned that up it worked better the next
time round.
If you come up with a better solution, please let me know, we are still
battling, and are going live next week.
Date: Mon, 3 May 1999 13:22:43 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: R11 Account Generator never completes?!?!
Well, I found the debug mode for Account Generator as a system profile
option. It was not set, so I don't know for sure whether it was defaulting
to Yes or No. I haven't found a debug setting specific to depreciation. We
do have the rollback segment defined now, but did not the last time we ran
Generate Accounts.
Do you have a specific table name for the workflow trace table, and can it
simply be truncated, or how does one "clean it up" safely?
Thanks for the thoughts. We will try again. I'll keep you informed.
Date: Mon, 3 May 1999 14:07:07 -0700 (PDT)
From: Jason Chan jchan14@yahoo.com
Subject: RE: R11 Account Generator never completes?!?!
To clean up the data in the Workflow table, you can run a concurrent
process called "Purge Obsolete Workflow Runtime Data Process" from Sys
Admin. If you have the Debug mode set to yes, it is a good idea to
schedule this program to run on a regular basis.
Jason Chan
Account Generator not working
Date: Wed, 23 Jun 1999 01:31:55 -0400 (EDT)
From: wastu@iname.com
Subject: Account Generator in Oracle Asset
Hi all,
anybody has experience implement oracle asset in Rel 11?
I'm implementing oracle asset right now, but I have difficulty to get
account generator to work properly. The manual said that account generator
use workflow, and I have to setup the workflow before the account generator
can work. Anybody knows how to setup workflow embeded in Oracle Applications?
Thanks alot
Date: Wed, 23 Jun 1999 11:20:53 PDT
From: Thomas Kuglen tkuglen@hotmail.com
Subject: Re: Account Generator in Oracle Asset
A default Workflow process for FA Account Generator should be set-up when
the applications are installed. You can view the name of this process from
FA at Setup\Financials\Flexfields\Key\Accounts. Under the Item Type "FA
Account Generator" you should see something like "Generate Default Account."
If you need to modify Account Generator you will need to use Workflow
Builder which is a separate tool outside of Oracle Applications. I think
the latest version is 2.0.
The Generate Default Process should create journals as described in the
Oracle Assets documentation except that it will use the cost center in
Category-level (i.e. balance sheet)accounts. Has anyone else found this
error? I have found that the default uses the Distribution CCID for the
cost center segment in the Generate Category Account process when the
Default CCID should be used.
ADR Tax calculation
From: James Aesoph [mailto:jaesoph@ConAgra.com]
Sent: Friday, June 11, 1999 2:26 PM
Subject: FA - ADR Tax calculation
Oracle Assets does not support the calculation for ADR Tax depreciation.
Has
anyone found or know of a workaround? ADR is a group depreciation election
for
assets added between 1971 and 1981(alot of special rules and election can
never
be reversed).
Date: Mon, 14 Jun 1999 09:41:33 -0500
From: "Barker, Dave" DBarker@ENERGY.TWC.com
Subject: RE: FA - ADR Tax calculation
James,
We had the same problem and there is no perfect solution. You can get
Oracle to use ADR lives and methods and get the correct depreciation. The
problem is the way retirements need to be handled for ADR, (proceeds added
to reserve, etc). We are taking the position that every asset is it's own
vintage account and so gain or loss is recognized when you retire it. In
our case most ADR assets were close to or fully reserved and retirements are
not that frequent anyway. If you want more details give me a call.
Dave Barker
The Williams Cos.
Energy Services - Oracle FA Team
WS3 - 3West
Tulsa, OK
918-764-4810
Mass Transfer of assets other than by cc or loc
Date: Tue, 15 Jun 1999 14:25:28 +0800
From: "Solomon, Stephen" Stephen.Solomon@rac.com.au
Subject: Mass Transfer of assets
Hi all,
I was wondering whether anybody had developed a way of mass transferring
assets by a way other than by cost centre or location. We would like to do a
mass transfer by category but it does not seem to part of the standard
functionality of 10.7 16.1 GUI.
Thanks in advance
Stephen
Stephen Solomon
Systems Accountant
RAC Group
Phone: +61 8 9421 4394
Fax: +61 8 9421 4545
Email: Stephen.Solomon@rac.com.au
Date: Tue, 15 Jun 1999 07:29:06 PDT
From: Thomas Kuglen tkuglen@hotmail.com
Subject: Re: Mass Transfer of assets
Asset categories are the primary way in which accounting information
(accounts) and depreciation rules (methods, life, and convention) are
assigned. Changing categories is considered a reclassification and it will
have a significant accounting impact. I assume this is not what you want to
do but instead only you only want to change the location or cost center of
all the assets in a category.
As far as I know there is no standard functionality in any release to do
this since in standard FA there is no reason for all assets in a category to
share a location or a cost center. In fact, in most systems this will not
be the case.
Date: Mon, 28 Jun 1999 13:23:18 GMT
From: Suresh Chhabria chab_suresh@hotmail.com
Subject: Reply: Mass Transfer of assets
Hi Solomon,
Since assets are assigned to category, I think you can find out
1. All asset numbers assigned to particular category and then
write a custom routine to masstransfer the same.
2. Use the mass transfer form to transfer from the asset number
to the asset number having the transferable category.
Customization of the requirement is the solution,
hth,
Suresh
Asset addition using ADI in MRC Book
Date: Wed, 16 Jun 1999 01:59:46 -0400 (EDT)
From: wastu@iname.com
Subject: Asset addition using ADI in MRC Book
Hi All,
any body has an experience of using Oracle ADI to load asset into MRC books?
I tried, and it won't work
Any suggestion?
Thank a lot
Wastu
E-mail:wastu@iname.com
Date: Wed, 23 Jun 1999 09:35:27 PDT
From: Thomas Kuglen tkuglen@hotmail.com
Subject: Re: Asset addition using ADI in MRC Book
ADI does not work with an MRC enabled system because Oracle has not provided
a way to load the new FA_MC_MASS_RATES table with ADI. (The
FA_MC_MASS_RATES table provides the exchange rate used when the asset is
copied to the MRC book.) In our opinion, this is a bug but Oracle, or at
least the ADI product group, does not plan to fix it. We are checking with
the MRC product group to find out if they will take a different position.
The work around is to run a SQL script which can be obtained from Oracle
Support. The script prompts for an exchange rate and the system ID of the
FA book (not the BOOK_TYPE_CODE) and then populates the FA_MC_MASS_RATES.
We have modified the script to prompt for BOOK_TYPE_CODE instead of the
system ID and we have registered it as a standard request so that it can be
run by a user from within the applications. This is a better solution but
still not ideal and hopefully Oracle will enable ADI/FADI for MRC in a
future release.
FA reinstall
Date: Wed, 23 Jun 1999 14:41:24 -0400
From: "Cotten, Jim" Jim.Cotten@respironics.com
Subject: RE: FA Reinstall
We have completely hosed up fixed assets thru a combination of changing
calendars, Oracle's undocumented features, and attempts to fix problems
using SQL Plus. At any rate, Oracle won't attempt to help as they know
that the tables were touched using SQL Plus and we have a mess.
Question is, can I deinstall FA, reinstall FA, and reimport all assets
as of June 1st without affecting the other installed modules (GL, PO,
AR, INV, etc.)? I can get a listing of the assets to import as of May
31st if this is possible. I would appreciate any advice.
Jim Cotten
770-423-2353
Date: Wed, 23 Jun 1999 16:47:28 +0100
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: FA Reinstall
I've done this sort of thing a couple of times during test/conversion in
10.7. I have a script from Oracle that resets all the tables for a book (I
included it below) If you have tax books- you'll have to do it more than once.
You may also have to adust the depreciation in the tax books after you get it
copied and depreciated
It will be a lot more complicated if you've done a lot of asset adjustments
(incl adding source lines (from AP) to existing assets) since Oracle doesn't do
a remaining value-remaining life depreciation easily. We had to play around
with unplanned depreciation of $.01 to force an update to the rate adjustment
factor in fa_books.
I'd never thought about it before but maybe you even want to think about leaving
the bad data out there for history and just setting up a new set of books. If
you do, make sure the new mass additions (from AP) will point to the new set of
books.
Before doing anything:
1. Ensure all of your mass adds records have been processed-
2. Ensure all journals have been processed to GL
3. Make sure you have the data required to populate mass adds again
I'm probably (actually there's no probably about it) forgetting something so
test, test, test
jeanne!
Below is the script that will delete all the assets and the book
information for a specific book:
delete from fa_additions a
where a.asset_id in
(select distinct b.asset_id
from fa_books b
where b.book_type_code = '&book_name');
delete from fa_asset_history a
where a.asset_id in
(select distinct b.asset_id
from fa_books b
where b.book_type_code = '&book_name');
delete from fa_asset_invoices a
where a.asset_id in
(select distinct b.asset_id
from fa_books b
where b.book_type_code = '&book_name');
delete from fa_transaction_headers
where book_type_code = '&book_name';
delete from fa_distribution_history
where book_type_code = '&book_name';
delete from fa_books
where book_type_code = '&book_name';
delete from fa_adjustments
where book_type_code = '&book_name';
delete from fa_deprn_summary
where book_type_code = '&book_name';
delete from fa_deprn_detail
where book_type_code = '&book_name';
delete from fa_retirements
where book_type_code = '&book_name';
delete from fa_invoice_transactions
where book_type_code = '&book_name';
delete from fa_mass_changes
where book_type_code = '&book_name';
delete from fa_mass_transfers
where book_type_code = '&book_name';
delete from fa_mass_revaluations
where book_type_code = '&book_name';
delete from fa_book_controls
where book_type_code = '&book_name';
delete from fa_deprn_periods
where book_type_code = '&book_name';
delete from fa_category_books
where book_type_code = '&book_name';
delete from fa_category_book_defaults
where book_type_code = '&book_name';
delete from FND_FLEXBUILDER_ASSIGNMENTS
where function_code like '&book_name %';
delete from FND_FLEXBUILDER_FUNCTIONS
where function_code like '&book_name %';
delete from FND_FLEXBUILDER_parameters
where function_code like '&book_name %';
delete from FND_FLEXBUILDER_params_tl
where function_code like '&book_name %';
Date: Wed, 23 Jun 1999 17:31:56 PDT
From: Harish K har23@hotmail.com
Subject: Re: FA Reinstall
Hi Jeanne:
Script is fine but maybe a warning that Oracle will not support if
anything goes wrong should be mentioned.
Couple of things that came to mind:
1) If journals are processed to GL, how do you prevent them from going again
from the new sob? Aha!!! you would need to populate fa_deprn_periods,
detail ... with dummy je_line_ids.
2) They may not have an option of leaving it for history purposes as
transfers are not allowed between books ... and so it will not show up in
the new SOB.
BTW: Are you the same Jeanne who "used" to call Oracle Support?
Regards,
Harish Krishnamurthy
Date: Wed, 23 Jun 1999 18:23:21 +0100
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: FA Reinstall
ohmigod-what a surprise- yes it's me-and I STILL call Oracle support and, more
importantly, I STILL send cookies! anyway how are you? where are
you(working?)- (write offline- no need to bore these good people anymore)
and I didn't mean to imply transferring between the books- I meant just to leave
it there for information only since it sounded like he didn't want to re-create
all the transactions (only the balances)
and to respond to your 'aha'- I'd prevent the journals from going again by doing
the same thing you(I?) do at conversion which is to create and then delete them
in the GL before posting since they're already in the GL (ususally from the
conversion (only this time from the 'hosed' book) )
but
hey folks- this guy (Harish) is the true FA guru- who six/seven? years ago
taught me most of what I know about assets
jeanne!
Date: Thu, 24 Jun 1999 07:30:02 -0400
From: "Cotten, Jim" Jim.Cotten@respironics.com
Subject: RE: FA Reinstall
Thanks Jeanne. We are continuing to investigate the problems. It seems
that most of the current out of balance problems were cost by transfers
of items that were fully depreciated (we are consolidating cost centers
and doing mass transfers).
Loading Asset information and Geneal Ledger balances
Date: Sun, 13 Jun 1999 11:49:14 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: Re - Loading Asset information and Geneal Ledger balances
Hello GL/Assets experts,
We are implementing Oracle GL and FA at one of our client sites, Just want
to share some views with the experts. We plan to load the legacy asset data
with Cost, depreciation for the year and accumulated depreciation
information. We observe that If existing assets with cost, current year
depreciation and accumulated depreciation information is added and
depreciation is run, system generates journals only for asset cost addition
and current month depreciation.
Hence if we are implementing to start live from say 01 Aug 99, the GL Asset
Cost balances for July-99 should be loaded as under;
Asset Cost - Post balance to Cost Clearing account
Depreciation for the year - Post to depreciation account
Accumulated depreciation - Post to accumulated depreciation account.
Also in the Asset book definition, the current period should be Aug -99 and
last depreciation run should be 31-JUL-99.
Hence, when you create journals from Oracle Assets for Aug-99, the asset
cost clearing account will be nullified and the asset cost account will be
debited.
Shall appreciate comments on the above or any alternative suggestions to
load data.
Best regards,
Chetan Banglorewala
Date: Mon, 14 Jun 1999 17:07:54 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Re - Loading Asset information and Geneal Ledger balances
Chetan,
What we've done at two of our sites was to upload
assets from the legacy system using the Mass Addition Interface Table (as
used by the Payables interface). We made sure the last depreciation run date
was 30-Jun-99 and loaded assets as at the end of Jun-99 i.e.: The GL was
live for Aug-99 but Assets was still in Jul-99. This allowed us to make any
adjustments and add in any CIP Assets etc. Once balanced to the legacy
system we ran depreciation and created the journals (the GL Period for July
should be open).
What this allowed us to do was to post this journal
and to reverse it immediately because the Asset Cost, CIP Cost, Accumulated
Depreciation and Deprecation balances were already loaded into the GL.
Many Thanks
:-)
Craig Riffel
Mass Additions from AP Invoices
Date: Wed, 23 Jun 1999 11:40:49 +0800
From: "David Lawrence Chin Meng Hon" dlc@tm.net.my
Subject: FA: Mass Additions from AP Invoices
Hi guys and gals,
Just a quick question ....
When attempting to mass create assets from an AP invoice which was created
WITHOUT matching to PO, the default no. of units is 1 (ONE). It seems that
Oracle, in the first place, does not allow a user to enter quantity
information when creating an invoice which is not matched to a PO. Anyone
has any ideas on how to work around this restriction?
Date: Wed, 23 Jun 1999 10:42:53 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Mass Additions from AP Invoices
David,
Once this Mass Addition has been posted in assets,
you could quite easily query this/these assets in the Assets System and
adjust the units and assignments.
Many Thanks
:-) [Test and Test again -- it's the prudent
thing to do]
Craig Riffel