ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
FIXED ASSETS

Cost on split invoice not appearing after Mass Additions

Date: Wed, 24 Mar 1999 09:21:42 -0800
From: "Sullivan, Curtis" Curtis.Sullivan@Aspect.com
Subject: FA: Split Invoices

All: We have a problem in that since our upgrade to 10.7, the cost on all split invoices does not appear on the Mass Additions Posting Report.

In addition, Company (Acct Flex segment1) and Dept (Acct Flex segment 4) also stopped appearing on the report for all assets.

Any help would be greatly appreciated.
Curtis Sullivan Aspect Telecommunications.

DateMon, 29 Mar 1999 21:58:37 +0530
From"Madhavi Ghodke" madhavi@pn2.vsnl.net.in
SubjectReFixed Assets

Has Distribution Set has been attached to your Depreciation Book for which you are running mass additions programme? Please check.

Unable to query asst in Prepare Mass Additions Form

Date: Tue, 6 Apr 1999 10:28:12 -0400
From: "Nandakumar R" nkumar@se-tech.com
Subject: FA Mass Additions

Using SQL Loader, I have populated the FA_MASS_ADDITIONS table with all the required fields (using one asset for testing). The Queue name and Posting Status are set to ON HOLD

However when I go into the Prepare Mass Additions Form I am unable to query the asset. Through SQL I am able to view the asset in the FA_MASS_ADDITIONS table.

Would appreciate any suggestions on the matter TIA Nand

From: William.Gaston@infores.com (William Gaston)
Subject: Re: FA Mass Additions
Date: Mon, 12 Apr 1999 06:44:29 -0400 (EDT)

Try using 'NEW' for Queue Name and Posting Status.

From: Suresh Chhabria [mailto:chab_suresh@hotmail.com]
Sent: Thursday, May 13, 1999 3:29 PM
Subject: Re: FA Mass Additions

Hi William,
This could be the form based bug.. are you aware of the patch set for 10.7 for FA, is the form version 7.0.75.7016.12, last modified may 8,1998.

If not then you need to administer the patch and retest the whole process.

Thanks, Suresh Chhabria

From: Kurylo, Mary [mailto:Kuryma@consumer.org]
Sent: Thursday, May 13, 1999 3:54 PM
Subject: RE: FA Mass Additions

I'm having the same problem in the 'Prepare Mass Additions' Form. After you get this error, do a / Help Error Database. The error I get is column 'Context' doesn't exist in FA_MASS_ADDITIONS. I currently have a TAR open on the issue. Just got 2 patches for it and they didn't work (I think one of the patches has a problem though and didn't apply properly). FYI my TAR# is 11920251.600

Mary Kurylo Applications Development Analyst Consumers Union of US Inc.

Date: Fri, 14 May 1999 16:07:30 -0400
From: "Kurylo, Mary" Kuryma@consumer.org
Subject: RE: FA Mass Additions

I got two patches from Oracle 513467 and 710996 and now the form works. However the readme file for 513467 has no special instructions. You have to re-run adpatch with d513467.drv after you apply it.

Mary Kurylo Applications Development Analyst Consumers Union of US Inc.

Retiring an Asset

Date: Thu, 25 Mar 1999 10:52:26 -0700 (WIB)
From: hernawan
Subject: FA: Error Retire an Asset

Hello everyone: I've retire an asset. And when I run calculate gain & losses I'm getting error :
-----------------------------------------------------------------
Getting acct segment in fagpct information
Getting dh.thid_out in fagpct information
Getting current units in fagpct information
Inserting FA_ADJUSTMENT record
Inserting FA_RETIREMENTS record
The code combination is 1105092039100
Previous Messages (for Support Purposes)
APP-01930 FlexBuilder failed to generate a CCID for row 0 in fdfmap due to : APP

