Clarification on Purge Interface Tables Behavior
Summary:
We are currently performing an initial load of approximately 8 million records and are experiencing inconsistent execution time behavior when running parallel import jobs (same number of records).
Based on Oracle's recommendation is to do the Purge Interface table. We enabled the ZCA_IMPORT_PURGE_FROM_UI profile option and executed the Purge action from Import Management. However, the Import Activities remain visible after the purge, and we are unsure of the expected behavior.
We also tested ZCA_IMPORT_PURGING_DURATION by setting it to 1 day, which worked as expected. However, our objective is to perform an immediate purge without waiting for the retention period, as we want to keep Import Management clean during the initial load activities.