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 JUNE 05, 2024
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.
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
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:
In this Document
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 **
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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:
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 |
| Cause |
| Solution |
| Still Have Questions? |