Follow the steps below to load the fields which are missing in Customer Interface
- create a temporary table that replicates the standard customer interface table but which includes the missing fields.
- insert these records into the standard interface table (without the missing fields)
- run the customer interface
- run a script that updates the production tables with the missing fields

Using custom table you already know what information belongs with which records and make sure before loading the records that you are not attempting to load invalid values - since you aren’t running thru the interface program.

Return to : Oracle Database, SQL, Application, Programming Tips