My Oracle Support Banner

ODI LKM SAPBW To Oracle (SQLLDR) v37 version Generates an Output Data File That Contains All 0s (Doc ID 2004111.1)

Last updated on MARCH 09, 2018

Applies to:

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

Symptoms

ODI SAP 12.1.3.0.0 V37 KMs
Open tool version: 10.1.3.20

The code below from ODI 12c LKM SAPBW to Oracle (SQLLDR) Extract data step:

REFRESH : it_final , it_ZKCO_A_T .
FETCH NEXT CURSOR lv_dbcur
APPENDING CORRESPONDING FIELDS OF
TABLE it_ZKCO_A_T
PACKAGE SIZE iv_fetch_batch_size.

causes data to be 0's in the data file extracted from source table that will be loaded into Oracle target using Sqlldr. The number of rows are correct but data all 0s.

For example, the file has such content:

0 0 0 0000000000000000
0 0 0 0000000000000000
0 0 0 0000000000000000
0 0 0 0000000000000000
0 0 0 0000000000000000

  

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 ODI 12c
 ODI 11.1.1.7.0 and 11.1.1.9.0
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.