EAR 9.0+: How to Export PeopleSoft Data as Data Mover DAT Files or SQL Import Scripts?
(Doc ID 1156173.1)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!