EAR 9.0+: How to Export PeopleSoft Data as Data Mover DAT Files or SQL Import Scripts?
Last updated on FEBRUARY 27, 2018
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 ***
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:
- Data Mover dat files
- Oracle import scripts
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.
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.
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