Commit_timestamp$ displays 1/1/1988 in CDC Publisher Table (Doc ID 729373.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
Checked for currency 22nd May 2013

Symptoms

For few tables of publisher, Column COMMIT_TIMESTAMP$ displays 1/1/1988

Due to other issues with CDC, when executing errors like  ORA-1858 or
ORA-1461 apply errors  using DBMS_APPLY_ADM.EXECUTE_ERROR or EXECUTE_ALL_ERRORS, the COMMIT_TIMESTAMP$
column is set to '1/1/1988 0:0:0' in the change table.

Also seen in 10046 event trace:

[
PARSING IN CURSOR #151 len=626 dep=1 uid=0 oct=2 lid=0 tim=7672339926386 
hv=2734027284 ad='6e6bdf38'
INSERT INTO "CDCPPUB"."CI_ACCT_CT" (OPERATION$, CSCN$, COMMIT_TIMESTAMP$, 
XIDUSN$, XIDSLT$, XIDSEQ$ , rsid$, username$, timestamp$, target_colmap$, 
ACCT_ID, BILL_CYC_CD, SETUP_DT, CURRENCY_CD, ACCT_MGMT_GRP_CD, ALERT_INFO, 
BILL_AFTER_DT, PROTECT_CYC_SW, CIS_DIVISION, MAILING_PREM_ID, 
PROTECT_PREM_SW, COLL_CL_CD, CR_REVIEW_DT, POSTPONE_CR_RVW_DT, 
INT_CR_REVIEW_SW, CUST_CL_CD, BILL_PRT_INTERCEPT, NO_DEP_RVW_SW, BUD_PLAN_CD, 
VERSION, PROTECT_DIV_SW, ACCESS_GRP_CD ) VALUES (:1, :2, :3, :4, :5, :6 , :7, 
:8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, 
:24, :25, :26, :27, :28, :29, :30, :31, :32)
END OF STMT
...
WAIT #151: nam='enq: TM - contention' ela= 786 name|mode=1414332419 object 
#=136155 table/partition=0 obj#=-1 tim=7672341250159
BINDS #151:
kkscoacd
Bind#0
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
@ oacflg=11 fl2=0001 frm=01 csi=31 siz=32 off=0
kxsbbbfp=104f3973b bln=32 avl=02 flg=09
value="UO"
Bind#1
oacdty=02 mxl=22(07) mxlc=00 mal=00 scl=00 pre=00
@ oacflg=11 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=110521e38 bln=22 avl=07 flg=09
value=26650399826
Bind#2
oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
@ oacflg=11 fl2=0001 frm=00 csi=00 siz=8 off=0
kxsbbbfp=110521e90 bln=07 avl=07 flg=09
value="1/1/1988 0:0:0" <=====

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms