1 / 14

Jerry Naples – Independent Consultant JNaples@MSN (727) 244-2277

Process Manufacturing SIG. Archive & Purge. Jerry Naples – Independent Consultant JNaples@MSN.com (727) 244-2277. Archive & Purge. What’s inside Oracle Applications?. Oracle Product Rollouts. Release 10.7 Approximately 40 Products Release 11.0.X Approximately 50 Products

ida
Download Presentation

Jerry Naples – Independent Consultant JNaples@MSN (727) 244-2277

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Process Manufacturing SIG Archive & Purge Jerry Naples – Independent Consultant JNaples@MSN.com (727) 244-2277

  2. Archive & Purge What’s 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. Increase the Application’s 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 Why Archive & Purge Data?

  5. Using Oracle’s 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 orreport on this information once you purge it.” • Oracle Applications Manual

  6. Archive / History Archive HOME APPS GL AR Archive Database Repository PO AP OE INV Schema that contains the Archiver “engine” Schema that contains seed data and programs used by the user interface Schema that contains permanent repository of archive data Archive Schema that acts as relocation area during Archive process Relocation The Architecture of Archive / Purge Production

  7. Seamless Data Access

  8. Archiver Parameter Screen • Choose Entities • Specify Parameters • Generate Candidates • Process Archive/Purge • Relocate History Data

  9. Candidate Exception Reporting

  10. Production Environment Other Archive & Purge Benefits Data Reduction 10 – 30 % Methodology Traditional DELETE & COMMIT Rules & Constraints Rigid Adherence to Oracle Applications’ DB Rules

  11. 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 Key Product Features

  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@MSN.com (727) 244-2277

  14. Oracle’s “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 • Export, Drop, & Re-import GL_BALANCES table • 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 N Y 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

More Related