Vendor Parameter Has Column Limit Of 256, But More Is Required (Doc ID 2267861.1)

Last updated on MAY 18, 2017

Applies to:

Siebel Data Quality - Version 16.0 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.0 [IP2016] version, System Admin

ACTUAL BEHAVIOR
---------------
Vendor Parameter has column limit of 256, but more is required

Vendor Parameter for Data Quality, entered in the following:

Administration - Data Quality > Third Party Administrator > Vendor Parameter

Buscomp: DQ Vendor Parameter (table S_DQ_SYST_PARM)
Field: Value (column VALUE)

OOTB field length is 100 for field Value.

OOTB column length is 255 for column VALUE.

The concern is with Token/Query Expressions (such as 'Contact Token Expression' and 'Contact Query Expression'). Administrators are unable to create more complex expression as they are limited to 256 characters. Since this is a Standard Field/Column, it is not supported to modify or increase the length.

EXPECTED BEHAVIOR
-----------------------
Admins would like to have the field longer to accomodate more complex Token and Query expressions.

STEPS
-----------------------
Navigate to: Administration - Data Quality > Third Party Administration > Vendor Parameter
Notice that you cannot enter a value more than 100 initially, and see that base on the table you are limitting the length to 256.

BUSINESS IMPACT
-----------------------
Due to this, Admins are limited on their Token and Query expressions.

Cause

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