Category Combinations 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 APRIL 07, 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}=Vision FA Minor Category
{SEGMENT}=Minor Category
{VALUE}=XX

This category combination is invalid. Enter a valid category combination.

The ADDITION transaction ######### failed for asset number ########.

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