Frm-40735 Pre-Form Trigger Raised Unhandled Exception Ora-01422 On Rxi Reports Menu

(Doc ID 298489.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Property Manager - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

When accessing RXi reports in Property Manager it fails with the following error:

Navigate -> Reports -> RXi -> and anyone   e.g. Lease

FRM-40735: PRE-FORM trigger raised unhandled exception ORA-01422.
ORA-01422: exact fetch returns more than requested number of rows

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