Create Asset Headers In Oracle Projects - Normal Items Request fails with ORA-01422

(Doc ID 1987877.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Asset Tracking - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Create Asset Headers in Oracle Projects - Normal Items request completes with status 'Normal', but no asset headers are created for the project and task. The log file includes the following error message.

Error Message ORA-01422: exact fetch returns more than requested number of rows

The issue can be reproduced at will with the following steps:

1. Asset Tracking Super User >> Request >> Run >> Create Asset Headers in Oracle Projects - Normal Items


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