My Oracle Support Banner

Oracle Fusion Recruiting Cloud: OTBI: Error Reporting on Descriptive Flexfield (DFF): "ORA-01427: single-row subquery returns more than one row" (Doc ID 2818957.1)

Last updated on DECEMBER 14, 2021

Applies to:

Oracle Recruiting Cloud Service - Version and later
Information in this document applies to any platform.


Problem Description:

When including a Descriptive Flexfield (DFF) in an OTBI report/analysis, the analysis returns the following error:

ORA-01427: single-row subquery returns more than one row



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.