1. Enable LogMiner

shutdown immediate;
startup mount;
alter database archivelog;
alter database open;

2. Enable Supplemental Logging

For 12c multitenant databases

ALTER SESSION SET CONTAINER=<pdb>;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER TABLE XW_IFP.UM_LOCAL_USER ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

3. Create a User Account

Oracle 12c multitenant databases

ALTER SESSION SET CONTAINER=cdb$root;
CREATE USER data_ext IDENTIFIED BY Ext_2017 CONTAINER=all;
GRANT create session, alter session, set container, select any dictionary, logmining, execute_catalog_role TO data_ext CONTAINER=all;
ALTER SESSION SET CONTAINER=<pdb>;
GRANT select on XW_IFP.UM_LOCAL_USER TO data_ext;

Oracle 12c standard databases

CREATE USER data_ext IDENTIFIED BY Ext_2017;
GRANT create session, alter session, select any dictionary, logmining, execute_catalog_role TO data_ext;
GRANT select on XW_IFP.UM_LOCAL_USER TO data_ext;