DQ Rule Execution with Many Conditions Failed with ORA-06502
Last updated on OCTOBER 25, 2013
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.
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