ORA-01403

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

Applies to:

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

Symptoms

The Post Mass Additions program is erroring with the following error 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

Relevant triggers on FA_MASS_ADDITIONS had been disabled:
JAI_FA_MA_ARIUD_T1
JAI_FA_MA_BRIUD_T1



Comments
-----------
Triggers ought to be valid in order to have the application work as expected.

Solution

To implement the solution, please execute the following steps:

1. Backup below mentioned triggers, if needed consult with your DBA for further assistance.

2. Perform the following in a test environment.

alter trigger JAI_FA_MA_ARIUD_T1 enable;
alter trigger JAI_FA_MA_BRIUD_T1 enable;

3. Retest the issue.

4. Migrate the solution as appropriate to other environments.