Best Practices for interfaces for inbound and out bounds
1. Create a staging table from mandatory,conditional requied,optional requied columns from inteface select statement as xx_table_name
2. alter the table add columns as process flags, error flags
3. Load the data through sql loader as per client requiments
4. write a plsql procedures to validate data and transfer to interfce tables
5. submit standard programe to import data
SELECT * FROM USER_ERRORS (FOR PROCEDURES AND FUNCTIONS)
