Deletion of interface tables and records

When related inbound transaction records are successfully processed in an interface table, the corresponding record is deleted from the MXIN_INTER_TRANS queue table. The deletion indicates that the transaction was delivered successfully to the inbound JMS queue.

Records are deleted from the MXIN_INTER_TRANS queue table and not from the individual interface tables. The system administrator determines when and how to delete records from the interface tables.

For outbound transactions, the external system must manage the deletion and archiving of data in the queue table and interface tables. You cannot delete interface tables in the user interface or by deleting the corresponding object structure. An administrator must manage the archiving of data in the interface tables and can drop the table, if necessary.



Feedback