E-FLO: How to Import Data into Multiple Records Using File Layout with Example code (Doc ID 639508.1)

Last updated on JUNE 02, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.2 to 8.4 [Release 8.2 to 8.4]
Information in this document applies to any platform.
***Checked for relevance on 23-May-2012***
***Checked for relevance on 09-May-2014***

Enterprise PeopleTools Any Release.

This document was previously published as Customer Connection Solution 200972735




Symptoms

Here is a simplified example of the behavior you might be encountering.  This example uses the PeopleCode from the auto-generated Application Engine (AE) program.

This File Layout Includes 4 records, Fixed Format.
VA_DUNCMNT_A
VA_DUNCMNT_Z
VA_COMMENT
VA_DUNNING

Using the File Record ID property for each record, we are expecting to see the file layout read from a single data file, and import the data into all 4 records.  The actual result is that only the first record (VA_DUNCMNT_A) is getting populated with data.

The preview in Application Desinger shows the data correctly for all 4 records, but only the first record in the file layout structure is getting populated.

Also, the data that is inserted into VA_DUNCMNT_A is not the same as shown on the preview in AppDesigner. The fields do not contain the correct values.

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