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 03, 2024
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:
- 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.
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.
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
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 |