Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Install
  4. Data Archive Installation
  5. Data Vault Installation
  6. Application Accelerator Installation
  7. Application Retirement for Healthcare Accelerator Installation
  8. MongoDB Accelerator Installation
  9. Salesforce Accelerator Installation
  10. After You Install
  11. Data Archive Upgrade
  12. Data Vault Upgrade
  13. Upgrading Oracle History Data
  14. Upgrading PeopleSoft History Data
  15. ILM Data Validation Option Setup
  16. Data Archive Source and Target Database Requirements
  17. Data Archive Connectivity
  18. Data Archive Uninstallation
  19. SAP Application Retirement
  20. Database Users and Privileges
  21. Data Visualization Designer Installation
  22. Data Archive Installation Requirements Checklist and Architecture Options

Installation and Upgrade Guide

Installation and Upgrade Guide

Original Application Changes Script Example

Original Application Changes Script Example

The application changes script creates the tables and application data changes in the history database schema to replicate the PeopleSoft upgrade process. To support restoring the old version of data with the new entities, this script also moves data from the old interim tables to the new interim tables.
If you upgrade from PeopleSoft 8.9 to 9.1, the application changes script is HRMS_HPY_PS89_To_PS91_Upgrade_Appl_Changes.sql.
This script contains the following commands:
if NOT migration_util.table_exists('XA_10969_HPY1) THEN migration_util.execute_immediate('CREATE TABLE XA_10969_HPY1 (COMPANY VARCHAR2(3), PAYGROUP VARCHAR2(3), PAY_END_DT DATE, OFF_CYCLE VARCHAR2(1), PAGE_NUM NUMBER(4), LINE_NUM NUMBER(2), EMPLID VARCHAR2(11), PURGEABLE_FLAG CHAR(1), STATS_DATE DATE, ORG_ID VARCHAR2(5), ALL_PAGES_CONFIRMD NUMBER(31), ALL_EARNS_FINALIZD NUMBER(31), APPLIMATION_JOB_ID NUMBER(38) NOT NULL)'); end if; if migration_util.table_exists('XA_10969_HPY1') THEN migration_util.execute_immediate('INSERT INTO XA_10969_HPY1 (COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM, LINE_NUM, EMPLID, PURGEABLE_FLAG, STATS_DATE, ORG_ID, ALL_PAGES_CONFIRMD, ALL_EARNS_FINALIZD, APPLIMATION_JOB_ID) SELECT COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM, LINE_NUM, EMPLID, PURGEABLE_FLAG, STATS_DATE, ORG_ID, ALL_PAGES_CONFIRMD, ALL_EARNS_FINALIZD, APPLIMATION_JOB_ID FROM XA_797_HPY1'); end if;

0 COMMENTS

We’d like to hear from you!