OPEN INTERFACE LOGIC and INTERFACE Components
OPEN INTERFACE LOGIC
- The data from source application is loaded into a database table (called Interface Table).
- The provided program logic validates the records.
- Any errors are transferred into another table (called Error Table).
- The correct records are then transferred through a process into destination application table.
INTERFACE COMPONENTS
Picture not available
Source Application
· You obtain data from a source application to pass on to a destination application for further processing and/or storage.
Source Data Issues
· Type of file, Size, Frequency of upload, Record length (variable or fixed), Delimiter, Data type of each field, Any unwanted data, Naming convention, Unique ness of file, Location of file and access on the file.
Destination Application
· You send data to destination application so that the application can perform further processing and/or storage.
Interface Table
· For inbound interfaces, the interface table is the intermediary table where the data temporarily resides until it is validated and processed into the destination application.
Identifier Columns
· Uniquely identify rows in the interface table and provide foreign key reference to both the source and destination applications.
Control Columns
· Control columns track the status of each row in the interface table, as it is inserted, validated, rejected, processed, and ultimately deleted.
· WHO Columns are also called control columns.
Data Columns
· Stores the data that is being converted.
Required Columns
· Required Columns store the minimum information needed by the destination application to successfully process the interface row.
Derived Columns
· Derived columns are created by the destination application from information in the required columns.
Filed under: ERP, Interfaces, Interview Questions(& answers), Oracle Apps, PL/SQL, SQL
Free Dashboards
Here are some more interesting Articles2 Responses to “OPEN INTERFACE LOGIC and INTERFACE Components”
Leave a Reply
You must be logged in to post a comment.
[…] http://www.infopurple.com/open-interface-logic-and-interface-components The provided program logic validates the records. Any errors are transferred into another table (called Error Table). The correct records are then transferred through a process into destination application table. […]
[…] http://www.infopurple.com/open-interface-logic-and-interface-components The provided program logic validates the records. Any errors are transferred into another table (called Error Table). The correct records are then transferred through a process into destination application table. […]