Soft Delete of records from FTI

Hello,

Currently i'm facing some difficulties when i delete a record from the Oracle Transportation Data Base the record still remain in the Oracle Fusion Intelligence Data Base.

Steps that i have done :

             Activation of "Unload Shipment from HD" Agent

             Modify the VPD profil for the users to FTI_Default

             Delete a shipment (manually) from OTM,

             Run the ETL process,    

Second question is when i modify for example a shipment's date, i find two records(for the same shipment ID) with two different dates within the FTI Daba Base. Is there a way to overwrite the old record.

Oracle Business Intelligence Product Version