Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What Is An Open Interface Table (OIT)?

April 26, 2017Business Data interface OIT Oracle quality system Table tables

0

Posted

What Is An Open Interface Table (OIT)?

1 Answer

0

Posted

For inbound interfaces, the interface table is the intermediary table where data from the source application temporarily resides until it is validated and processed into an Oracle base table through a standard import concurrent program. Open Interface Tables are standard Oracle tables. Oracle uses OITs to provide a simple interface to Oracle base tables. Oracle Interface Program: Most Oracle modules have standard import programs (concurrent processes) to facilitate custom inbound interfaces. The specific processing performed varies by application. These programs pull data from the open interface tables, validate the data, and then insert into one or more Oracle base tables. Upon successful completion of processing, the program deletes the processed rows from the interface table or marks them as completed. Depending on the import, errors can be viewed in various ways (exception reports, error tables, forms etc). Examples of standard import programs: GL: Journal Import AP: Payables Open