Error ODI-1228 When Performing Initial Sync Using B1_SYNC_CONTEXT (DPUMP_IMPORT) Method
(Doc ID 2298621.1)
Last updated on DECEMBER 06, 2018
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!