Defining Batch Deletion Actions

Access the JD Edwards EnterpriseOne Table Conversion Director.

1. Select Batch Delete, and click Next.

2. On the External Data form, select a processing option template, define a data structure, as appropriate, and click Next.

3. On the Select Environments form, select a source environment, and click Next.

4. On the Select Input form, drag the appropriate table to the Description column, and click Next.

   To delete an input table, select it and press Delete.

   Note: If you change the table, the system warns you that deleting tables removes all mappings from the table conversion.

5. On the Table Options form, select Run Currency Triggers, if appropriate, and click Next.

   Select this option if a JD Edwards EnterpriseOne table included in the table conversion contains currency triggers. If a table contains currency fields and you do not select this option, the system cannot determine where the decimal should be placed within a field. If you do not select the currency trigger option and the source or destination fields are currency fields used in a calculation, you might receive unexpected results.

   Do not select Run Currency Triggers if the input and output data sources are the same type (for example, Oracle, IBM i, or SQL Server) and no calculations are being performed. Selecting this option results in slower processing.

   You should not use currency triggers for an environment that has a path code that is different from the sign-in environment.

6. On the Data Selection form, define data selection as appropriate.

7. Select the Row Fetched event when deleting rows; otherwise, no records are deleted.

   When you run the table conversion, the system fetches the rows one at a time, runs the conversion for each row, and deletes the record from the input.

8. Click Advanced ER to insert additional event rule logic.

9. Verify that the Delete All Selected Records option is selected, and click Next.

   This option inserts the Delete Current Input Row system function into event rules.

10. On the Logging Options form, select logging options, as appropriate, and click Next.

11. On the Finish form, select a version option, and click Finish.