Running the Complete Nuke Cleanup Utility

To run the Complete Nuke Cleanup Utility:

Note:

Before running the complete nuke cleanup, start the diagnostic logging.

Login to Oracle Identity Governance Database schema by using SQLPLUS shell, SQL Developer, or any other interface tool.
To run the complete nuke cleanup for reconciliation entities, execute the below code block:
```
declare
    v_err_code number;
    v_err_msg  varchar2(4000);
begin
    OIM_PKG_DATA_TRUNCATE.ReconDataTruncate(v_err_code,v_err_msg);
    dbms_output.put_line(v_err_code);
    dbms_output.put_line(v_err_msg);
end;
```
To run the cleanup for other entities, replace OIM_PKG_DATA_TRUNCATE.ReconDataTruncate with:
- OIM_PKG_DATA_TRUNCATE.OrchestrationDataTruncate for orchestration
- OIM_PKG_DATA_TRUNCATE.ProvDataTruncate for provisioning
- OIM_PKG_DATA_TRUNCATE.ReconDataTruncate for reconciliation
- OIM_PKG_DATA_TRUNCATE.CertDataTruncate for certification
- OIM_PKG_DATA_TRUNCATE.AudDataTruncate for legacy audit

Check whether the objects related to the purged entity are valid after successful completion of the complete nuke cleanup operation. If the objects are invalid, then check the log and contact Oracle Support with the logs.