Showing posts with label Data Archive Manager. Show all posts
Showing posts with label Data Archive Manager. Show all posts

Thursday, October 25, 2012

Steps to Implement Data Archive Manager

Step1: Create Archive Object

image

Archive Record: Record from data need to archive.

Base Record: The record is selected is the base record of this archive object. This is a check box and only one can be base record.

History Record: History Record to which transaction data is needed to archive.

History Record Structure (Example):

1. Save as HR_ACCTG_LINE record to HRACTLN_HST and don’t copy any peoplecode associated with record HR_ACCTG_LINE.

2. Insert Subrecord PSARCHIVE_SBR at top in the record as shown in below image.

clip_image002

3. Build the table.

Step2: Create Archive Query

image

Archive Query contain Archive record name and all field selected.

Criteria: This is required to add criteria which filter the data for archiving.

Step3: Archive Template

image

Step4: Running Archive Process

image

Process Type:

1. Selection: Copy data from Archiving Record to History Record.

2. Delete: Deleting data from Archiving Record.

3. Remove from History: Deleting data from History Record.

4. Rollback: Copy data from History Record to Archiving record.

Note: Select the process type and run the process.