My Oracle Support Banner

E-FLO: How to Setup Tags Correctly to Read in an XML File using File Layout and an Application Engine Program? (Doc ID 782438.1)

Last updated on DECEMBER 24, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Apr-2014***


Goal


The Goal is to load data file in XML format using File Layout and Application Engine, in a PT 8.4x environment. Having trouble with how the Record and Field tags need to be set in the File Layout to load the datafile. How can this be done?

Example of Data File to load;

<?xml version="1.0"?>
<CheckStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://xmlschemas.sentry.com/FOCUS/Name.FOCUS.Check-Reference">
           <batchDate>2009-01-21</batchDate>
           <batchId>PSAPS</batchId>
           <batchList>
                           <CheckRecord>
                           <checkNumber>00002221</checkNumber>
                           <checkReferenceNumber>17955</checkReferenceNumber>
                           <bankCode/>
                           <bankAccount/>
                           <checkAmount>2561.62</checkAmount>
                           <statusDate>2009-01-22</statusDate>
                           <statusCode>POSPAY</statusCode>
                           <origBatchID>PSAPS </origBatchID>
                           </CheckRecord>
                           <CheckRecord>
                           <checkNumber>00002222</checkNumber>
                           <checkReferenceNumber>17970</checkReferenceNumber> 
                           <bankCode/> 
                           <bankAccount/> 
                           <checkAmount>629.37</checkAmount>
                           <statusDate>2009-01-22</statusDate>
                           <statusCode>POSPAY</statusCode>
                           <origBatchID>PSAPS </origBatchID>
                           </CheckRecord>
          </batchList>
</CheckStatus>

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.