Resolving the Post Mass Additions Request When it Errors with "Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed" (Doc ID 2285442.1)

Last updated on JUNE 02, 2023

Applies to:

Purpose

This document outlines the areas to review if you ever receive 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 will provide you
the real reason why the Post Mass Additions failed with this error.

You can see in the above screen shot that the Prepare Transaction Data request failed.

Looking at the Post Mass Additions Log, it shows:

 So that is the generic error that you will see in Post Mass Additions, however, to see the real issue, you need to review the Prepare Transaction Data Log file as shown below:

So you can see that the actual error is "The depreciation method for this book is invalid." and not the Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed one.

This is what was entered in the ADFDI spreadsheet:

This should have been entered in as STL not SLT. To troubleshoot which record, see Troubleshooting script 2).

This is a common error encountered when trying to Add assets via spreadsheets (ADFDI or FBDI).  To provide some background as to why this error occurs:

ROOT CAUSE

When the Submit or Post is run, the Prepare Transaction Data program first clears out the ASSET_CATEGORY_ID, DEPRN_EXPENSE_CCID as well as the DEPRN_EXPENSE_SEGMENT1, DEPRN_EXPENSE_SEGMENT2, DEPRN_EXPENSE_SEGMENT3 etc and the LOCATION_ID and LOCATION_SEGMENT1, LOCATION_SEGMENT2, LOCATION_SEGMENT3 etc. If there is only 1 item that is invalid (for example, the method code of SL instead of STL), the Prepare Transaction Data program ERRORs out and as a result, does not complete the bulk combination generation program (the program that generates the IDs (ie. Asset_category_Id, Location_id etc)) and stamps all records within this batch with the same error message. Now the ERROR only shows when the posting_status for the records is put to POST. If they are submitted with NEW or ON HOLD, then the error will not occur, but the items will be blanked out for the same reason.  So when this errors, (if the posting_status was set to 'POST'), then the Post Mass Additions which was run from the spreadsheet as well, will show the error 'Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed' in the log file.

 In the spreadsheet, the following are required to be valid in order for the generated ID to be inserted meaning that the Prepare Transaction Data process will complete successfully.

Review the Troubleshooting steps to resolve the issue.

Troubleshooting Steps

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