The book_type_code parameter is MAKRO
The account type parameter is COST_OF_REMOVAL_LOSS_ACCT
The account segment parameter is 105092
The distribution_ccid parameter is 2538
The default ccid parameter is 2602
The account CCID parameter is 0
Error: function fafbgcc returned failure (called from fadoflx)
APP-00001 Cannot find message name FA_GET_CAT_ID
Cause: Message Dictionary cannot open the message file or
cannot find the message FA_GET_CAT_ID in the message
file.
Action: Check that your message file exists.
Action: Check if you have read privileges on the directory and on the file. Contact your system administrator to obtain read privileges.
Action: Define your message using the Define Messages form. Error: function fadoflx returned failure (called from fadoret) APP-00988 ORACLE error 1403 in fadoret
Cause: fadoret failed due to ORA-01403: no data found.
The SQL statement being executed at the time of the error was: and was executed from the file .
APP-48124 Error fetching cursor RET_CR
Error: function fadoret returned failure (called from faxinaj)
Retirement ID: 2 Asset Number: 3B0006 --> ** FAILED **
Previous Messages (for Support Purposes)
APP-47425 faxinaj in fagurt: Failed to get insert cost_of_removal into fa_adjust
APP-47426 FAGURT: Fail to make table adjustments for asset 3B0006
APP-47413 FAGRET: Fail to retire asset 3B0006

How can I solve the problem ?.
Unix box, Apps ver 10.6.1
TIA Hernawan

Date: Thu, 25 Mar 1999 05:20:57 PST
From: "Lakshmi Viswanath" lviswanath@hotmail.com
Subject: Re: FA: Error Retire an Asset

The "1105092039100" is the code combination that needs to be setup in GL. Check to see if there is any more like that. Setup all ccids and rerun job and it should be fine .The other ids you see in the log file can be used to do a flexbuilder test. (Not necessary) Lakshmi Viswanath.

Date: Thu, 25 Mar 1999 13:24:42 -0800 (PST) From: Carla Miller carlamiller@yahoo.com To: oraapps-l@cpa.qc.ca Subject: Re: FA: Error Retire an Asset Message-ID: 19990325212442.19712.rocketmail@web114.yahoomail.com The ccid is probably already there but disabled. If you're in Fixed Assets, check the account combination by going to Setup - Financials - General Ledger - Combinations.

Calendar

Date: Thu, 25 Mar 1999 09:11:15 +0530
From: "Madhavi Ghodke"
Subject: FA: Asset Calendar Current period
Hi all, We are on FA(10.7). I want to get current period open for Depreciation run from the start period of the year.How do I define my Fiscal Year?

Please Help. Thanks Madhavi

Date: Thu, 25 Mar 1999 07:55:14 +0000
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: FA: Asset Calendar Current period

The two really are not related- define your calendar and fiscal year as your business dictates and set your current period on the books screen.

jeanne!

x-------------x

Date: Wed, 28 Apr 1999 15:22:34 -0400
From: "Richard Gross" ragross@revenue.com
Subject: RE: Fixed Asset Changing Calendar

Yes, I have seen this situation in the past, and if I recall correctly the Oracle software does in fact handle short accounting years correctly. I think that you need to set your calendar as it did happen July - June for the past one period of July to December and going forward Jan - Dec. This works since all of the remaining lives are then calculated correctly and this also conforms to tax deprecation schedules.

Security of Usage

Date: Tue, 30 Mar 1999 10:56:14 +0100
From: "Thornton, Steve (UK01)" Steve.Thornton@UK.Honeywell.com
Subject: FA: Security Questions

Dear All, Forgive me if my question is somewhat basic, while I'm familiar with implementing other modules, Assets is new to me.

We're about to implement Assets onto a 10.7 Multi-org database already running AR, AP & GL. My understanding is that Assets is not multi-org'd and is divided by Books in a similar way to SOBs in GL. My question is 'What security is available to ensure that Assets users in an organisation can only see their own data and not that relating to other Books?'

Any answers, or corrections to the assumptions that I have made would be gratefully received.

Many Thanks Steve Thornton Independant Consultant

Date: Tue, 30 Mar 1999 12:29:39 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: Security Questions

Thornton, We are in the process of implementing Assets in a company that is going to have five books and as yet have not found any such security. We have made use of the security available in GL restricting users to certain segments within our account combination. This only prevents the users from entering depreciation accounts that do not apply to their book/organisation but they still Able to view all books.

If anybody else has found how to set this security, I would be interested as well.

Many Thanks Craig Riffel

Date: Tue, 30 Mar 1999 06:54:34 -0800
From: Bob Woodfin rwoodfin@us.oracle.com
Subject: Re: FA: Security Questions

