Asset Number skipping
Date: Thu, 24 Jun 1999 06:03:54 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: FA: 10.7 Asset Additions/Transactions
One of our users just noticed that in the course of
doing Quick Additions, the asset number assigned by
Oracle, jumped head. It jumped ahead by 7, once, then
after then next addition it jumped another 20. (There
were no other users on the system)
I took a look at the FA_TRANSACTION_HEADERS table and
also noticed a jump in the transaction sequence.
Has anyone ever seen anything like this before? Is
there another table I can look at to find out what may
have happened?
For example, if an asset is added then deleted in the
same period, before depreciation is run, FA seems to
wipe out all trace of it. However its smart enough to
know not to re-use the number. In what table does it
track the sequenece of numbers (Even of deleted
assets)??
Thanks
Date: Thu, 24 Jun 1999 09:18:34 -0400
From: "Cotten, Jim" Jim.Cotten@respironics.com
Subject: RE: 10.7 Asset Additions/Transactions
It sounds as though the sequences are being loaded in the SGA and then
being flushed. The numbers are generated using sequences and not stored
in tables. Have you asked your DBA about this problem. She/he should
know how to check and correct this problem. A simplistic explanation of
what is happening is a group of numbers from a sequence are loaded into
memory for faster access. Unfortunately, this marks those numbers as
being used, so if the server needs the memory and they get flushed out
of the SGA, they will never be available. Your DBA can modify the
sequences (NOCACHE) so that a group of numbers is never cached (possible
performance problems) or investigate tuning the SEQUENCE_CACHE_ENTRIES
parameter of the SGA to allow for more entries.
Date: Thu, 24 Jun 1999 09:02:10 PDT
From: Ananth Swaminath ananth999@hotmail.com
Subject: Reply: 10.7 Asset Additions/Transactions
Hi
This is a known bug and a patch plus a workaround is available to resolve
the sequencing problem. Basically the issue is with pinning the sequence in
the cache.
I have included below the detailed problem as well as the solution for the
same. Hope this helps out:
The asset number/asset_id values created by the sequence FA_ADDITIONS_S are
cached for performance reasons. So why would the application skip asset
numbers? The problem is that the sequence FA_ADDITIONS_S is being aged out
of the cache.
The symptom from the applications perspective is that the nextval of
sequences will increment without apparent reason to the next multiple of
the sequence cache value.
There are two possible solutions to prevent sequences from ageing out of
the sequence cache.
The first and most obvious option would be not to cache the sequence values
at all. But the result of this could be a moderate to severe degradation
of the application's performance. This performance degradation may not
affect individual manual asset additions so much as when posting Mass
Additions. If you want to you can issue the following command to change the
CACHE_SIZE to 0:
"alter sequence fa_additions_s nocache;"
A better solution is to prevent sequences from ageing out of the library
cache by pinning them using dbms_shared_pool.keep(). Pinning the sequence
will prevent the sequence values from being aged out of the cache. Pinning
the sequence is achieved by invoking the rdbms package
dbms_shared_pool.keep() as follows:
"dbms_shared_pool.keep('FA_ADDITIONS_S','Q')."
To be able to pin a sequence in the cache you must be on RDBMS version
7.3.3.1 or later. If you are not on 7.3.3.1 you will need to get a backport
of bug 432251 from the RDBMS support team.
If you would like to automate the pinning of sequences then you will need
to modify the script $AD_TOP/sql/ADXGNPIN.sql to include the sequences.
Please note that every time the database is restarted the
dbms_shared_pool.keep() will need to be rerun unless it is
called from the script $AD_TOP/sql/ADXGNPIN.sql.
When you shut down a database normally, either "SHUTDOWN NORMAL" or
"SHUTDOWN IMMEDIATE", the database takes care of making sure all sequences
are "in sequence". All cached sequence values are verified, and the
last_number column in dba_sequences is updated accordingly. Thus, under
normal circumstances and assuming that your sequence has been pinned, you
shouldn't lose cached sequence values during a normal shutdown.
The act of caching sequences keeps N number of sequence values in the
sequence cache, where N is the cache_size for the sequence. The number of
sequences kept in the sequence cache is specified by the
sequence_cache_entries initialization parameter and the default is 10. So
if you have 30 sequences cached, each with a cache_size of 10, you've got
300 sequence numbers cached in your sequence cache. In a system that
aggressively uses sequences, such as Oracle Applications, you run the risk
of losing your unused N sequence numbers from the list of 30 cached
sequences. Pinning a sequence will prevent your sequence from being
removed from the sequence cache list.
If the database experiences instance failure or a "SHUTDOWN ABORT"
statement is issued, you lose any unused cached sequence values. Oracle
may also skip sequence values after an export and Import and rollbacks.
Instead of modifying ADXGNPIN.sql you can apply the patch for Applications
bug 487890. This patch creates a new script called ADXGNPNS.sql which will
pin the sequences. The patch is included on the 10.7/7.3.4
Interoperability Patch CD.
Hope this helped.
Ananth
Senior Applications Consultant
Data in Corporate Vs Tax Books
Date: Fri, 25 Jun 1999 05:22:31 PDT
From: Krishna Rao pssk50@hotmail.com
Subject: Fixed Assets - Tax books
Hello:
I am implementing Fixed Assets for a client. I am in the process of setting
up the Corporate and Tax books (Federal, AMT and ACE). The Corporate and
Tax books of the client in respect of the older Assets (Historical) in
number and cost do not match due to different way of recording assets. For
Example: In a given period the company may have purchased several assets for
each asset group i.e. computers, furniture & fixtures etc. Each asset would
be entered in the corporate book of the old system as a single line item,
but in the tax books one asset line item would be entered for each asset
group, thus each line would be the aggregate of all asset additions for that
asset group. There is also difference in the quantity of assets, originating
from acquisitions, recorded in the corporate vs. tax books. If 5 chairs are
acquired in an acquisition and two out of the five chairs are not fit for
use then in the corporate book only three chairs are accounted for while in
the tax books all five chairs are recorded.
The client has requirement to bring over the existing assets in the
corporate and tax books into Oracle Assets. My questions are:
1. How to bring over the existing assets into Oracle Assets, as there is no
1 to 1 relationship in the existing corporate and tax books.
2. Can we have different number of assets in the corporate vs. tax books in
respect of older assets?
3. Can we bring over the existing assets in the corporate book through Mass
Additions and load the existing assets in the tax books directly into Oracle
Assets tables (for tax books only).
4. If step 3 is followed, can I use Mass Copy feature every month to copy
assets from corporate to tax going forward, without using Initial Copy
feature in Oracle Assets, to copy assets from corporate to tax books for
setting up tax books for the first time.
5. Also please let me know the implications of the various alternatives.
Any help in this regard is very much appreciated. Thanks in advance.
Krishna
Date: Fri, 25 Jun 1999 11:37:46 PDT
From: Lakshmi Viswanath lviswanath@hotmail.com
Subject: Re: Fixed Assets - Tax books
I don't know if you can load the Tax books and not load the corporate
book.Even if there is a way "Oracle" will not like it. We also had the issue
of assets existing in the Tax books and not in the Corporate book in our
legacy system. We created zero cost assets and made mass copy move the
assets to the Tax books and "sql" load the cost of the assets to the Tax
books. Surprise! Mass copy doesn't move assets with Zero cost. So make the
cost a penny in the corporate book, mass copy and its a wonderful world!
This will ensure data integrity between the corporate book and the Tax
books.
I don't know if this answers your questions.
Transferring Expense Accounts from AP to FA
From: Ruby Khaw [mailto:r.khaw@qut.edu.au]
Sent: Thursday, June 24, 1999 6:45 PM
Subject: FA Mass Additions Create - rel 11.0.2
Hi
We are having a problem with bringing across from AP to FA any invoice
lines charged to expense accounts:
1. invoice lines are charged to expense accounts and the
"Track as Asset"
box is checked
2. the invoices were approved and transferred successfully
to the GL
3. the Mass Additions Create process was then run
However, only invoice lines that used asset accounts are being brought
across; the ones using expense accounts are not. We did not have this
problem in our previous version 10.4.2.
This problem has been reported to this listing before and a
reply to this
listing suggests that we should be using clearing accounts
for the expense
lines. In our case, our clearing accounts are all assets accounts.
Can someone shed any light?
Thanks in advance.
Ruby
Ruby Khaw
Applications Team Leader-Oracle Financials Upgrade Project
Queensland University of Technology
2 George Street
Brisbane, Qld 4000
e-mail: r.khaw@qut.edu.au
Tel no.: 07-38642986
Fax no.: 07-38641806
At 07:08 25/06/99 -0400, Bill wrote:
Just make sure that the expense accounts are set up as
either a CIP clearing account or an asset clearing
account in one (or more ) of your
categories.
Date: Mon, 28 Jun 1999 14:12:23 +1000
From: Ruby Khaw r.khaw@qut.edu.au
Cc: Bill.Platt@atmosenergy.com
Subject: RE: FA Mass Additions Create - rel 11.0.2
Bill
I have tried to define the Asset Clearing and the CIP clearing account in
one of my categories to be an expense account but the system gives me an
error: FA_SHARED_NOT_ASSET_ACCOUNT
Any ideas?
Thanks,
Ruby
Date: Fri, 02 Jul 1999 00:22:40 PDT
From: Thomas Kuglen tkuglen@hotmail.com
Subject: RE: FA Mass Additions Create - rel 11.0.2
I can't say that I've done what you are trying to do, but my understanding
of what should happen is:
- You need to use accounts of type "Asset" as clearing accounts when
setting up a category.
- If an invoice line is is distributed to an account that is defined as a
clearing account in an asset category, then the "Track as Asset" flag will
automatically be set to "Yes" and it cannot be changed. The invoice
information will be sent to FA after the invoice is posted to GL and the
Create Mass Additions process is run. AP will debit the clearing account
and credit the AP control account. FA will debit the asset cost account and
credit the clearing account.
- If an invoice line is distributed to an expense account then the "Track
as Asset" flag can be optionally set to "Yes." If it is, then the invoice
information will be sent to FA after the invoice is posted to GL and the
Create Mass Additions process is run. AP will debit the expense account and
credit the AP control account. FA will not do any accounting but it will
still track the invoice information as an asset.
Also, to meet a requirement in several countries, I have set up categories
with a default life of one month. All accounts are set up normally. The
effect of this is that all costs are capitalized to the balance sheet but
fully depreciate through the P&L in their first and ony month of service.
FA profile - multiple SOBs
From: Kumar Subramaniam kumar.subramaniam@sanmina.com
Subject: FA Profiles
Date: Wed, 30 Jun 1999 12:28:57 -0400 (EDT)
Hi,
Do we need to setup profiles for FA?
We have a three different sets of books apart from the consolidated one.
Please advise.
Kumar
Date: Wed, 30 Jun 1999 23:57:16 PDT
From: Thomas Kuglen tkuglen@hotmail.com
Subject: Re: FA Profiles
What do you mean by profiles? There are several profile options that relate
to FA and depending on your setup these might need to be modified.
If you are talking about multi-org, FA is NOT enabled for multi-org so FA
will be different from the way you set up tmulti-org and operating units for
modules such as AP and AR. However, you will need to use org ids in
setting up the FA responsibilities even though these won't affect
processing. (in future releases FA will become multi-org but that is not
true in R11 and I'm not sure if it is true in 11i.)
Typically, you will have one FA depreciation book for each for each GL SOBs
into which you will enter transactions. If you have three GL SOBs, then you
will probably have three FA depreciation books.
Hope that helps.
Physical inventory adjustments
Date: Thu, 1 Jul 1999 13:25:50 -0400
From: "Smith, Neil" NSmith@MICROS.COM
Subject: URGENT YEAR END!!! "Perform physical inventory adjustments"
Help!!!
When we attempt to run the "Perform physical inventory adjustments"
concurrent job we get the following error:
----------------------------------------------------------------------------
AAADhmAABAAAIBhAAVError in INLTPU routine -Unknown error
APP-05065: Item cost should be defined before you transact
Action: Check if the cost-enabled flag is set correctly in the item master,
and also check if the item cost is defined in the costing module.
----------------------------------------------------------------------------
Anyone know the fastest way to find out what item is being referred to
here?
Any help would be appreciated.
Thanks,
Neil Smith
MICROS
Date: Thu, 1 Jul 1999 13:33:48 -0400
From: "Downey, Dawn E" dedowney@kpmg.com
Subject: RE: URGENT YEAR END!!! "Perform physical inventory adjustments"
There should be an adjustment transaction stuck in an interface
somewhere....You might try the Inventory Interface (Transaction Open
Interface)....I'm not sure if there is a visible costing interface
somewhere...or perhaps a GL interface....
Or, if you have a tool like Discoverer, you could pull up the concurrent
request ID, the error message and see if you can pull up a cross reference
to the item as another field and find it that way....
If I can explain further, please email me direct.
Thanks-
Dawn
Dawn Elise Downey
Senior Consultant - Oracle
KPMG LLP
Boston, MA
Office: 617-988-5629
Pager: 888-692-1071
Date: Fri, 2 Jul 1999 09:00:00 -0400
From: NSmith@micros.com
To: "Downey; Dawn E" dedowney@kpmg.com,
Subject: RE: URGENT YEAR END!!! "Perform physical inventory adjustmen
Dawn,
Thanks for the response. It turned out that three items in the
mtl_physical_adjustments table had not been setup in the cost module. We had to
write a query to discover this. If we could figure out how to force the
concurrent job to be in a "debug" mode, I think this would have been easier.
Thanks again!!!
Neil
MICROS Systems, Inc.
Category Change and CV Rules
Date: Thu, 8 Jul 1999 10:50:22 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: FA: Category/Assignment Changes
We are on 10.7SC and have a "CATCH22" situation. I'm
wondering if anyone a creative solutions to.
We often need change asset categories on our fixed
assets, However we are blocked because of our GL
segment cross validation rules.
For example: Asset in BUILDING category, account
12345-0000 (where 12345 is natural account and 0000 is
project number), must transfer to PLANT EQUIPMENT
category, account 12355-1234
In our setting, account 12345 does NOT use project
numbers, and account 12355 MUST have a project number.
If we try to change the category from building to
plant we are seemingly blocked because the asset has
no project number, and if we try to first change the
ASSIGNMENT so that the asset has a project number we
are blocked there as well because you can't use a
project number with the building account.
So... if my explanation is clear enough, I'd like to
here any alternatives to disabling the cross
validation rules or retiring the asset and setting up
a new one.
Thanks
Jim Teague
Senior Financial Systems Anaylst
Date: Fri, 9 Jul 1999 10:42:30 +1200
From: Nicolas Woollaston NWoollaston@swichtec.co.nz
Subject: RE: Category/Assignment Changes
One possibility would be to move it via a clearing account, where you could
be very relaxed about your cross validation.
So move it from 12345-0000 to 22222-0000. Then move it to 22222-1234 (a
combination created as necessary). Then move it 12355-1234. The 22222
account should be periodically reconciled back to zero.
This creates extra work, but at least presents no risk.
Nicolas Woollaston
Analyst Programmer
Swichtec Power Systems
New Zealand
Prorate Convention - change
Date: Fri, 9 Jul 1999 11:05:19 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: FA: Prorate Convention
Hi all,
After going live (10.7 NCA), we got an instruction
to change our month-end dates (we had set up dates in GL & FA to Sep-2000 -
Financial Year end). The GL dates presented no problem since new budgets had
not loaded. The FA Calendar and Fiscal year changes also presented no
problem. However, the Prorate Convention Dates present a challenge.
I set up a monthly prorate convention which also
uses the Depreciation Calendar, to Sep-2000. Any attempt to change the dates
is met with ' Field is protected against update'/ 'This record is already in
use...'.
In my wisdom I created a new prorate convention,
which mirrors the old one except for the new dates and changed the default
in Categories as well. Great, everything works well, except (obviously in
hind sight) all existing assets still uses the old prorate convention and I
would like them to use the new prorate convention.
Anyone have ideas as to how I could easily change
the prorate conventions on these existing assets without having to change
them one by one (28000 records).
Many Thanks!
Date: Fri, 09 Jul 1999 06:37:48 PDT
From: "carla pasos" carlapasos@hotmail.com
Subject: Re: FA: Prorate Convention
You can use the Mass Changes form in Oracle Assets to change the prorate
convention for a group of assets. In the changes area enter the old prorate
convention in the "Before" field and the new one in the "After" field.
Hope this help
Millarca
Date: Fri, 9 Jul 1999 09:45:17 -0400
From: Blondie Pate BPate@FAMILYDOLLAR.com
Subject: RE: Prorate Convention
Try using the Mass Transaction function using either the date in service or
asset numbers sequence to change the prorate convention.
Changing category of an asset
Date: Sun, 18 Jul 1999 16:56:54 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: FA - Reclassifying an asset to another category
Hi FA experts,
I am in the midst of testing the FA module. I have entered a transaction say
in Jan 99. In Mar '99 I decided to change the asset category.
The user guides mentions that it can be done by querying the asset in the
Assets Workbench and entering the new category. But when I change the
category and try to save the record, I get the following error
APP 48260 - Module Reclass ended with error. Module Reclassification user
exit ended with error.
I tried to re-compile the Category flexfield and redo the above, but the
error still persists.
Has anyone faced similar error. Shall appreciate any help on the above.
Regards,
Chetan
Date: Mon, 19 Jul 1999 11:28:50 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: FA - Reclassifying an asset to another category
I am posting this query with additional information;;
I have defined the Asset category flexfield with 3 segments,
* Major Category (with major category flexfield enabled)
* Function
* Sub code
I entered a transaction with category 08-212-01 in Jan 99. In Mar 99 it was
decided to reclassify the asset to category 05-070-01.
The user guides mentions that it can be done by querying the asset in the
Assets Workbench and entering the new category (Refer pg 3-2 Release 10SC).
But when I change the category and try to save the record, I get the
following error
APP 48260 - Module Reclass ended with error. Module Reclassification user
exit ended with error.
The user guide also gives an example to reclassify asset from Office
Equipment to Computers. (Refer pg 6-31 of User Guide Release 10SC)
I observe that it is possible to reclassify assets within the same major
category say for eg change from 05-070-01 to 05-255-02. Hence, it seems that
transferring assets between major category is creating the problem .
Is this standard functionality. Or is it a bug, which needs to be patched.
Has anyone faced similar error. Shall appreciate any help on the above.
Regards,
Chetan
Date: Mon, 19 Jul 1999 07:50:56 -0500
From: "John E Polson" jpolso@hallmark.com
Subject: Re: FA - Reclassifying an asset to another category
I have had these types of errors occur when FlexBuilder built a disabled or
non-existent account segment. Try going to FlexBuilder Test to generate the
account segment. Then, check to see that it is enabled.
Good Luck.
Date: Mon, 19 Jul 1999 17:13:51 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: RE: FA - Reclassifying an asset to another category
-Hi John,
I have tested the transaction in Test environment with Dynamic account
insertion on. Hence, the possibility is ruled out. Also, if it is the case
the error should arise when depreciation is run and not at the time of
entering the transaction.
Cheers,
Chetan
Date: Mon, 19 Jul 1999 06:25:36 PDT
From: "Lakshmi Viswanath" lviswanath@hotmail.com
Subject: Re: FA - Reclassifying an asset to another category
Hi,
Check the category defaults information for the "from" and "to" categories.
They must be enabled and capitalize flag should be checked in the category
definition. The general ledger accounts (in categories screen) must have a
valid accounting combinations for all the books that use this assetid
(including even your test and tax books).
This error message originates from the flexbuilder rule. Check the
flexbuilder rules for the Cost, Expense and Reserve Acct, again for all the
books that use this asset. If it's a CIP asset then check the clearing
accounts.
The code combinations and all the segments must be valid for the above
accounts in GL.
If you have added a new segment to your category flexfield you might need to
recompile it. (Its not a good idea to recompile ff otherwise)
Hope this helps,
Lakshmi.
Date: Mon, 19 Jul 1999 09:21:59 PDT
From: "Harish K" har23@hotmail.com
Subject: RE: FA - Reclassifying an asset to another category
Hi Chetan:
The error due to flexbuilder will arise not just at the time of running
depreciation but rather will occur when you make the reclass.
When you make a reclass the transfer rows are created immediately in
FA_ADJUSTMENTS. So it may be that the account that flexbuilder is trying to
generate is violating one or more cross validation rules.
Regards,
Harish
How NOT to Depreciate certain assets AND Mass Copy frequency
Date: Thu, 29 Jul 1999 15:22:21 -0500
From: "Sue Lynch" SuEL@wma.clarkshoe.com
Subject: FA Implementation Q's
All,
Starting to formulate our design/setup of Assets on rel 10.7, NT
environment, with GL, AP and AR already being utilized.
Main question is does anyone have any "helpful hints" or things to avoid
when we're doing setup; loading in legacy data, etc??
Some general questions we have are:
1) If I setup a group of assets with STL but I have 10 assets that should
be in that asset category, but in one of our tax books, it should not have
depreciation, can I just remove the depreciation expense account on that
asset or how do I do it?
2) How often should we do a periodic masscopy from our corproate book to
our tax books if we only want to run depreciation once per year in the tax
books? if we only do it once per year, won't it be a pain to reconcile
all additions/retirements? Doesn't this cause issues with adding and
trying to retire an asset in the same period (here a year)?
Please help.
Thanks,
Sue Lynch
Date: Thu, 29 Jul 1999 13:34:24 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re: FA Implementation Q's
Sue,
I believe for the book in which you don't want the
asset to depreciate you can change the asset category
setup and UNcheck the depreciate box.
As for mass copy, I recommend you copy AAND reconcile
every month. We havent reconciled our tax books for
awhile and now we have a mess.
Good Luck
Date: Fri, 30 Jul 1999 09:41:30 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: FA Implementation Q's
Hi Sue,
In your Tax Books you would query those assets you
do not want to depreciate and Untick the "Depreciate Box". This stops the
depreciation calculation on that asset.
I would say that the periodic mass copy should be
done on a monthly basis -- It makes it easier to reconcile and when
creating deferred tax journal entries, allows current month posting to open
periods instead of trying to post to GL closed periods .
Thanks Much
:-) I used to have a handle on life, but it broke.
Craig Riffel