How to Solve The Error "ORA-01438: value larger than specified precision allowed for this column" When The Job Is Failing At "INT-LOAD_BRIDGE_CONTENT_WF_CATEGORY - Insert new rows" Step?

(Doc ID 2341000.1)

Last updated on DECEMBER 19, 2017

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Symptoms

Getting the below error into ODI for Oracle Knowledge application.

 

The package is failing at the below path: PKG_LOAD_DIM_STG_TABLES > Step 66 INT_LOAD_BRIDGE_CONTENT_WF_CATEGORY > Step 1249 INT-LOAD_BRIDGE_CONTENT_WF_CATEGORY - Insert New Rows


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