DQ Rule Execution with Many Conditions Failed with ORA-06502
(Doc ID 1595304.1)
Last updated on SEPTEMBER 06, 2018
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 to 22.214.171.124.0 [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!