My Oracle Support Banner

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 and later
Oracle Fusion Assets - Version and later
Information in this document applies to any platform.


On : 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


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

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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.