Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Queries on Purge Items interface table to purge data from egp_system_items_interface

in Product Master Data Management 1 comment

Summary:

Item batches are failing for business with Warning "The total number of records in the egp_system_items_interface interface tables is about to exceed the maximum limit. Purge the interface table data as soon as possible."

This happened because the records in the table exceeded 5 million. We found the oracle note "How to Purge Item Interface Tables ? (Doc ID 2486151.1)" which provided options to purge the data. In the document the solution to manually purge the batches from the UI is difficult as we have more than 5 million records. In the schedule process 'Purge Interface Tables', we have few questions/ concerns with this:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!