This content has been marked as final. Show 3 replies
If you can modify the KM thats fine else create one package.
Put one procedure prior to the interface. In the procedure use one update statement to update the target table and set the current_flg to 'N".
Net run the interface using sql control append. ( Inside interface you must have set the current_flg to 'Y')
So what ever record will be inserted, flag value will be set to Y.