R12 Post Mass Additions (FAMAPT): Errors With "ORA-01403: NO DATA FOUND" And "ERROR: FUNCTION FA_CACHE_PKG.FAZCCMT RETURNED FAILURE" (Doc ID 985016.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Assets - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
FAMAPT - Mass Additions Post

Symptoms

The Post Mass Additions program errors with the following message on certain records Life in Months:

Cause: You have a database problem.
Action: Contact your system administrator.
ORA-01403: no data found
Error: function fa_cache_pkg.fazccmt returned failure
Cache: Error retrieving row from FA_METHODS table
Depreciation Method: STL
Life in Months:
Cause: You have a database problem.
Action: Contact your system administrator.
ORA-01403: no data found
Error: function fa_cache_pkg.fazccmt returned failure
Error: function fa_asset_calc_pvt.calc_deprn_info returned failure
Error: function fa_asset_calc_pvt.calc_fin_info returned failure
Error: function fa_addition_pub.do_addition returned failure Mass Addition ID: 82556 ==> ** Failed **
Error: function fa_massadd_pkg.do_mass_addition returned failure Cache:
Error retrieving row from FA_METHODS table Depreciation Method: STL Life in Months: 
Also included many times:
Please enter a Date Placed In Service that falls in the current or a prior period.

Examples
Mass Addition ID: 81058 ==> ** Failed **
Mass Addition ID: 81377 ==> ** Failed **
Mass Addition ID: 81418 ==> ** Failed **

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Note:
The depreciation methods STL and related asset lifes had been setup already.
Eg. STL 12 months or STL 36 months were in place.
Scripts to verify:
To verify the Mass Addtions' their methods and related lifes:
select FMA.mass_addition_id, FMA.asset_category_id , FMA.deprn_method_code, FMA.life_in_months, FM.method_code, FM.life_in_months, FM.stl_method_flag
from FA_MASS_ADDITIONS FMA , FA_METHODS FM 
where mass_addition_id in (82556,81058,81377,81418) -- from the FAMAPT logfile
and book_type_code = '&book_type_code''
and FMA.deprn_method_code=FM.method_code;
To verify what had been setup in Oracle Fixed Assets:
select distinct method_code, life_in_months
from FA_METHODS
where method_code = 'STL';

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms