Deleted records are not inserted properly on target site while doing Audit using Doc ID 1314698.1
I am testing auditing using Doc ID 1314698.1.
Deleted records are not inserted properlyon target site while doing Audit using Doc ID 1314698.1.
That is, only before images of primary key column values are inserted to Audit table.
Other column values are inserted as NULL.
Other DML operations such as INSERT,UPDATE are audited properly.
Below query output shows Deleted records has missing column values on Audit table on Target(REplicat) Side.
select * from change_test1;
COLNMBR COLCH COLTS DB_OP_TYPE SRC_COMMIT_TS BFR_AFT_IND
---------- --------------- --------------- --------------- --------------------------------------------------------------------------- ------------------------------------------------------------------------------------------
1 asdf 24-JUL-13 09.49 INSERT 24-JUL-13 09.47.50.899495 PM AFTER
.39.000000 PM
1 asdf 24-JUL-13 09.49 SQL COMPUPDATE 24-JUL-13 10.01.13.937051 PM BEFORE