I did this a few years ago with an external file load.  Created a File Type based on SUPPLIER view/SUPPLIER_API input package, then created a file template from that.  The only required fields in the file were VENDOR_NO (supplier ID) and DATE_DEL (expiration date)

You can simply achieve this using a migration job.

1. Header & formatting tab. Add all the supplier IDs you need to update in the where clause.

2. Source Mapping tab. Leave only the VENDOR_NO row and the DATE_DEL row and set the source column of the DATE_DEL row as SYSDATE to use the current date as the expiration date.

3. Method List tab. Check only the Modify checkbox.

Perform the migration job as below.

1. Right click on the header and click Start Job...

2. Right click on the header and click Start Online.

This will update the supplier expiration date of the suppliers you entered in the where clause.

 @janithronaka But I have 4000 suppliers to archive. The where class in the migration job allows only 100's. How can I mass update 4000 suppliers?

I don’t use the DMT much so am not familiar with any data limits it might have - but if you use external files instead, you do not have that limit and can update all 4000 at one time.

Hi @cynthia.wilson,

In that case, you can simply use the ‘Insert or Update’ in Procedure Name and just use a csv file with the whole list of suppliers to be updated. You can then split the list into shorter number of records and run the migration job several times or else run from server and in background for the complete list.

Regards,

Pilar