Steve, There is no standard functionality to do that. If it is an absolute requirement you will have to customize. At a previous client of mine, we were afraid of someone would accidently make changes or additions to the wrong company. To help with this we used folders to filter the assets being worked with. We created a responsibility for each company and then attached these folders to the appropriate responsibility. It's not security, but it helped.

Bob

FA Data Migration

Date: Tue, 6 Apr 1999 17:48:39 -0400
From: bchhabra@csc.com
Subject: FA Data Migration

We are having problems with our FA Data Conversion from a 9.4 install to a 10.7 install. We needed all history to be converted and have done a table by table conversion, but the FA_DEPRN_DETAIL table in 10.7 has a new column called COST that did not exist in 9.4. We populated this with the COST from the FA_BOOKS table but the FA Cost Detail Report and the FA Cost Summary Report beginning costs and additions columns do not match the 9.4 values. Some assets are OK, some are off by a few $$ and some are off by quite a bit.

Has anybody run into similar problems out there or have you a better method for converting 4 years of asset history into 10.7?

Thanks for your help..

Date: Tue, 06 Apr 1999 14:32:42 +0100
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: FA Data Migration

I'd call OWWS on this one (early in the morning EST to get Orlando)- their FA staff is great!!!

I know that field is used in quite a few reports and I don't think it has an impact on processing. I had a problem with it not being updated when I changed assets entered as non-depreciating to depreciating. (Which we all know is not a typical activity, I had to do it to force a remaining value/remaining life method of STL deprn)

jeanne!

Tracking expenses as assets

From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: FA: Set up Question
Date: Mon, 12 Apr 1999 17:12:34 -0400 (EDT)

We are a local government agency in the process of setting up FA 10.7SC 16.1. Our requirements are that, although we identify as "capital" any assets over $1500, we are not allowed to depreciate them per our state auditors. Therefore, all of our assets are expensed during the year. However, we still have a need to track them in FA. We have no fixed asset accounts in our GL, although we will categorize our fixed assets in FA.

Would there be any benefit to setting up an asset clearing account in the GL to run all these "capital" assets through to FA? Our other alternative seems to be to use the track expensed items option in FA for everything we want to track in FA. Has anyone addressed similar requirements?

Thoughts?
Drawbacks?
Your input on this is appreciated.

Thanks. Kathy Farmer Scott County

"RADHA KRISHNAN" radha_rk@hotmail.com wrote:

Hi Kathy,

1.Accounting Fixed assets and providing depreciation on such capital assets for non commercial organisations like Non Profit/ State or federal govt agencies have always been governed by the respective laws incorporating them and most of the times not by the GAAP or standards.Since Oracle Financials has built its application suite around general commercial organisations, this specific requirement has not probably been taken care.

2. Oracle FA provides for maintaining three types of books viz., corporate book,tax book and budget book. If the state auditors expect you to charge off the cost as revenue in the same year,that can probably be achieved thro diluting the core functionality of FA module (depreciation).

3. One way of work around could be to keep the salvage value at $1 and write off the balance as expenses.

This is just some stray thoughts on this topic.Would welcome your sharing with the user group how you are going to configure your specific requirements on one side and still retaining the basic functionality of FA on the other hand.

Regards, Venkat Radhakrishnan. radha_rk@hotmail.com. fixed assets

From: Roger Drolet [mailto:rdrolet@netscape.net]
Sent: Tuesday, April 20, 1999 9:59 AM
Subject: Re: [Re: FA: Set up Question]

Kathi,
Oracle Assets provides functionality to add items that do NOT depreciate; the entire cost is charged in a single period to an expense account. Oracle Assets tracks expensed items, but does not create journal entries for the m. Oracle Assets does not depreicate expensed assets, even if the Depreciate check box in the Books and Mass Additions Prepare windows is checked for that asset.

Navigate to teh QuickAdditions window and you will see the field, Asset T ype (i.e., Capitalized, CIP, Expense). Also, in Oracle Payables you can expe nse an item and click on the flag to "track as an asset".

Hope this helps. Also, I can be reached at (972) 342-8846.

Regards, Roger Drolet Managing Associate Conley, Canitano & Assoc., Inc.

Date: Tue, 20 Apr 1999 15:44:05 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: [Re: FA: Set up Question]

Yes, I'm aware of the tracking expensed items functionality. We were concerned about using that for all our assets because (1) someone would have to remember to click on the "track as fixed asset" box for each item and (2) you lose a lot of the automatic categorization available by having different asset accounts map to categories.

