Administration Guide for Oracle Self-Service E-Billing > Administering the Database >

Purging Validation Codes

You can purge the validation codes automatically generated by Oracle Self-Service E-Billing when a new users enroll.

You can specify the number of days before which the code must have been generated. Purging validation codes removes that information from the EDX_UMF_SEC_VALIDATIONCODE table.

To purge validation codes

• Run the following command from the EDX_HOME/bin directory (the EDX_HOME\bin directory on Windows):

  UNIX:

  ./purge_data.sh -connstr OLTP schema username/OLTP schema password@OLTP TNS name -validationcode -keepdays Number of days

  Windows:

  purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name -validationcode -keepdays Number of days