My Oracle Support Banner

DQ Rule Execution with Many Conditions Failed with ORA-06502 (Doc ID 1595304.1)

Last updated on JULY 31, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 to [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


On : 7.3.2 version, Unified Metadata Manager

When attempting to run a Data Quality (DQ) Rule with many conditions, the following error occurs.

6502-ORA-06502: PL/SQL: numeric or value error : character string buffer too small -> DQ Batch Execution- Failed.


1. Create a DQ rule with 15 and more conditions.
2. Executed the rule in the Data Quality Group Summary interface the single DQ rule fails with the above error.
3. If a condition is removed from the rule then the rule runs without any errors.


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.