Error ODI-1228 When Performing Initial Sync Using B1_SYNC_CONTEXT (DPUMP_IMPORT) Method (Doc ID 2298621.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.6 to 2.6.0.0.6 [Release 2.6]
Information in this document applies to any platform.

Goal

While performing initial sync using B1_SYNC_CONTEXT ( DPUMP_IMPORT) method we are getting below error for one of the model code CCB2AD.

ODI-1228: Task Procedure-B1_SYNC_TABLE-Load data into replica (HIST,OVD,KEY,SCD2) fails on the target connection B1.
Caused By: java.sql.SQLException: ORA-06550: line 14, column 90:
PL/SQL: ORA-00904: "EFF_END_DTTM": invalid identifier
ORA-06550: line 8, column 1:
PL/SQL: SQL Statement ignored

 

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