This chapter contains the following topics:
This chapter provides an overview of the purge and updated data tables and discusses how to:
Run the General Purge programs.
Run the Financial Management purge programs.
Run the Distribution purge programs.
Run the Logistics purge programs
Run the Manufacturing purge programs.
You should summarize and purge any data that does not need to be converted to the new base currency. This purge helps conserve valuable disk space and system resources because the conversion programs do not convert purged (P) tables. Before you purge any data, review how the purge programs work. This helps to ensure that when you purge data, you get the results that you expect.
Each purge program removes data from a table that meets certain criteria, regardless of any interdependencies that might exist between that table and another table. Therefore, when you purge data in a table, the results might affect another table so that you no longer have data integrity between the two tables. For example, if you purge data in a table in JD Edwards EnterpriseOne Sales Order Management, the results might affect the data integrity between that table and a table in Accounts Receivable.
Because the purge programs are not based on any interdependencies between tables, you can run the purge programs in any order.
Allow plenty of time to purge outdated data tables. Depending on the number of transactions in a table, a purge program might run for hours or days, especially for tables that are as large as the F0911 table. Purge outdated data only for those systems that the company uses.
|
Note: The purge programs are described in a checklist. The checklist has one check-off (√) column to indicate that the task is complete. Purge outdated data tables and complete all remaining tasks in this guide in the test environment first, and then correct any data issues in both the test and production environments. Later, when you are satisfied with the results of the conversion in the test environment, complete all of the tasks again in the production environment and go live. |
Before you purge outdated data:
Run integrity reports for all JD Edwards EnterpriseOne systems that you use and correct any integrity issues.
Back up the data.
Select General Purges (G00231), Purge Balance Auditor Table.
Select Tax Revisions (G00216), Tax File Purge.
This checklist discusses purge programs for system 00 that you should run before you run the base currency conversion.
The checklists in this section discusses purge programs that you should run before you run the base currency conversion.
Select Financials Purges (G00232), and then select a purge program.
These purge programs apply to the JD Edwards EnterpriseOne Address Book system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Address Book (R01800P) | This program removes address book records that have no associated transactions from these tables:
|
|
| Purge Batch Address Book (R0101Z1P) | This program removes processed addresses from the Address Book - Batch Table (F0101Z1), regardless of the batch in which they reside. | |
| Purge Completed Tasks (R01131P) | This program applies only to clients who use the Workflow Management system. It removes message log records from the Message Log Ledger File (F0113). |
These purge programs apply to the JD Edwards EnterpriseOne Accounts Receivable system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Electronic Receipts Input (R03B0041A) | This program removes processed electronic receipts from the Electronic Receipts Input table (F03B13Z1).
Note: Purge only receipts with an auto-cash upload status of Y. Otherwise, the purge program removes receipts that are stored in the F03B13Z1 table for invoice and statement matching purposes. |
|
| Purge Batch Invoices (R03B11Z1P) | This program removes processed invoices from these tables, regardless of the batch in which they exist:
This purge program removes only batch invoices; it does not affect invoices in the F03B11 table. |
|
| Purge/Repost A/R Statistical History (R03B163) | This program removes records from the A/R Statistical History table (F03B16) and resets the ISTC field from 1 to 0 for the corresponding invoices in the F03B11 table.
Use the data selection to designate which records to remove, and verify that you do not remove records by company. |
|
| Purge Statement/Notification (R03B5010) | This program removes delinquency notice and statement records from these tables:
To purge only delinquency notices, use the data selection to specify notification type DL. To purge only statement information, specify notification type ST. |
|
| Purge Invoice Transactions (R03B800) | This program removes paid and posted invoices without an open amount from the F03B11 table. | |
| Purge Receipt Transactions (R03B801) | This program removes posted receipts from the F03B13 and F03B14 tables. |
These purge programs apply to the JD Edwards EnterpriseOne Accounts Payable system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Closed A/P Records (R04800) | This program removes paid transactions (open amount) = (zero) from these tables:
|
|
| Purge Batch Vouchers (R0411Z1P) | This program removes inbound processed vouchers from these tables regardless of the batch in which they exist:
This purge program does not affect vouchers in the F0411 table. |
|
| Purge F0413 Interoperability Table (R0413Z1) | This program removes outbound processed payments from these tables regardless of the batch in which they exist:
This purge does not affect payments in the F0413 and F0414 tables. |
|
| Purge A/P Payee Control (R0450P) | This program removes control records and associated audit trails from the Payee Control table (F0450). |
These purge programs apply to the JD Edwards EnterpriseOne General Accounting system:
| Purge Program | Description | Complete |
|---|---|---|
| Summarize Transactions (R09811) | This program creates a single balance forward record to replace numerous detailed transactions. | |
| Purge Prior Year JEs (R09911) | This program removes summarized journal entries for prior years from the F0911 table. | |
| Purge Prior Year Account Balance (R09912) | This program removes account balance records with dates prior to the current fiscal year from the F0902 table. | |
| Purge Batch Journal Entries (R0911Z1P) | This program removes batch journal entries from the Journal Entry Transactions - Batch File (F0911Z1). This purge program does not affect journal entries in the F0911 table. | |
| Purge Cost Analyzer (R1602P) | This program removes balance records from the Cost Analyzer Balances table (F1602) and clears the posted code in the F0911 table, which enables you to repost the records in the new base currency after the conversion. |
Select Fixed Assets (G00233), and then select a purge program.
These purge programs apply to the JD Edwards EnterpriseOne Fixed Assets system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Asset Master and Balances (R12912) | This program removes selected asset records or entire data tables, based on the processing options. You can purge prior year records in the F1202 table, assets that you disposed in a prior year, and so on. | |
| Purge Unedited Asset Master Transactions (R1201Z1P) | This program removes transactions in the Unedited Asset Master Transactions table (F1201Z1). This program has no processing options. Use the data selection to remove selected transactions. Otherwise, the purge program removes all transactions in the F1201Z1 table. |
The checklists in this section discuss purge programs that you should run before you run the base currency conversion.
Select Distribution Purges (G00234), and then select a purge program.
These purge programs apply to the JD Edwards EnterpriseOne Procurement system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Purchase Order Receiver (R43121P) | This program removes records with a next status of 999 (closed) from the F43121 table. | |
| Purge Purchase Order Detail (R4311P) | Prerequisite: Run the Purge Purchase Order Receiver program.
This program removes records with a next status of 999 (closed) from the F4311 table. |
|
| Purge Purchase Order Header (R4301P) | Prerequisite: Run the Purge Purchase Order Detail program.
This program removes records from the Purchase Order Header table (F4301) if no active detail lines exist. |
|
| Purge Purchase Order Detail Ledger (R43199P) | Prerequisite: Run the Purge Purchase Order Header program.
This program removes records with a next status of 999 (closed) from the F43199 table. |
|
| Purge Receipt Routing Records (R43092Z1P) | This program removes records from the Receipt Routing Unedited Transaction Table (F43092Z1). | |
| Purge for Receipts Interoperability (R43121Z1P) | This program removes records from the Receipts Unedited Transaction Table (F43121Z1). | |
| Purge Purchase Order Text Lines (R43960) | This program changes the status of text lines to 999 (closed) on purchase orders that have been closed. |
These purge programs apply to the JD Edwards EnterpriseOne Sales Order Management system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Sales Order Detail to History (R42996) | This program removes detail lines with a status of 999 from the F4211 table and writes a history record to the F42119 table. | |
| Purge Sales Order Detail (F4211)
(R4211P) |
This program removes records from the F4211 table. | |
| Purge Sales Order Header (R4201P) | Prerequisite: Run the Purge Sales Order Detail to History program.
This program removes records from the F4201 table only if no open detail lines with a matching order type and order number exist in the F4211 table. |
|
| Purge Sales Order Text (R42960) | This program changes status of text lines to 999 (closed) on sales orders with no open detail lines. | |
| Purge Batch Receiver (R4001ZP) | This program processes sales orders from the Batch Receiver File - Order Headings table (F4001Z). This program selects only records with Y in the Processed (Y/N) field. | |
| Purge Sales Order History (R42119P) | This program removes records from the F42119 table. | |
| Purge Sales Transactions Records (R42199P) | This program removes records from the F42199 table. | |
| Purge Audit Log (R42420) | This program removes records from the Audit Log Transaction table (F42420). |
These purge programs apply to the JD Edwards EnterpriseOne Electronic Commerce system from Oracle:
| Purge Program | Description | Complete |
|---|---|---|
| Purge EDI Purchase Order In (R47018) | This program removes inbound transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Purchase Order Header Tax - Inbound (F47011TX) and EDI Purchase Order Detail Tax - Inbound (F47012TX) tables. |
|
| Purge EDI Purchase Order Out (R47019) | This program removes outbound transactions from these tables:
|
|
| Purge EDI P.O. Acknowledgement In (R47028) | This program removes inbound transactions from these tables:
|
|
| Purge EDI P.O. Acknowledgement Out (R47029) | This program removes outbound transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and the EDI Order Detail - Outbound Tax (F47007) tables, that were created with the EDI Invoice Header (Sales) - Outbound (F47046) and EDI Invoice Detail (Sales) - Outbound (F47047) tables. |
|
| Purge EDI Shipping Notice Out (R47039) | This program removes outbound transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Shipping Notice Header Tax - Outbound (F47036X) and the EDI Shipping Notice Detail Tax - Outbound (F470371X) tables. |
|
| Purge EDI Voucher In (R47041P) | This program removes inbound voucher transactions from these tables:
|
|
| Purge EDI Invoice In (R47048) | This program removes inbound invoice transactions from these tables:
|
|
| Purge EDI Invoice Out (R47049) | This program removes outbound invoice transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and the EDI Order Detail - Outbound Tax (F47007) tables. |
|
| Purge EDI Payment Order Out (R47059) | This program removes outbound payment transactions from these tables:
|
|
| Purge EDI Planning Schedule In (R47068) | This program removes inbound transactions from these tables:
|
|
| Purge EDI Planning Schedule Out (R47069) | This program removes outbound transactions from these tables:
|
|
| Purge EDI Receiving Advice In (R47078) | This program removes inbound transactions from these tables in the Procurement and Sales Order Management systems:
|
|
| Purge EDI Receiving Advice Out (R47079) | This program removes outbound transactions from these tables:
|
|
| Purge EDI Request for Quote Inbound Quote (R47098) | This program removes inbound transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Request for Quote Header Tax – Inbound (F47091TX) and EDI Request for Quote Detail Tax – Inbound (F47092TX) tables. |
|
| Purge EDI Request for Quote Out (R47099) | This program removes outbound transactions from these tables:
|
|
| Purge EDI Response to RFQ Out (R47109) | This program removes outbound transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and EDI Order Detail - Outbound Tax (F47007) tables. |
|
| Purge EDI Product Activity Data In (R47128A) | This program removes inbound transactions from these tables:
|
|
| Purge EDI Product Activity Data Out (R47129A) | This program removes outbound transactions from these tables:
|
|
| Purge EDI Purchase Order Change In (R47138) | This program removes inbound transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Purchase Order Change Header Tax - Inbound (F47131TX) and EDI Purchase Order Change Detail Tax - Inbound (F47132TX) tables. |
|
| Purge EDI Purchase Order Change Out (R47139) | This program removes outbound transactions from these tables:
|
|
| Purge EDI P.O. Change Acknowledgement In (R47148) | This program removes inbound transactions from theses tables:
|
|
| Purge EDI P.O. Change Acknowledgement Out (R47149) | This program removes outbound transactions from these tables:
If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and EDI Order Detail - Outbound Tax (F47007) tables. |
|
| Purge EDI Shipping Scheduler Out (R47156) | This program removes outbound transactions from these tables:
|
The checklist in this section discusses a purge program that you should run before you run the base currency conversion.
Select Logistics Purges (G00235), Purge Inbound Suggestion Records.
This purge program applies to the JD Edwards EnterpriseOne Warehouse Management system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Inbound Suggestion Records (R4611Z1P) | This program removes inbound suggestion records from the Unedited Suggestion Table (F4611Z1) in JD Edwards EnterpriseOne Warehouse Management. |
The checklist in this section discusses purge programs that you should run before you run the base currency conversion.
Select Manufacturing Purges (G00236), and then select a purge program.
These purge programs apply to the JD Edwards EnterpriseOne Work Orders system:
| Purge Program | Description | Complete |
|---|---|---|
| Purge Work Orders (R4801P) | This program removes work orders from the Work Order Master File table (F4801) and related information from these tables:
|
|
| Purge Closed Work Orders (R48900) | This program removes work orders and any associated record types and approval records from these tables:
|
|
| Purge Outbound Work Orders (R4801Z1P) | This program removes work orders from the Outbound Work Order Header table (F4801Z1). |