My Oracle Support Banner

How To Get the Exact Error Message in PVO Extract Failure of "LKM BICC to ADW External Table" Step (Doc ID 2867556.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.220112 and later
Oracle Data Integrator - Version 12.2.1.4.220112 and later
Information in this document applies to any platform.

Goal

PVO data is extracted from BICC PVO source to  ADW Table target using LKM BICC to ADW External Table.
Whenever the ODI job fails loading data from PVO to external table due to data issue getting only a reject limit reached error message like below without finding the exact column name which caused data issue:

How to get a meaninful error message in this failure scenario?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.