Thank you for your response.
Yes. I did all the settings as in the document. It was working fine for Oracle to Oracle RDS data replication.
Now trying to do the same for Oracle to Postgres RDS.
I am sure it is some privilege missing on the target instance. Not sure, what it is.
Can you confirm you have followed these steps to set-up the source Oracle database - https://docs.aws.amazon.com/dms/latest/sbs/chap-on-premoracle2aurora.steps.configureoracle.html
Oracle materialized view replication to postgres using DMS CDCasked a month ago
Read Oracle CDC without timestamp informationasked a month ago
Using DMS CDC for Oracle to Postgresasked 2 months ago
Support for RDS Oracle as source while using DMS SCN for CDCAccepted Answerasked 4 years ago
DMS CDC for SQL Server - ReplicationAccepted AnswerEXPERTasked 2 years ago
Refactoring from Oracle to postgres, Do I need to drop foreign key constraitns at postgresasked 2 months ago
DMS CDC VerificationAccepted Answerasked 4 years ago
DMS - Oracle Binary Reader LatencyAccepted Answerasked 4 years ago
How AWS DMS CDC is working successfully without CDC On-premise MSSQL CDC prerequisites config?Accepted Answerasked 2 months ago
DMS CDC - MySQL Binlog Precision - Seconds to Microsecondsasked 22 days ago