Error ODI-1228 When Performing Initial Sync Using B1_SYNC_CONTEXT (DPUMP_IMPORT) Method
Last updated on AUGUST 18, 2017
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 184.108.40.206.6 to 220.127.116.11.6 [Release 2.6]
Information in this document applies to any platform.
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
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