North Central Oracle Applications User Group

1
North Central Oracle Applications User Group

• Run Faster with Applimation Archiver

2
Applimations Value Proposition
Our Application Management products empower
Oracle Applications customers to

• Enable effective change management

• Increase internal controls

• Control enterprise data growth

• Improve operating performance

• Reduce total cost of ownership

3
Suite of Products

• Setup Reporter
• Configurations and Setups
• Change Manager
• Forms, Reports, Code
• Applimation Archiver
• Archive purge
• Db Downsizer
• Create smaller test environments
• FlexChanger
• Change Chart of Accounts structure

Change Management Suite
Data Management Suite
Application Management Tools Throughout the
Lifecycle
4
Powered by the Applimation Platform

• Setup Reporter
• Configurations and Setups
• Change Manager
• Forms, Reports, Code
• Applimation Archiver
• Archive purge
• Db Downsizer
• Create smaller test environments
• FlexChanger
• Change Chart of Accounts structure

Change Management Suite
Data Management Suite
5
Certified by Oracle
Oracle Partner Program Member since 1998
Certified by Oracle Cooperative Applications
Initiative (CAI) Program, April 2000
Oracle Partner Technical Services (PTS)
organization approved the integration of
Crystallize Products through the Oracle
E-Business Suite Integration (EBSI) program, July
2001
Certified for use with all modules of Oracle
Applications
6
Applimation Customers
7
Applimation Archiver

• The Need for Speed
• Run Faster with Applimation Archiver

8
The Business Problem
Data Growth is Costly
With projected compounded annual growth rates
for databases exceeding 125, organizations face
two basic options continue to grow the
infrastructure (e.g., server size, storage
capacity) or develop processes to separate
dormant data from active data

• Charlie GarrySenior Program DirectorMETA Group

9
Increasing Complexity Data Growth
Whats inside Oracle Applications?
10
Why Archive Purge Data?

• Increase Application Performance
• Improved response time for end-users
• Minimize cost of performance tuning
• Enhance Environment Efficiencies
• Reduce downtime for backups
• Reduce time for creation of test/dev environments
• Improve Upgrade Timing
• Reduce downtime for Upgrades

11
Oracles Solution
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 February 2002
12
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
13
Application Data Management
Dev, Test, Patch, QA, Train,
PROD
Applimation Archiver
Db Downsizer
Data Reduction 10 30
gt50
Retention Policy Identify what NOT
to retain Identify what to retain
Methodology Traditional DELETE COMMIT
Java-based EXPORTgtTRUNCATEgtIMPORT
Rules Constraints Rigid Adherence APP DB
rules Flexible Rules data integrity
Applimation Archiver
Db Downsizer
Metabuilder
Applimation Platform
Tablespace Resizer
14
Key Product Features

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

15
Case Study
Pre-Archive
Post-Archive

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

Comcast Nets 45 Savings
16
For More Information