OIC ERP - Manual Purge of Interface Tables for Import Costs in Oracle ERP Cloud

🔎 Overview

When running Import Costs in Oracle ERP Cloud (Cost Management), interface tables store staging data. If not cleaned regularly, they grow large and affect performance.

This guide explains how to manually purge interface tables directly from ERP (no automation, no OIC).

📌 When to Manually Purge?

• After successful Import Costs completion
• When interface table size becomes large
• When facing slow import performance
• During period-end cleanup

✅ Steps to Manually Purge from ERP

Step 1️⃣: Navigate to Scheduled Processes

Go to Tools → Scheduled Processes

Step 2️⃣: Click “Schedule New Process”

Click Schedule New Process

Search for: Purge Interface Tables

Select and click OK

Step 3️⃣: Enter Required Parameters

• Import process name
• Start Load Request Id
• End Load Request Id

Step 4️⃣: Submit the Process

• Click Submit
• Monitor the job status
• Wait for status = Succeeded

Step 5️⃣: Validate

Run Import Costs again (if required)

Confirm performance improvement

Ensure no business impact

⚠️ Precautions

❌ Do NOT purge unprocessed or error records

❌ Do NOT purge current-day active imports

✔ Always coordinate with Functional Team

✔ Prefer non-business hours for purge

🎯 Result

Manual purge helps:

Reduce interface table size

Improve Import Costs performance

Maintain ERP stability

Avoid long-running ESS jobs