My Oracle Support Banner

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

Last updated on APRIL 26, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.