My Oracle Support Banner

How to Change the Length of Oracle Data Quality Data Parser Output Fields (Doc ID 755539.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 10.1.3.4.0 and later
Information in this document applies to any platform.

Goal

You are recoding some suffix in ODQ Customer Data Parser and the values are longer than the Parser output fields size limit of 15 characters.

For example:

'MYFILES INSURA' INS NAME DEF ATT=TTLS GEN='N' REC='MYFILES INSURANCE'

'MYFILES INSURA' should be recoded to 'MYFILES INSURANCE' but it has been truncated to 'MYFILES INSURAN'. 

So you increase the size of PR_NAME_SUFFIX_RECODED_01 field to be 32 characters but after running this batch the values are still truncated to 15 characters.

Solution

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
Goal
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.