Overview of Clearing the Contents of a Table topic

This section provides an overview of clearing the Contents in a Table, and describes how to perform the task of clearing the contents.

If you export and import data in the same environment, you might need to clear the contents of a JD Edwards EnterpriseOne table before you import the data. When you import data from a spreadsheet to a configuration program, the program adds the data to a table; it does not override the existing data in a table. Therefore, if you revise existing records in a spreadsheet and try to import the data, the system will issue duplicate key errors because the records already exist. You must clear the contents of the table before you import the data. If you only add records to the spreadsheet, you do not have to clear the table before you import the data.

To clear the contents of a table

1. Enter P01RS01 in the Fast Path.

2. On the Configuration Utilities form, select the Business Data tab and then select the type of business data that you want to clear from a table.

3. On the <name of configuration> form, click Find to display the records in the table.

4. Depending on the environment, do one of the following:

   • For Microsoft® Windows®, select all of the rows in the grid and click Delete.

   • For the Web, select the check box that is located on the left of the column headings (this selects all records) and click Delete.

5. In the message window, click OK to confirm that you want to delete the selected items.