Thank you for your question and reaching out. I can understand you are having query\issues related to Change Data Capture for Oracle Attunity stuck.
I would like to invite you to visit below links for Oracle
Change Data Capture Service for Oracle by Attunity : https://learn.microsoft.com/en-us/sql/integration-services/change-data-capture/change-data-capture-service-for-oracle-by-attunity?view=sql-server-ver15
Known errors and resolutions with change data capture for Oracle by Attunity : https://learn.microsoft.com/en-us/sql/integration-services/change-data-capture/known-issues-resolutions-with-cdc-for-oracle-attunity?view=sql-server-ver15