My Oracle Support Banner

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

Last updated on SEPTEMBER 16, 2022

Applies to:

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


**Disclaimer:** This KM article may include the following abbreviations:

OUA - Oracle Utilities Analytics
ODI - Oracle Data Integrator


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




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.