Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Running the History Upgrade Scripts

Running the History Upgrade Scripts

To run the history upgrade scripts, copy the zip file to a directory on the history database server, unzip the file, create a link to the upgraded database, and run the scripts.
  1. Copy the upgrade scripts zip file to a directory on the history database server and unzip it.
  2. If you customized any PeopleSoft module accelerator, update the application changes script to reflect the changes.
    Replace the interim table name in the script with the interim table name you use in the customized module, and update the script to reflect any change to the default columns or the business rule names.
    For example, you customized the PY - N.A. Payroll module. You changed the interim table name to "XA_1111_HPY1" and added column "ORG_NAME" with datatype "VARCHAR2(15 CHAR)." Replace all occurrences of "XA_10969_HPY1" with "XA_1111_HPY1." Add the ORG_NAME column to the CREATE TABLE statement.
  3. Log in to the target history database as the owner.
  4. Create a database link on the history database that connects to the upgraded version of the PeopleSoft application.
    Use the following syntax:
    create database link <link name> connect to <history database> identified by <database password> using <E-Business TNS entry>;
  5. Go to the directory where you extracted the zip file, and then run the following command:
    chmod u+x migrate.sh
  6. Run the migrate.sh script:
    ./migrate.sh <history database user name>/<database password>@<link name>

0 COMMENTS

We’d like to hear from you!