EAR 9.0+: How to Export PeopleSoft Data as Data Mover DAT Files or SQL Import Scripts? (Doc ID 1156173.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.51 [Release 8.4]
Information in this document applies to any platform.
*** Proactive Support Update 03-Mar-2011 ***


Goal

This document describes how to export data from your database, for sending to parties such as GCS Support. While there are many ways to exchange data, this document describes two formats which are typically available to PeopleSoft and Oracle database users:

 These methods are useful for exchanging amounts of data that would be cumbersome to enter manually.  They allow the receiving party to import the data into their local database to perform investigation or troubleshooting of data related issues.

I have sent data in a spreadsheet. Why can't one use data in a spreadsheet or xls file?
Spreadsheets are terrific for reviewing data offline but often present problems when imported from the spreadsheet into a database. Using Data Mover dat files or import scripts overcome these problems.

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