My Oracle Support Banner

Depreciation Expense Accounts Not Valid Issue For "Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed" Error (Doc ID 2361407.1)

Last updated on FEBRUARY 14, 2018

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 a similar message to:

FLEX-VALUE DOES NOT EXIST
{VALUESET}=Operations Department
{SEGMENT}=Department
{VALUE}=117

The expense account is invalid. Enter a valid expense account.

The ADDITION transaction 300100132085379 failed for asset number 300100132085379.

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!


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