Update Tax Book Interface Program Errors: Error retrieving row from FA_METHODS table and ORA-01403: no data found (Doc ID 2739539.1)

Last updated on AUGUST 23, 2021

Applies to:

Symptoms

When attempting to run FATAXUP: Upload Tax Book Interface
the following error occurs on some assets

ERROR
-----------------------
Asset number ####
Cache: Error retrieving row from FA_METHODS table
Depreciation Method: STL
Life in Months: 468

ORA-01403: no data found



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
In Oracle Assets
1. Add Asset to Corporate Book
2. Run Periodic Mass Copy to copy new addition to Tax Books
3. In Tax Books attempt Tax Upload Interface to update tax records

Changes

Cause

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