My Oracle Support Banner

Custom DQ rule save failed with error "operation failed" if sql query exceed 4000 characters (Doc ID 2652838.1)

Last updated on MAY 22, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to save DQ definition with custom sql with more than 4000 characters the following error occurs. Attached screenshot for reference.
ERROR
-----------------------
Operation failed

Cause

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
Symptoms
Cause
Solution
References


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