Table 6-1 Validations and Checks

Before txns posting
Set logging parameter to 'N'
Turn scheduler off on Test system
Ensure that setup tables are not truncated before refresh (only in case of a new refresh).
Ensure that jobs, job_sets, job_threads and job_buckets are copied over from Prod onto test (only in the case of new refresh).
Make sure that the batch jobs are setup the same in Prod and Test.
Ensure sequences are in sync with Production
Bump up sequences - recreate sequences
Ensure that the Test specific setup scripts are run for 1) all seed data 2) DML scripts to create data in the new tables
Check GL post date
Check log tables have just one day's transactions
Query by txn_tcd_code, check numbers match on Prod and Test
Drop index TXNT_LOG_UDX
Make sure that the batch jobs have no sequence numbers overlapping - the scheduler might not start because of this.
Run all the DML scripts - for seed data and others
Check for database locks on both test systems
Check run_dt_nxt on all batch jobs - should be updated correctly