E-FLO: ReadRowset Does Not Truncate CSV Format Data If Input File Field Length Is Longer Than Database Field (Doc ID 2063097.1)

Last updated on OCTOBER 09, 2015

Applies to:

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

Goal

PT 8.51

When loading csv file to a DB table using file layout, if the length of an input data value for a field is longer than database field, the load abort.

Is there a way to configure the file layout to truncate the input field to the length of the database, so the load won't abort?
 

Solution

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