My Oracle Support Banner

How To Clean Or Avoid Error Data In Interface Tables Using EGO_ITEM_PUB.Process_Item (Doc ID 1548555.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Advanced Product Catalog - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

How can you avoid keeping old failed data after calling the open Public APIs : EGO_ITEM_PUB.Process_Item or EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG?

ACTUAL BEHAVIOR
The API leaves the failed data in MTL_SYSTEM_ITEMS_INTERFACE.

EXPECTED BEHAVIOR
The API should not leave any data in MTL_SYSTEM_ITEMS_INTERFACE.

WHAT IS WORKING
Processed items are automatically removed from MTL_SYSTEM_ITEMS_INTERFACE.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.