Running Integration Interface with no errors but the Data Is Not Downloaded (Doc ID 1638530.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Goal

Customer has created an integration Profile to Import Data/ They staging tables (BIIO_xxx) tables have the data loaded fine

When they run the Transfer step, the data does not get loaded into the Demantra tables . The integration logs shows that rows are processed but the data is not there in the demantra tables (sales_data)
 

 

2014-03-20 10:49:34,568 [WFProcess_5] INFO  integration.process: #######################################################
2014-03-20 10:49:34,568 [WFProcess_5] INFO  integration.process: Import Data.
2014-03-20 10:49:34,569 [WFProcess_5] INFO  integration.process: ODPM-20044: Run Start Time: 03-20-2014 10:49:34
2014-03-20 10:49:34,569 [WFProcess_5] INFO  integration.process: ODPM-20045: Interface Name: EVG Imp EDI Forecast
2014-03-20 10:49:34,569 [WFProcess_5] INFO  integration.process: ODPM-20046: Profile Name: EVG Imp EDI Forecast
2014-03-20 10:49:34,569 [WFProcess_5] INFO  integration.process: ODPM-20052: Owner: sop
2014-03-20 10:49:34,571 [WFProcess_5] INFO  integration.process: ODPM-20053: Profile From Date: 11-01-2009
2014-03-20 10:49:34,571 [WFProcess_5] INFO  integration.process: ODPM-20054: Profile Until Date: 11-01-2022
2014-03-20 10:49:34,608 [WFProcess_5] INFO  integration.process: ODPM-20326: Import Strategy: ImportDataJavaUpdate.
2014-03-20 10:49:58,565 [WFProcess_5] INFO  integration.process: ODPM-20064: Valid Rows processed: 200.
2014-03-20 10:50:04,196 [WFProcess_5] INFO  integration.process: ODPM-20048: Run End Time: 03-20-2014 10:50:04
2014-03-20 10:50:04,196 [WFProcess_5] INFO  integration.process: ODPM-20049: Run Duration Time (hh:mm:ss:msec):0:0:29.628

Solution

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