Thursday, March 23, 2017

SLA Hot Patch for After Upgrade Data Migration

a. Run this SQL script:
select * from gl_period_statuses where migration_status_code='P'
-- this script should return zero rows, only then should you consider running the SLA Hot Patch.

b. Take a backup of the xla_upgrade_dates table before running the SLA Hot Patch

c. Set a realistic date for the SLA: Initial Date for Historical Upgrade profile.

    (i)  Change the SLA: Initial Date for Historical Upgrade profile to 01-OCT-2015
    (ii) Then run the Hot Patch

adop phase=apply options=nocopyportion patchtop=$XLA_TOP/patch/115          patches=driver:xla5584908.drv hotpatch=yes options=forceapply

    (iii) Repeat the above steps for 6-month increments until all the data from start has been upgraded. 

    The 6-month increment is not a rule because it depends of the amount of history to be upgraded.


No comments:

Post a Comment