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

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!