Post Mass Addition Fails During Prepare Assets Transactions Data: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2227791.1)

Last updated on MARCH 02, 2017

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

On : 11.1.11.1.0 version or later

When Post Mass Additions process completed, the following errors occurred in the log file for Post Mass Additions and Prepare Assets Transaction Data processes

ERROR
-----------------------

Post Mass Additions log file error:
Retrieving a row from the FA_CATEGORIES table for the category ID {CATEGORY} failed.
fa_cache_pkg.fazcat
ORA-01403: no data found

Prepare Assets Transaction Data log file error:
fa_prepare_mass_additions_pkg.process_massaddition_lines
ORA-01422: exact fetch returns more than requested number of rows

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate Fixed Asset Mass Additions FBDI and import file
2. Navigate to Schedule Processes > Click Schedule New Process and search for Post Mass Additions
3. Select Asset Book and click Submit

- OR - 

1. Navigate to Fixed Assets > Assets >Add Assets in Spreadsheet
2. Select Asset Book and Asset Type.  Log into Fusion and populate required fields in Excel spreadsheet
3. Click Submit and Post Transactions buttong

Process completes but errors out with the messages in the log file above

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