Replicat Abends With OCI Error ORA-01438: value larger than specified precision allowed for this column (status = 1438) (Doc ID 2065312.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle GoldenGate - Version 9.5_EA and later
Information in this document applies to any platform.

Symptoms

Replicat abends with error OCI Error ORA-01438: value larger than specified precision allowed for this column (status = 1438)

2015-10-12 01:26:04  WARNING OGG-01154  SQL error 1438 mapping OTM.INTERVENTION_EVENT_DATA to OTM_OWNER.INTERVENTION_EVENT_DATA OCI Error ORA-01438: value larger than specified precision allowed for this column (status = 1438), SQL <INSERT INTO "OTM_OWNER"."INTERVENTION_EVENT_DATA" ("AM_PRICE","AM_QUANTITY","ID_UNIVERSAL_ASSET")

 2015-10-12 01:26:04  WARNING OGG-01003  Repositioning to rba 1182775 in seqno 49.

 

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