Depreciation Methods Not Valid Issue For "Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed" Error

(Doc ID 2322284.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Assets - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

You are receiving the error message "Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed." in the Post Mass Additions log file.
The Post Mass Additions log file will always show this error if the Prepare Transaction Data request that is run before this completes in ERROR. Looking at the Prepare Transaction Data log file it will provide you
the real reason why the Post Mass Additions failed with this error.

In your case, it would show:

The depreciation method for this book is invalid.
The ADDITION transaction 300100090712986 failed for asset number 300100090712986.
fa_prepare_mass_additions_pkg.process_lines
User-Defined Exception
The number of records processed is 0.
The number of records that failed is 1.

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