Reporting - EBS (MOSC)

MOSC Banner

Error ORA-00904 executing interface ODI

edited Oct 13, 2011 2:07AM in Reporting - EBS (MOSC) 5 commentsAnswered
Hi,

i have one interface in Oracle Data Integrator to migrate one table from sqlserver to oracle

my LKM is "SQL to Oracle"
my IKM is "Oracle Incremental Updates"

when i execute my interface, generate the error : "ORA-00904: "S"."ID": invalid identifier"  in step "Insert flow into I$ table"  

the code is :

* DETECTION_STRATEGY = NOT_EXISTS */

insert /*+ append */ into    MIGRASQL.I$_CO_CONCEPTO
(
    DESCRIPCION,
    IDPAIS,
    IDCOMPANIA,
    IDNATURALEZA,
    IDCLASE
)
select
    DESCRIPCION,
    IDPAIS,
    IDCOMPANIA,
    IDNATURALEZA,
    IDCLASE
from (

select   C2_DESCRIPCION DESCRIPCION,
         C3_IDPAIS IDPAIS,
         C4_IDCOMPANIA IDCOMPANIA,
         C5_IDNATURALEZA IDNATURALEZA,
         C6_IDCLASE IDCLASE
from     MIGRASQL.C$_0CO_CONCEPTO
where    (1=1)

) S
where NOT EXISTS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center