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. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Step 2. Run the Create History Table Job with the Original Source

Step 2. Run the Create History Table Job with the Original Source

Run the Create History Table job with the source connection version set to the original application version.
The Create History Table job uses the metadata for the original application version. For example, if you upgrade Oracle E-Business Suite from version 11.5.10 to R12, the job uses the metadata for version 11.5.10.
The job performs the following actions:
  • Adds new columns to existing tables in the history database.
  • Processes tables that the upgrade scripts did not process.
  • Adds columns that can contain null values to the history database tables.
  • Verifies that tables not managed in the upgraded application version are updated properly.
This Create History Table job fails if it attempts to add a column that cannot hold null values to a table with data. If the job fails, run the history upgrade scripts for the module to which the table belongs.

0 COMMENTS

We’d like to hear from you!