Interface tables

From: Rupiinder Singh <rupinder_at_hotmail.com>
Date: 25 Apr 2002 16:18:13 -0700
Message-ID: <172973b6.0204251518.3276d530@posting.google.com>

Can anybody point me to a resource where I can find more information about Oracle open interface tables, specially MTL_SYSTEM_ITEMS_INTERFACE. Specifically what I want to know is how does Oracle process the records from this table. Does it go record by record and process them ? Is there a way to enforce and order for processing these records.

I need help from anybody who has implemented a sequencing system for updates. We are running into a problem where we get updates to an item and sometimes they get to us in the wrong order. But the record that gets to us always has a sequence number. How do I enforce that the records are always processed based on this sequence number rather than their position in the interface tables.

Any help is appreciated. Received on Thu Apr 25 2002 - 18:18:13 CDT