Replication Fails With "Error ORA-01843: Not a Valid Month"
Last updated on JANUARY 12, 2017
Applies to:Oracle GoldenGate - Version 10.4.0.50 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Mar-2013***
Replicat fails with error ORA-01843: not a valid month.
Operation failed at seqno 114 rba 68317228
Discarding record on action DISCARD on error 1843
Problem replicating MAC.AMX_SETTLE_FILE_NOTIFICATION to MAC.AMX_SETTLE_FILE_NOTIFICATION
Mapping problem with insert record (target format)...
PROC_BATCH = 564096
BRIC = NULL
NUMBER_OF_RECORDS = 43
NUMBER_OF_CREDITS = 0
NUMBER_OF_DEBITS = 18
NUMBER_OF_REJECTS = 0
FILE_REF_NUMBER = 1138AE73
FILE_CREATION_DATE = 0000-00-00 00:00:00
FILE_RECEIPT_DATE = 0000-00-00 00:00:00
HASH_TOTAL_AMOUNT = 88001
HASH_DEBIT_AMOUNT = 88001
HASH_CREDIT_AMOUNT = 0
ID = 47278
FILE_STATUS = Accepted with Errors
For the two Date fields "FILE_CREATION_DATE" and "FILE_RECEIPT_DATE", the value is invalid as "0000-00-00 00:00:00"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms