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 FEBRUARY 23, 2017

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

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