E-DMW: ADS Instance Is Longer Than 254 Characters (Doc ID 2232944.1)

Last updated on NOVEMBER 23, 2019

Applies to:

Symptoms

ACTUAL BEHAVIOR
-------------------------------
Field PSPROJADSBIND.PTADSBINDID only allows values <= 254 characters. If value of PSPROJADSBIND.PTADSBINDID > 254 characters the selected value is not inserted.

EXPECTED BEHAVIOR
-------------------------------
If value of PSPROJADSBIND.PTADSBINDID > 254 characters the selected valued should be inserted.

STEPS
-----------------------
1. Create a new ADS that only contains 1 record (VAT_DEFAULTS).
2. Configure a business unit with VAT defaults
3. Create a DMW project that only contains 1 ADS (VAT_DEFAULTS)
4. Try to insert the VAT data set-up in step 2 into the DMW project.
5. You will see that not all the VAT defaults are inserted into the DMW project. Only data that is inserted is data where the field PSPROJADSBIND.PTADSBINDID < 255 characters.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.