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

Last updated on MARCH 17, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

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

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