My Oracle Support Banner

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 FEBRUARY 03, 2019

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.

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:

Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed.
fa_cache_pkg.fazcat
ORA-01403: no data found
The mass addition ID ########## failed.
The number of records processed is 0.
The number of records that failed is 1.
Asset Numbering completed
The module Post Mass Addition ended with an error.
fa_massadd_pkg.main
User-Defined Exception

 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:

The depreciation method for this book is invalid.
The ADDITION transaction ######## failed for asset number ##########.
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.

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.

ITEM TABLE SOURCE COLUMNS GENERATED ID
Asset Key FA_MASS_ADDITIONS ASSET_KEY_SEGMENT1, ASSET_KEY_SEGMENT2, ASSET_KEY_SEGMENT3 etc ASSET_KEY_CCID
Category FA_MASS_ADDITIONS CATEGORY_SEGMENT1, CATEGORY_SEGMENT2, CATEGORY_SEGMENT3 etc ASSET_CATEGORY_ID
Depreciation Expense Account FA_MASSADD_DISTRIBUTIONS DEPRN_EXPENSE_SEGMENT1, DEPRN_EXPENSE_SEGMENT2, DEPRN_EXPENSE_SEGMENT3 etc DEPRN_EXPENSE_CCID
Depreciation Method FA_MASS_ADDITIONS METHOD_CODE, LIFE_IN_MONTHS METHOD_ID
Invoice Number FA_MASS_ADDITIONS INVOICE_NUMBER, VENDOR_NUMBER INVOICE_ID
Location FA_MASSADD_DISTRIBUTIONS LOCATION_SEGMENT1, LOCATION_SEGMENT2, LOCATION_SEGMENT3 etc LOCATION_ID
Prorate Convention FA_MASS_ADDITIONS PRORATE_CONVENTION_CODE CONVENTION_TYPE_ID

Review the Troubleshooting steps to resolve the issue.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
References

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