Meta Group

1
Process Manufacturing SIG
Archive Purge
Jerry Naples Independent Consultant JNaples_at_MSN
.com [phone]
2
Archive Purge
Release 10.7 11.0.3 11i
Applications 40 50 191
Objects 18,072 23,823 72,224
Tables 4,240 6,500 16,190
Columns 156,607 212,296 526,182
Whats inside Oracle Applications?
3
Oracle Product Rollouts
Release 10.7 Approximately 40 Products Release
11.0.X Approximately 50 Products Release
11.5.5 Approximately 161 Products Release
11.5.6 Approximately 175 Products Release
11.5.7 Approximately 179 Products Release
11.5.8 Approximately 191 Products Release
11.5.9 Approximately 197 Products
4
Why Archive Purge Data?

• Increase the Applications Performance
• Improved response time for end-users
• Minimize cost of performance tuning
• Enhanced Environment Efficiencies
• A much smaller window for downtime and for
  backups
• Reduce the time for the creation of test/dev
  environments
• Static Size for the Production Environment
• Makes production environment size more
  predictable

5
Using Oracles Purge (without an archiver)

• Attention You should be extremely cautious when
  purging transaction information. Once you commit
  the process, Oracle Inventory removes all related
  information from the database. You cannot view or
  report on this information once you purge it.
• Oracle Applications Manual

6
The Architecture of Archive / Purge
Production
7
Seamless Data Access
8
Archiver Parameter Screen

1. Choose Entities
2. Specify Parameters
3. Generate Candidates
4. Process Archive/Purge
5. Relocate History Data

9
Candidate Exception Reporting
10
Other Archive Purge Benefits
Data Reduction 10 30 Methodology Traditio
nal DELETE COMMIT Rules Constraints
Rigid Adherence to Oracle Applications DB
Rules
11
Key Product Features

• Archive/Purge Management Screens
• Flexible Business Rules
• Universal Parameter Concept
• Preview Candidates Exceptions
• Automated Space Reclamation
• Oracle Apps User Interface Archive Data Access
• Selective Data Restoration
• Extensions and Custom Apps

12
Case Study
Pre-Archive
Post-Archive

• Requirements
• 7 years transaction history
• GL Inv Maintained current 2 years
• AP PO Maintained current 3 years

Nets 45 Savings
13
Process Manufacturing SIG
Archive Purge
Questions?
Jerry Naples Independent Consultant JNaples_at_MSN
.com [phone]
14
Oracles Solution Purge Only

• Account Balances
• 1.       Permanently close all periods you want
  to archive/purge
• 2.       Create the required tablespace to hold
  your archived data
• 3.       Select the set of books to archive
• 4.       Select the Balance Type to Archive
• 5.       Select the Period(s) to archive
• 6.       Run concurrent process
• 7.       Review Archive Purge Audit report
• 8.       Export the Archive tables
• 9.       Copy the export files to tape
• 10.    Delete the export file from directory
• 11.    Select the set of books to archive
• 12.    Select the Balance Type to Archive
• 13.    Select the Period(s) to archive
• 14.    Run concurrent process
• 15.    Review Archive Purge Audit report
• 16.    Export the Archive tables
• 17.    Copy the export files to tape
• 18.    Delete the export file from directory

• Journal Detail
• 20.    Create the required tablespace to hold
  your archived data
• 21.    Select the set of books to archive
• 22.    Select the Balance Type to Archive
• 23.    Select the Period(s) to archive
• 24.    Run concurrent process
• 25.    Review Archive Purge Audit report
• 26.    Export the Archive tables
• 27.    Copy the export files to tape
• 28.    Delete the export file from directory
• 29.    Select the set of books to archive
• 30.    Select the Balance Type to Archive
• 31.    Select the Period(s) to archive
• 32.    Run concurrent process
• 33.    Review Archive Purge Audit report
• 34.    Export the Archive tables
• 35.    Copy the export files to tape
• 36.    Delete the export file from directory
• Export, Drop, Re-import 4 GL Detail tables

Purge another Set of Books?
Purge another Set of Books?
Y
Y
N
N

• Translated Balances
• Select the set of books to archive
• Select the Balance Type to Archive
• Select the Period(s) to archive
• Run concurrent process
• Review Archive Purge Audit report

Go to AR Purge
N
Purge another Set of Books?
Y