Asset Transfer Error "too many matching records"

Summary: After transferring an asset from Capital Projects with 941 invoice lines, only two lines successfully transfered and all attempts to view asset result in the error message "too many matching records found specify additional criteria to limit the number of records".

Content (required): Grants and Projects module and Fixed Assets module

Version (include the version you are using, if applicable): Fusion 23C

Code Snippet (add any code snippets that support your topic, if applicable): "too many matching records found specify additional criteria to limit the number of records