My Oracle Support Banner

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 AUGUST 23, 2021

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: ##### ==> ** 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: ##### ==> ** Failed **
Mass Addition ID: ##### ==> ** Failed **
Mass Addition ID: ##### ==> ** 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:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 Still Have Questions?


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.