Oracle Retail Knowledge Base

Environment cleanup process

1 min read

Context

Checklist of the procedures that clean an AIF DATA and AIF APPS environment before it is reloaded with a new dataset.

Every step deletes data

All three procedures truncate or purge real warehouse and application tables, and cannot be undone. Confirm you are on the correct environment before running any of them.

  1. AIF Data warehouse Cleanup — clears the RADM01 warehouse, calendar, and integration (RDX) data.
  2. Rejected records cleanup — deletes rejected rows from the E$ error tables.
  3. Application schema cleanup — truncates AIF application tables via POM.

Graph View

Backlinks