What we're going to do in our test system is actually set up some asset clearing accounts in our GL which will be zeroed out with a journal entry, expensing all the items at month end after the fixed asset additions are done. This will allow us to automatically categorize our assets and also automatically send those assets to the FA module. All the assets will then have depreciateno, just as Land might, for example.

I'll keep you posted on how this works in reality vs. theory!!

Kathy Farmer

Inventory to FA

Date: Wed, 21 Apr 1999 01:50:59 -0700 (PDT)
From: SRIVATHSAN N nsrivaths@yahoo.com
Subject: Asset capitalisation,Please help!

Hi All!
We are dealing in trading and leasing out Computer Pheripherals. At the time of purchase we do not know the items would be for inventory or for fixed assets. We are purchasing items as inventory items and transferring them to fixed assets as and when the need arises.

An example would be the computer peripherals which can be sold directly to customers thereby ,can be treated as stock.The same can be transferred to FA and also can be leased out to customers.

We need to know how exactly the inventory items can be transferred from Inventory Module to Fixed Assets module. Is there a direct way of doing the transfer as we need to show depleted balance in Inventory and the reciprocal effect in FA Module. We would really appreciate any help on this.

Thanks in advance

Date: Wed, 21 Apr 1999 11:53:25 +0200
From: "Daniel Mehaignerie" daniel.mehaignerie@esfrance.com
Subject: Re: Asset capitalisation,Please help!

there is no direct transfer from inventory to assets. What you could do is:
- create a misc issue transaction in IC "transfer to assets"
- write a program to feed FA_MASS_ADDITIONS based on inventory "transfer to assets" transactions and on the item's default asset category.
- design a report to help reconcile IC and FA

hope this helps Daniel

Date: Wed, 21 Apr 1999 15:32:59 +300500
From: Purnendu_Panda@india.notes.pwa.co.in
Subject: Re: Asset capitalisation,Please help!

One way is to do an account issue from inventory to an asset clearing account. This will Debit the asset clearing account and credit the inventory material account.

Then do a manual addition in fixed asset which will debit the respective asset cost account and credit the clearing account.

Thus the effect will be their in the inventory account and the asset cost account. I am not aware of any direct way of transferring items from inventory to fixed assets. Let me know if it works.

Purnendu Panda PricewaterhouseCoopers

Date: Wed, 21 Apr 1999 12:46:38 PDT
From: "Suresh Chhabria" chab_suresh@hotmail.com
Subject: Re: Asset capitalisation reply from chhabria

Hi all,
Panda's recommendation is an accounting recommendation. The clearing accounts will get nullified only if the asset is pulled from AP.

The solution is to make a Return material authorization and this takes care of the material account, the customer gets debited and then get an invoice from the vendor and enter it through AP, this accounting wise would be the most sensible solution, and you can keep a track of it for audit purposes.

Hope this helps, Suresh Chhabria Implementation consultant and Quality Assurance Auditor Enterprise solutions - Oracle/SAP

Tax Book

To: Multiple recipients of list oraapps-l@cpa.qc.ca
cc: (bcc: Mark Drogemuller/DIV5/WGTN/ErnstYoung/NZ)
Subject: Fixed Asset Tax Books

Does anyone use/create GL journals from a fixed asset tax book? Can you give me a scenario on why you would?

Date: Thu, 29 Apr 1999 08:46:43 -0400
From: Steve Bradley sbradley@sprynet.com
Subject: RE: Fixed Asset Tax Books

I had a large client ($7 Billion) where the tax department wanted their own GL set of books to record tax adjusting entries. We set up a tax book in FA to feed tax depreciation (which was different than GAAP for this client) to the TAX GL SOB. The problem was the FA tax books could not generate the depreciation difference between GAAP and tax. We had to feed the full tax depreciation to the tax SOB. The TAX GL SOB was intended to only include adjustment amounts to GAAP, not ending balances. We had to adjust our reporting when combining the GAAP and TAX SOB's for tax reporting to exclude the GAAP SOB depreciation amounts. They used this reporting to create a flat file that was fed to Fast Tax to prepare the tax returns.

Respectfully, Steve Bradley, CPA OASIS Consulting Group, Inc. Office 404-352-8387 Fax 404-609-9856 Pager 888-912-2569