ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
FIXED ASSETS

Depreciation erroring out

Date: Fri, 13 Aug 1999 14:43:28 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: FA -- Depreciation Erroring out.......URGENT ********************

All,

We are getting following error while running Depreciation. Please suggest what to do ? Here are the Database parameters:
----------------------------
db_files = 1024
db_block_size = 8192
db_file_multiblock_read_count = 32# LARGE
db_block_buffers = 9200
shared_pool_size = 150829120
log_checkpoint_interval = 10000
processes = 75
dml_locks = 500
log_buffer = 163840 # LARGE
open_cursors = 255
optimizer_mode = rule
rollback_segments = (r01,r02,r03)

Thanks,
-chakrapani

++++++++++++++++++++ERROR TEXT+++++++++++++++++++++++++
+-------------------------------------------------------------------+
Oracle Assets: Version : 11.0.28 - Development
Copyright (c) Oracle Corporation 1979, 1991. All rights reserved.
FADEPR module: Depreciation Run
+-----------------------------------------------------------------+
Current system time is 13-AUG-1999 13:56:17
+--------------------------------------------------------------+
Depreciation Program Exception Report
Cost Initial Journal Entry program completed
APP-48208: fadpods FA_DEPRN_SINGLE: has the value of N.
APP-48208: deprn_cache: has the value of 20.
Error: function fazccmt returned failure (called from fadais)
Error: function fadaid returned failure (called from fadpaa)
Error: function fadpaa returned failure (called from fadatd)
APP-01564: ORACLE error 1403 in fadatd

Cause: fadatd 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-47180: Error: FETCHing cursor &CURSOR
APP-48152: Asset number 10057
Error: function fadatd returned failure (called from faddep)
APP-47697: Error: Unable to insert into FA_DEPRN_DETAIL and FA_DEPRN_SUMMARY tables

Cause: You have a database problem.

Action: Contact your system administrator.

Error: function faddep returned failure (called from FADEPR)

+------------------------------------------------------------+

No completion options were requested.

+--------------------------------------------------------------+
Concurrent request completed
Current system time is 13-AUG-1999 13:56:37
+-------------------------------------------------------------+
fazcct cache results
Accesses: 21 Hits: 20 Hit Ratio: 95.238095%
fazcbc cache results
Accesses: 70 Hits: 69 Hit Ratio: 98.571429%

Date: Fri, 13 Aug 1999 12:23:27 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re: FA -- Depreciation Erroring out.......URGENT

Is Asset number 10057 a NEW asset? Has it been depreciated before. Try deleting this asset, see if the depreciation run will continue.

Date: Fri, 13 Aug 1999 13:24:46 -0600
From: rpropp@es.com
Subject: RE: FA -- Depreciation Erroring out.......URGENT ****************

There is a prior period depreciation period record missing in fa_deprn_periods for your asset book. You will need to insert a record into your fa_deprn_periods table. The setup process failed to insert the first depreciation record for you for that book.

You should be able to get a sql script from Oracle Support.

Date: Fri, 13 Aug 1999 13:42:54 -0700
From: SCross@littonapd.com
Subject: RE: FA -- Depreciation Erroring out.......URGENT ****************

I also read somewhere in Metalink that Oracle has a patch that will allow the depreciation to complete with errors. This is great if you have a lot of assets to depreciate. Has anyone tried this patch? The 10.7 SC version is 691299.

Susan

Date: Sat, 14 Aug 1999 14:14:59 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: FA -- Depreciation Erroring out.......URGENT ************** got i

All,

I really appreciate the response from all the guys related to this issue. I got this problem because the ASSETS load from Legacy data has somehow inserted one asset without any cost info but this isnot possible as these cost columns are NOT NULL columns.

Before I got reply from fierosrcul@yahoo.com asking whether it is new ASSET or not.. we called ORacle Support and they asked the same question to look into the details of this ASSET 10057.

Oracle Support also asked us to run one SQL script to track the entire asset info. For the reference of all the guys answered I am attaching the spool file of their script as I should not reveal the script here on forum...... Hope this helps in tracking the ASSET..... ( Ofcourse you can generate the trace file and see all table that have been ropogated during this process.) Still the problem exists and we are working with ORacle Support.....

++++++++++++++++++++ I can send the TRACKED ASSET DETAILS for Asset_id=10057 and BOOK_TYPE_CODE='CORPORATE' are in attached file IF ANYBODY WANTS AS THIS FILE size is more than 25KB +++++++++++++++++++++++++++++++

If anybody is interested can reply to me and I can send you the SPOOLED file details.

Thanks to you all and thanks to this forum.
-chakrapani