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

How to Purge the Interface tables involved in Import Item Data Using Import Maps?

Summary:

We've noticed that records are being created in the EGP_SYSTEM_ITEMS_INTERFACE table, but the following request ID columns are populated with NULL values:

REQUEST_ID
LAST_IMPORT_REQUEST_ID
LOAD_REQUEST_ID

In this scenario, how can we purge the interface records, given that the Purge Interface Tables ESS job requires a REQUEST_ID?

Is there a recommended workaround or an alternative approach to clean up these interface records when the REQUEST_ID, LAST_IMPORT_REQUEST_ID, and LOAD_REQUEST_ID are all NULL?

Version : 26B

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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