IFB to delete all records from S_ORG_EXT table that were created on the previous day

Presently I came across one of my friend's requirement for an IFB to delete all records from S_ORG_EXT table that were created on the previous day and with value of SRV_PROVDR_FLG as Y, so that IFB can be scheduled to run on a particular interval and delete process can be automated.

Here, I am sharing it with you guys and you can make use of it on any table and for deleting records in any time period just by changing the parameters given, as per your requirement.

Export All Rows IFB File

Here, Let's look at the IFB file which can be used to export entire records from a Siebel base table. For that, you have to just include the parameter 'EXPORT ALL ROWS' in the IFB file and its value should be set to true. 
Here is the IFB file to be used :-

[Siebel Interface Manager]
PROCESS = CASE_EXPORT
[CASE_EXPORT]
TYPE = SHELL
INCLUDE = "EXPORT_CASE"

Export Matches IFB File

Here, Let's look at the IFB file which can be used to export certain amount of records that matches a condition.If u need only some specific records to be exported from a Siebel database, you can make use of this.

The thing you have to do is, you have to specify the SQL statement to select the specific records needed with in the 'EXPORT MATCHES' parameter in the IFB.
Here is the IFB file used :-

[Siebel Interface Manager]
PROCESS = CASE_EXPORT
[CASE_EXPORT]
TYPE = SHELL
INCLUDE = "EXPORT_CASE"