A number of trends in the IT industry have contributed to the increasing size of ERP application databases and show no signs of abating. These include dramatic reductions over recent years in the cost of disk, such that it has often been easier to buy more disk than to embark on an archiving project. The trend towards replacing point solutions with an integrated application suite, such as Oracle Apps, results in large databases of transaction data – extrapolate it out for a few years and the subject of archiving becomes pertinent. Databases with high volumes of transactions, a defining characteristic of ERP applications, rapidly increase in size and memory requirements. This can have a detrimental impact on performance for both online and background processing, which becomes business critical when applications such as manufacturing or order management are part of the picture.
When the favorite approach of a business to an increasing volume of data is to throw more hardware at it in preference to archiving it, it increases the total cost of ownership for the application though the cost of performance tuning, additional disk, processors, controllers, support agreements and so forth.
It’s like cleaning out the garage - we all know we should, but somehow it’s difficult to get around to it. This discussion is the one-hour summary of the archiving and purging functionality available within Oracle Applications.
The discussion summarises archiving across Applications, how to submit the purge processes, criteria for records to be purged, what information does and does not get purged, the tables information is purged from and how to restore archived information. For the purpose of this discussion, any program which archives or purges information from the applications has been included, whether or not it is strictly an ‘Archive’ process.
Fixed Assets has two types of archive and purge processes:
1) Mass Additions
2) Depreciation and Adjustment Transaction records
The Delete Mass Additions program archives mass additions to an archive table, where they are then able to be purged.
The Delete Mass Additions program removes mass additions in the DELETE and POSTED queues. It also removes SPLIT parents if the split children have been posted or deleted. The program archives mass additions in the DELETE queue only to an audit trail table, FA_DELETED_MASS_ADDITIONS.
To delete mass additions:
Responsibility: Fixed Assets Manager
(N) Mass Additions > Delete Mass Additions
To purge the audit trail for deleted mass additions:
Responsibility: Fixed Assets Administrator
(N) Purge > Mass Additions
Archive and purge transaction and depreciation data for the book and fiscal year you specify to release disk space for current data. If you do not need to run reports for previous fiscal years, you can copy the data onto tape or any storage device, and then delete it from your system. If you later need these records online, you can reload them into Oracle Assets.
Oracle Assets maintains an audit trail of which fiscal years you have archived, purged, and restored, and how many records were processed. If your system fails during a purge, you can safely resubmit it. Oracle Assets only processes those records which it has not yet processed.
You must purge fiscal years in chronological order. Before you purge a fiscal year, you must archive and purge all earlier fiscal years. You cannot purge periods in the current fiscal year. If your current period is the first period of a new fiscal year, you cannot purge the previous period. You can only restore the most recently purged fiscal year, so you must restore fiscal years in reverse chronological order. You cannot archive and purge the period prior to the current period.
You must allow purge for the depreciation book you want to purge in the Book Controls window. To prevent accidental purge, leave Allow Purge unchecked for your books, and check it only just before you perform a purge.
You submit archive, purge, and restore in the Archive and Purge window. Oracle Assets provides this window only under the standard Fixed Assets Administrator responsibility. You should limit access to this responsibility to only users who require it.
If you are archiving a large number of records for a fiscal year, you can update the FA:Archive Table Sizing Factor to specify the size of the temporary tables created by an archive. Specifically, if the number of rows Oracle Assets will archive multiplied by the average rowsize of that table for all three tables is very different from 100,000 bytes, you may want to adjust the FA: Archive Table Sizing Factor.
The purge program removes the depreciation expense and adjustment transaction records for the book and year you specify. However, it does not remove the asset identification, financial, and assignment information for your assets, including assets you retired or that became fully reserved during that fiscal year.
To restore records that you have purged from Oracle Assets, you must first import the tables from your archive, then perform the restore. You do not need to archive the records before you purge them again.
Since the archive number is part of the temporary table name, Oracle Assets restores only the records that were archived during that archive you specify.
To archive and purge transaction and depreciation data:
Responsibility: Fixed Assets Administrator
(N) Archive and Purge Enter the Book and Fiscal Year (B) Archive Export the archive tables Requery the archive (B) Purge Drop temporary archive tables
To restore archived data:
Responsibility: Fixed Assets Administrator
Import the archive tables from your storage device (N) ??? > Archive and Purge Query the archive to be restored (B) Restore
When you perform the archive, Oracle Assets assigns a reference number to it and copies the depreciation expense and adjustment transaction records to three temporary tables:
• FA_ARCHIVE_SUMMARY_<Archive_Number>
• FA_ARCHIVE_DETAIL_<Archive_Number>
• FA_ARCHIVE_ADJUSTMENT_<Archive_Number>
You can export the temporary archive tables onto tape or any storage device. If you need these records again, you can restore them. You must archive records before you can purge them, and Oracle Assets prevents you from running purge if these tables do not exist. You should not drop the tables until after you have exported the tables and run purge.
Depending on your business needs, you can archive records at one of three levels of detail: ’header– level’, ’header and line– level’, and ’header, line, and distribution– level’. Transactions are purged from the database based on the parameters you specify. The purge process will remove eligible transactions and all activities relating to these transactions such as adjustments, credits, reversals, calls, sales credits, and receipts.
Transactions and all activities relating to the transactions such as adjustments, credits, reversals, calls, sales credits, and receipts must meet the following criteria:
All transactions must be posted to GL. Receivables considers a transaction to be posted if every record relating to the transaction has a GL Posted date (this does not apply to transactions not eligible for posting if the Postable Only parameter is set to No). Standard Archive and Purge program: Transactions applied to commitments are not eligible for purge until the commitment is closed. A commitment is considered closed when the commitment balance (or if it is a deposit the deposit balance) is zero. Call New Archive and Purge: Transactions applied to commitments are not eligible for purge. If the GL Date Type parameter is:
Note: The GL Date Type parameter does not apply if you choose to include transactions not eligible for posting. In this case the transaction date will be used for date checking. This parameter applies only to the standard Archive and Purge program.
All transactions must be closed (for example, the payment schedules have no amount due). This does not apply if you choose to include transactions not open to receivables. These transactions do not have a payment schedule and therefore are not checked. If the transaction is a receipt, it must be related to transactions eligible for purge, unless it is a reversed unapplied receipt in which case it may not be related to any transaction. If the transaction is a receipt, it must be fully applied or unapplied and reversed. For example, the status of the latest AR_CASH_RECEIPT_HISTORY record must be ’Cleared’, ’Risk_Eliminated’, or ’Reversed’, or for Debit Memo reversals the reversal date must be not null. All transactions must meet the purge parameters you specify. Miscellaneous Transactions will not be Purged unless you run Archive/Purge for all customers, because they are not related to specific customers. The following are general rules transactions must meet to be considered closed:
Attention: The Call New Archive and Purge program does not purge deposits, guarantees, miscellaneous receipts or any items linked to these transactions.
Cash Management has two areas which can be archive and/or purged:
1) Bank Statement Interface Tables
2) Bank Statements
After you import a bank statement into Cash Management, you can purge its information from the bank statement open interface tables. You can also archive the information before you purge it. Purge and archive can also be run against the bank statement tables.
Two Cash Management system parameters are used to automatically archive and / or purge the interface tables after AutoReconciliation has run.
You cannot archive transactions without also purging them. However, you can purge transactions without archiving. Also note, the purge and archive check boxes on the System Parameters window affect only the bank statement interface tables.
Unlike the Interface Tables, to purge or archive/purge bank statement tables, you must run the Archive/Purge program.
The purge process deletes all header and statement line information from either the open interface tables or the bank statement tables. When you purge a bank statement, you must also purge the relevant transaction data. You can purge bank statement information without archiving it first.
Warning: If you use Cash Management to reconcile journal entries in General Ledger, you should run the Cash Management Purge program before you purge journals in General Ledger.
With archiving, you can save copies of your bank statement information.
You cannot archive without also purging. When you archive, Cash Management copies all header and statement line information from either the open interface tables or the bank statement tables into special archive tables the system maintains. To save your archived information to a file you must use the ORACLE RDBMS Export utility. To restore information from a saved archive file, you must first use the ORACLE RDBMS Import utility to populate the special archive tables. Then, you must run a custom SQL*Loader script to transfer the information from the archive tables to the bank statement or open interface tables.
General Ledger has four areas which can be archive and/or purged:
When you run a consolidation in audit mode, General Ledger maintains an audit trail for the Consolidation Audit Report, the Unmapped Subsidiary Accounts Report, and the Disabled Parent Accounts Report. After you run these reports, you can purge supporting source data from the GL_CONSOLIDATION_AUDIT table.
Once you purge your consolidation audit data, you can no longer run the consolidation audit reports. However, you can still review your consolidation journal batch in your parent set of books.
To purge consolidation audit data:
(N) Navigate to the Purge Consolidation Audit Data window. Select a Consolidation Name and Period to purge. You can purge any consolidation run in audit mode. (B) Purge
A move/merge operation populates two interim tables, GL_MOVEMERGE_BAL_<move/merge request id> and GL_MOVEMERGE_DAILY_BAL_<move/merge request id>, with the balances being moved or merged. The information in these tables is retained after a successful move/merge because it is needed to reverse the move/merge.
When you are satisfied that the results of a move/merge are correct and that you want to retain the new balances, you should purge the tables. Do not purge the tables if you think you may want to reverse the move/merge later.
If you reverse a move/merge operation, the interim tables will be purged automatically.
To purge the interim move/merge tables:
(N) Navigate to the Mass Maintenance Workbench window. Query the move/merge request whose interim tables you want to purge. (B) Purge.
You can archive and purge account balances, as well as journal batches, entries, lines, and associated journal references for one or more accounting periods, provided the periods are permanently closed.
You can archive and purge actual, budget, or encumbrance balances. In addition, for translated actual and budget balances, you can purge them before you rerun your translation. Except for translated balances, you must archive balances or journals before you can purge them.
Note: If you have average balance processing enabled in your set of books, your average balances will be archived and/or purged automatically, at the same time that you archive and purge your standard balances.
Attention: When you rerun the Archive program, you overwrite the data in the archive tables. Therefore if you have previously run the archive process, be sure to export your archived data to an operating system file and to save the file to tape.
Oracle Payables has four areas which can be archive and/or purged:
You can delete Oracle Payables, Oracle Purchasing and Oracle Supplier Scheduling. You can purge invoices, purchase orders, suppliers and related records such as invoice payments, supplier schedules, and purchase receipts.
After a record is purged, it is no longer queryable and the record will no longer appear on standard reports. However, the system maintains summary information of deleted records to prevent you from entering duplicate invoices or purchase orders.
If you are purging invoices, the Purge program purges related invoice distributions, invoice approvals, and invoice batches. You can purge invoices that meet the following criteria:
If you are purging payments, the Purge program deletes related invoice scheduled payments. You can purge payments that meet the following criteria:
You can purge suppliers that meet the following criteria:
You can purge requisitions that meet the following criteria:
If you are purging purchase orders, the Purge program deletes related purchase requisitions, and receipts. You can purge purchase orders that meet the following criteria:
If Oracle Supplier Scheduling is installed, you can purge supplier schedules that meet the following criteria:
If Oracle Supplier Scheduling is installed, you can purge CUM Periods that meet the following criteria:
Oracle Order Management has three areas which can be archive and/or purged:
The Purge Orders concurrent program enables you to purge selected closed orders and their workflow history. You first determine which orders you wish to purge by creating a Purge Set. Once orders have been selected for purging within a purge set, you can then choose to purge the entire set, a subset of the Purge set, or to cancel the purge.
Orders can only be purged if they meet the following conditions:
Purge Set Creation
A purge set is a set which will contain orders to be purged based upon user specified criteria. Purge set can be created in the following two ways:
Purge Set Creation using the Create Purge Set Concurrent Program Multi-selection of orders within the Order Organizer window and then invoking the Create Purge Set Concurrent Program from the Tools Menu. Purge Set Creation using the Create Purge Set concurrent program
(N) Orders, Returns > Order Purge > Order Purge Selection
(N) Orders, Returns > Order Purge > Order Purge
Purge Set Creation by multi-selection
The Purge Imported Credit Exposure concurrent program enables you to purge imported external credit exposure records by operating unit and exposure source. If you have imported external credit exposure records for multiple operating units, in order to purge all external credit exposure records you will need to submit the concurrent program for each operating unit you have imported external credit exposure records for.
The Message Purge concurrent program purges Order Management messages that are generated during order processing. To keep the Oracle Order Managmenet Message tables at manageable sizes, you should submit the Message Purge concurrent program at periodic intervals. After the concurrent program has successfully completed, you can use the Process Messages window and to verify that the Order Management message tables have been purged as specified by the input selection criteria.
(N) Orders,Returns >Purge Messages
You must use the Resolve / Purge Exceptions Parameters window to resolve and purge shipping exceptions. You cannot select, resolve and purge shipping exception records from the View Exceptions window.
To resolve and purge selected logged shipping exceptions:
1. (N) Shipping Transactions (M) Tools > Resolve Exceptions
Or (N) Shipping > Exceptions (M) Tools > Resolve / Purge Exceptions
Oracle Inventory has three areas which can be archive and/or purged:
Transaction Purge and Global Transaction Purge Purge Standard Cost History Purge a Margin Analysis Load Run Purge Replenishment Count Purge Cost Information Purge ABC Information Delete Items Inventory Position Purge Purge Cycle Count Purge Physical Inventory
Global Transaction Purge
Use the Global Transaction Purge Report to purge inventory transactions across multiple organizations set up in an organization hierarchy.
Instructions (N) Other > Reports > Run
‘Global Transaction Purge’
Transaction Purge
Purge all transaction history and associated accounting information for your current organization, where the transaction date is before and including the purge date you enter and is in a closed period.
G Once an inventory period has been closed it cannot be reopened. As a result, many companies choose not to close any inventory periods until required to for purging, so it is likely that there are no closed inventory periods in the production database.
Note: 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. For example, you can no longer report purged information with the Accrual Reconciliation Report, the Transaction Register, and so on.
Note: Since the Job/Lot Composition functionality in Oracle WIP depends on the material transaction history, you should not enter a purge date which purges material transactions that are part of a genealogy you want to retain.
(N) Transactions > Purge
When you update costs and choose to save details, information associated with the update is retained so that you can rerun adjustment reports. When you no longer need such information, purge it.
(N) Costs > Standard Cost Update > Purge Cost Update History
You can purge only those previous margin analysis load runs which are not continuous. Margin Analysis Load Runs created with Oracle Order Management installed are continuous and cannot be purged.
(N) ???? Purge Margin Analysis Run
You can purge replenishment information including the count name, counting methods and quantities.
(N) Counting > Replenishment Counts > Purge
You can purge cost types and all costs within the cost type. Or you can purge only part of the cost information, such as make or buy items, resource and outside processing costs, overhead rates and amounts or resource and overhead associations.
You cannot purge frozen costs in standard costing or average costs in average costing
You can safeguard selected cost types from inadvertent purging by disabling the Allow Updates check box when defining cost types.
(N) Costs > Cost Mass Edits > Purge Cost Information
You can submit a request to purge either ABC assignment group or ABC compile information.
Purging an ABC group deletes all item assignments to ABC classes for the assignment group you specify as well as the ABC group itself.
Purging an ABC compile deletes all item values and rankings for the ABC compile you specify as well as the ABC compile itself. You can purge an ABC compile if no ABC groups are using it.
Note: You delete an ABC class from the ABC Class window.
To Purge ABC Assignment Group:
(N) ABC Codes > ABC Group
Select the group you want to purge
(M) Tools > Purge Group
(B) OK
To Purge ABC Assignment Compiles:
(N) ABC Codes > ABC Compiles
Select the compile you want to purge
(M) Tools > Purge Compile
(B) OK
The major use of item delete is to correct data entry errors. Oracle Inventory checks all possible references to an item and does not allow it to be deleted until every reference is removed. This means that if you transact an item, for example, you must first purge the transactions before you can delete the item.
Note that deleted items are not archived.
You can delete unused inventory position data sets using flexible criteria.
(N) Other > Requests > Run ‘Inventory Position Purge’
To purge cycle count information:
(N) Counting > Cycle Counting > Cycle Counts
Select a cycle count
(M) Tools > Purge Cycle Count
This process allows you to purge all cycle count entries from the open interface.
(N) Other > Requests > Run
‘Purge Cycle Count Entries Open Interface Data’
You can delete a physical inventory definition from the database. Oracle Inventory deletes all information associated with the physical definition. However, the purge does not affect any adjustments or adjustment transactions made using the physical definition. Those adjustments are not changed. You can also purge just tags if you made a mistake and want to start over.
(N) Counting > Physical Inventory > Physical Inventories
Select the physical inventory you want to use
(M) Tools > Perform Purge
Oracle Projects has three areas which can be archive and/or purged:
After you create invoices in Payables and then tie them back, you can create more space in your database by prging imported Oracle Projects expense reports from the Payables interface tables. To do so, identify the date through which you want to purge expense reports when you submit Payables Invoice Import. Payables purges the expense reports during the import process.
For expense reports created in iExpenses, you can have the Payables Invoice Import program purge imported information. The pure occurs after the program creates invoices from expense report information and the tieback process is complete.
You can purge imported transactions from the interface table either automatically or manually:
To purge imported transactions automatically, you specify that a particular transaction source is purgeable (transaction source has Purge After Import = Yes) To purge imported transactions manually use SQL*Plus to remove the records from the interface table
The Account Generator: Purge Runtime Data profile option indicates whether to purge the data used to build account combinations as soon as the account generator is completed.
For best performance, set this profile option to No and then purge the runtime data in a separate operation. Setting the profile option to No retains (in the Oracle Workflow tables) the data used by the account generator to generate code combinations. To purge the data, run the Purge Obsolete Workflow Runtime Data program after the account generator process has executed successfully.
Setting this profile option to Yes purges the Oracle Workflow data as soon as the account generator has completed but may slow the performance of the account generator.
Archive and Purge allows you to purge unwanted project data from your production database and optionally archive the data to a set of parallel tables. There are four categories of data that can be purged and archived.
The type of data you can purge (and archive) depends on the Project Type Class and Project Status.
The archive and purge function does not purge project setup information (such as work breakdown structure), budgets, status reports and team templates.
Purging projects involves four steps:
Oracle Purchasing has three areas which can be archive and/or purged:
Oracle Purchasing transactions are purged using the Oracle Payables purge processes.
To purge a sourcing rule or bill of distribution
Use the Purchasing Database Administration process to initiate concurrent processes that purge obsolete records in Purchasing interface tables and other temporary tables. You need to run this process only once because the AutoSubmit process resubmits itself daily after you submit it the first time.
The Purge Purchasing Open Interface Processed Data process purges data in the Purchasing Documents Open Interface tables. You can purge this data after you have imported the data into Purchasing. This process purges only accepted or rejected data, not data that is still pending.
In the Submit Requests window, select Purge Purchasing Open Interface Processed Data
To purge the workflow runtime tables use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data”.
Navigate to the Submit Requests form in Oracle Applications to submit the Purge Obsolete Workflow Runtime Data concurrent program.
You can supply the following parameters for the Purge Obsolete Workflow Runtime Data concurrent program:
Note: If you have implemented Oracle Applications Manager, you can use Oracle Workflow Manager to submit and manage the Purge Obsolete Workflow Runtime Data concurrent program..
Use this program to delete:
Use this program to compute performance statistics for each of the concurrent programs, if the Concurrent: Collect Request Statistics profile option is set to “Yes”.
Use this program to purge Sign-On Audit information created before a specified date.
The following data is deleted:
To purge uploaded files form the Generic File Manager, run the concurrent program, Purge Obsolete Generic File Manager Data.
This concurrent program should also be used to periodically delete obsolete data. It is recommended that you schedule this program to run every day or so, using the default parameter values.
Archiving and Purging within each of the applications involves several steps, some of which may be performed by the Systems Administrator or a key user, others by the Database Administrator:
The discussion summarised archiving across Applications, how to submit the purge processes, criteria for records to be purged, what information does and does not get purged, the tables information is purged from and how to restore archived information.
Appendix - Archive and Purge Table Summary
Module Archive / Purge Program Documentation Schema Table 1159 - Archive 1159 Purge AP CUM Period Purge Payables User Guide CHV_AUTHORIZATIONS N Y CHV_CUM_ADJUSTMENTS N Y CHV_CUM_PERIODS N Y CHV_HORIZONTAL_SCHEDULES N Y CHV_ITEM_ORDERS N Y CHV_SCHEDULE_HEADERS N Y CHV_SCHEDULE_ITEMS N Y Invoice Purge Payables User Guide AP_ACCOUNTING_EVENTS N Y AP_AE_HEADERS N Y AP_AE_LINES N Y AP_BATCHES N Y AP_CHECKS N Y AP_CHRG_ALLOCATIONS N Y AP_DOC_SEQUENCE_AUDIT N Y AP_ENCUMBRANCE_LINES N Y AP_HOLDS N Y AP_INVOICE_APPROVAL_HISTORY_ALL N Y AP_INVOICE_DISTRIBUTIONS+ALL N Y AP_INVOICE_PAYMENTS N Y AP_INVOICE_SELECTION_CRITERIA N Y AP_INVOICES_ALL N Y AP_PAYMENT_HISTORY N Y AP_PAYMENT_SCHEDULES N Y RCV_RECEIVING_SUB_LEDGER N Y RCV_SUBLEDGER_DETAILS_NUMBER N Y Invoice Purge with MRC Payables User Guide AP_MC_CHECKS N Y AP_MC_INVOICE_DISTS N Y AP_MC_INVOICE_PAYMENTS N Y AP_MC_INVOICES N Y Purchase Order Purge Payables User Guide PO_ACCEPTANCES N Y PO_ACTION_HISTORY N Y PO_DISTRIBUTIONS N Y PO_HEADERS N Y PO_HEADERS_ARCHIVE N Y PO_LINE_LOCATIONS N Y PO_LINE_LOCATIONS_ARCHIVE N Y PO_LINES N Y PO_LINES_ARCHIVE N Y PO_NOTE_REFERENCES N Y PO_NOTES N Y PO_RELEASES N Y Purchase Order Purge with MRC Payables User Guide PO_MC_DISTRIBUTIONS N Y PO_MC_HEADERS N Y Requisition Purge Payables User Guide PO_ACTION_HISTORY N Y PO_NOTE_REFERENCES N Y PO_NOTES N Y PO_REQ_DISTRIBUTIONS N Y PO_REQUISITION_HEADERS N Y PO_REQUISITION_LINES N Y Supplier Purge Payables User Guide PO_APPROVED_SUPPLIER_LIST N Y PO_ASL_ATTRIBUTES N Y PO_ASL_DOCUMENTS N Y PO_VENDOR_CONTACTS N Y PO_VENDOR_LIST_ENTRIES N Y PO_VENDOR_LIST_HEADERS N Y PO_VENDOR_SITES_ALL N Y PO_VENDORS N Y Supplier Schedule Purge Payables User Guide CHV_AUTHORIZATIONS N Y CHV_HORIZONTAL_SCHEDULES N Y CHV_ITEM_ORDERS N Y CHV_SCHEDULE_HEADERS N Y CHV_SCHEDULE_ITEMS N Y AR Transaction Purge Receivables User Guide AR_ACTION_NOTIFICATIONS N Y AR_ADJUSTMENTS N Y AR_BATCHES Y Y AR_CALL_ACTIONS N Y AR_CASH_BASIS_DISTRIBUTIONS N Y AR_CASH_RECEIPT_HISTORY Y Y AR_CASH_RECEIPTS Y Y AR_CORRESPONDENCE_PAY_SCHED N Y AR_CORRESPONDENCES Y Y AR_CORRESPONDENCES N Y AR_CUSTOMER_CALL_TOPICS N Y AR_DISTRIBUTIONS Y Y AR_MISC_CASH_DSTRIBUTIONS Y Y AR_NOTES N Y AR_PAYMENT_SCHEDULES N Y AR_RATE_ADJUSTMENTS N Y AR_RECEIVABLE_APPLICATIONS Y Y RA_BATCHES Y Y RA_CUST_TRX_LINE_GL_DIST Y Y RA_CUST_TRX_LINE_SALESREPS N Y RA_CUSTOMER_TRX Y Y RA_CUSTOMER_TRX_LINES Y Y CE Purge Bank Statement Cash Management User Guide CE_STATEMENT_HEADERS N Y CE_STATEMENT_LINES N Y Purge Bank Statement Interface Cash Management User Guide CE_STATEMENT_HEADERS_INT_ALL N Y CE_STATEMENT_LINES_INTERFACE N Y N Y FA Data Archive and Purge Oracle Assets User Guide FA_ADJUSTMENTS Y Y FA_DEPRN_DETAIL Y Y FA_DEPRN_SUMMARY Y Y Delete Mass Additions Oracle Assets User Guide FA_MASS_ADDITIONS Y Y FND Purge Concurrent Requests Oracle System Administration User Guide FND_CONC_REQUEST_ARGUMENTS N Y FND_CONC_STAT_LIST N Y FND_CONCURRENT_PROCESSES N Y FND_CONCURRENT_REQUESTS N Y FND_DUAL N Y FND_RUN_REQUESTS N Y GL Purge Balances General Ledger User Guide GL_BALANCES Y Y Purge Consolidation Audit Data General Ledger User Guide GL_CONSOLIDATION_AUDIT N Y Purge Interim Move/Merge Tables General Ledger User Guide GL_MOVEMERGE_BAL_<move/merge request N Y GL_MOVEMERGE_DAILY_BAL_<move/merge N Y Purge Journals General Ledger User Guide GL_IMPORT_REFERENCES Y Y GL_JE_BATCHES Y Y GL_JE_HEADERS Y Y GL_JE_LINES Y Y INV Transaction Purge Inventory User Guide N Y MTL_MATERIAL_TRANSACTIONS N Y MTL_TRANSACTION_ACCOUNTS N Y ONT Purge Orders Order Management User Guide FND tables will be purged of any attachments for Y Y OE_HOLD_RELEASES Y Y OE_HOLD_SOURCES Y Y OE_LINE_SETS Y Y OE_LOT_SERIAL_NUMBERS Y Y OE_ORDER_HEADERS_ALL Y Y OE_ORDER_LINES_ALL Y Y OE_PRICE_ADJ_ADJUSTMENTS Y Y OE_PRICE_ADJ_ATTRIBS Y Y OE_SALES_CREDITS Y Y OE_SETS Y Y PA Actuals Archive and Purge Oracle Projects Archive and Purge Documentation Supplement <Custom Table> Y Y PA_BILLING_MESSAGES Y Y PA_CC_DIST_LINES_ALL Y Y PA_COST_DISTRIBUTION_LINES_ALL Y Y PA_CUST_EVENT_RDL_ALL Y Y PA_CUST_REV_DIST_LINES_ALL Y Y PA_DISTRIBUTION_WARNINGS Y Y PA_DRAFT_INVOICE_ITEMS Y Y PA_DRAFT_INVOICES_ALL Y Y PA_DRAFT_REVENUE_ITEMS Y Y PA_DRAFT_REVENUES_ALL Y Y PA_EI_DENORM Y Y PA_EVENTS Y Y PA_EXPEND_ITEM_ADJ_ACTIVITIES Y Y PA_EXPENDITURE_COMMENTS Y Y PA_EXPENDITURE_HISTORY Y Y PA_EXPENDITURE_ITEMS_ALL Y Y PA_EXPENDITURES_ALL Y Y PA_RERN_INVOICE_DETAILS Y Y PA_ROUTINGS Y Y Capital Purge Oracle Projects Archive and Purge Documentation Supplement <Custom Table> Y Y PA_PROJECT_ASSET_LINE_DETAILS Y Y Cross-Charge Archive and Purge Oracle Projects Archive and Purge Documentation Supplement <Custom Table> Y Y PA_DRAFT_INVOICE_DETAILS_ALL Y Y MRC purge Oracle Projects Archive and Purge Documentation Supplement <Custom Table> Y Y PA_MC_CC_DIST_LINES_ALL Y Y PA_MC_COST_DIST_LINES_ALL Y Y PA_MC_CUST_EVENT_RDL_ALL Y Y PA_MC_CUST_RDL_ALL Y Y PA_MC_DRAFT_INV_DETAILS_ALL Y Y PA_MC_DRAFT_INV_ITEMS Y Y PA_MC_DRAFT_REVS_ALL Y Y PA_MC_EVENTS Y Y PA_MC_EXP_ITEMS_ALL Y Y PA_MC_PRJ_AST_LINE_DTLS Y Y PA_MC_RETN_INV_DETAILS Y Y Purge Imported Transactions Projects User Guide PA_TRANSACTION_INTERFACE_ALL N Y Resource Unassigned Time Archive Oracle Projects Archive and Purge Documentation Supplement and Purge PA_FI_AMOUNT_DETAILS Y Y PA_FORECAST_ITEM_DETAILS Y Y PA_FORECAST_ITEMS Y Y Staffing Transaction Archive and Purge Oracle Projects Archive and Purge Documentation Supplement PA_ACTION_SET_LINE_AUD Y Y PA_ACTION_SET_LINES Y Y PA_ACTION_SETS Y Y PA_ACTION_SETS Y Y PA_ASSIGNMENT_CONFLICT_HIST Y Y PA_ASSIGNMENTS_HISTORY Y Y PA_CANDIDATE_REVIEWS Y Y PA_CANDIDATES Y Y PA_FI_AMOUNT_DETAILS Y Y PA_FORECAST_ITEM_DETAILS Y Y PA_FORECAST_ITEMS Y Y PA_PROJECT_ASSIGNMENTS Y Y PA_PROJECT_PARTIES Y Y PA_SCHEDULE_EXCEPT_HISTORY Y Y PA_SCHEDULES Y Y PA_SCHEDULES_HISTORY Y Y Summarization Archive and Purge Oracle Projects Archive and Purge Documentation Supplement <Custom Table> Y Y PA_PROJECT_ACCUM_ACTUALS Y Y PA_PROJECT_ACCUM_BUDGETS Y Y PA_PROJECT_ACCUM_COMMITMENTS Y Y PA_PROJECT_ACCUM_HEADERS Y Y PA_RESOURCE_ACCUM_DETAILS Y Y PA_TXN_ACCUM Y Y PA_TXN_ACCUM_DETAILS Y Y WF Purge Obsolete Workflow Runtime Data Workflow Administrators Guide WF_ACTIVITIES N Y WF_ACTIVITIES_TL N Y WF_ACTIVITY_ATTR_VALUES N Y WF_ACTIVITY_ATTRIBUTES N Y WF_ACTIVITY_ATTRIBUTES_TL N Y WF_ACTIVITY_TRANSACTIONS N Y WF_ITEM_ACTIVITY_STATUSES N Y WF_ITEM_ATTRIBUTE_VALUES N Y WF_ITEMS N Y WF_LOCAL_ROLES N Y WF_LOCAL_USER_ROLES N Y WF_NOTIFICATION_ATTRIBUTES N Y WF_NOTIFICATIONS N Y WF_NOTIFICATIONS N Y WF_PROCESS_ACTIVITIES N Y WF_USERS N Y
EBS Archiving and Purging: You Know you need to,布布扣,bubuko.com
EBS Archiving and Purging: You Know you need to
原文：http://www.cnblogs.com/xiaoL/p/3837240.html