Steps to develop an Interface in Oracle Apps R12

1] Identification:
        Find out if there exists an Open Interface to carry out the functionality.
2] Creation of Pre-Interface table ( staging Table):
       A table in the format of the data file which can be pruned to load as clean a data into the Interface table.
3] Load data into Pre-Interface table:
       SQL*LOADER can be used to load the flat file into the pre-interface table.
4] Validate data in the Pre-Interface table:
        Basic validation of the data loaded into the Pre-Interface table can be carried out like:

• For checking NULL values in required columns
• Checking for Foreign Key and Quick Code values.
• Duplication Validation
• Business Rule validation

5] Mapping the values:
        Generated fields in Oracle Applications can be mapped in this step to either default values or sequences.
6] Load data into Interface table:
        Once the data is as clean as you can get it, the data can be inserted into the Interface table.
At such a time, certain columns, which are necessary in Applications but not found in legacy system, need to be populated accordingly like WHO columns.
7] Run the interface program
8] Check for Errors
9] Report on the Interface