Have you ever gotten this error running a dbms_compare in Oracle Streams ? ERROR at line 1: ORA-01400: cannot insert NULL into (“LITERATUM_LIVE”.”ALERT_USER_SUBSCRIPTION”.”ADDEDDATE”) ORA-06512: at “SYS.DBMS_COMPARISON”, line 728 ORA-06512: at line 4 This error usually occurs when trying to run dbms_compare to fix data not aligned with a master table in Oracle Streams. Basically the “NOT NULL” c..