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

Updated Application Changes Script Example

Updated Application Changes Script Example

If you customized any PeopleSoft module accelerator, you must update the application changes script to reflect the changes.
For example, you upgraded from PeopleSoft 8.9 to 9.1. You customized the PY-N.A. Payroll module by changing the interim table name to "XA_1111_HPY1" and adding a column "ORG_NAME" with datatype "VARCHAR2(15 CHAR)."
Update the application changes script, HRMS_HPY_PS89_To_PS91_Upgrade_Appl_Changes.sql, as follows:
if NOT migration_util.table_exists('
XA_1111_HPY1
) THEN migration_util.execute_immediate('CREATE TABLE
XA_1111_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),
ORG_NAME VARCHAR2(15),
APPLIMATION_JOB_ID NUMBER(38) NOT NULL)'); end if; if migration_util.table_exists('
XA_1111_HPY1
') THEN migration_util.execute_immediate('INSERT INTO
XA_1111_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!