However note that it is not recommended to purge or delete any data stored in OBAPI tables without doing detailed impact analysis. Please also note that the purge jobs are useful typically for purging old data. They may not be useful for purging data of a specific customer.

Procedure name -

DIGX_USER_PII_DATA_PURGE.sql

Procedure input parameter –

User Id (unique identifier of user) which is to be purged.

Description -

DIGX_USER_PII_DATA_PURGE will permanently purge the user and all the PII data associated with the user from all the database tables of OBAPI.

It must be noted that once user is purged then associated PII data and user cannot be retrieved under any circumstances.

Associated table -

This table holds data of table names and field names of tables containing User Id. Procedure fetches data from table DIGX_UM_USERS_ASSOCIATIONS and deletes all the PII data related to the provided User Id

Steps to run -

Run the procedure with providing User Id as input parameter.