E-FLO: How to Check for Invalid Data format When Loading Flat File via File Layout? (Doc ID 949029.1)

Last updated on MARCH 10, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Jan-2012***
***Checked for relevance on 02-May-2014***


Symptoms


What is happening?
-----------------------
When a flat file is uploaded using either the generated Application Engine (AE) program from a file layout or a modified version of it with incorrect values (an incorrect date, a negative numeric value for a non-signed field, a value which is too long, or a text instead a numeric value), the system is not performing any checks.

The following is happening:

1. A text value to upload into a numeric field is replaced with 0.
2. An incorrect date is replaced with NULL.
3. A value which is too long for a text field is replaced with a " " (space).
4. A negative numeric value is uploaded in a non signed numeric field.


Business impact
--------------------
Having the system generate errors instead of replacing the incorrect data with another values is the only way  to know that the data is incorrect. Because of the current behavior, one cannot rely  on the system to make sure that the data is correct or not.


What should happen?
--------------------------
An error message should be displayed to inform the users about the incorrect values.

Environment
---------------
* Release: 9
* Tools: 8.49.19
* Last bundle/Maintenance Pack: unknown
* Environment: test



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