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

(Doc ID 2360918.1)

Last updated on FEBRUARY 13, 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 State
{SEGMENT}=State /County
{VALUE}=YN

The location is invalid. Enter a valid location.

The ADDITION transaction 300100132085375 failed for asset number 300100132085375.

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