Scribd
Upload
26 views1 page

ODI-1217 Error: Date-Number Mismatch

The ODI session SILOS_SIL_ORDERITEMFACT failed with return code 932. The flow SIL_OrderItemFact.W_ORDERITEM_F failed during an integration operation to load data into the target table W_ORDERITEM_F. The failure was caused by an inconsistent data type error between a DATE column and a NUMBER value in the target ORACLE database BIAPPS_DW.

Uploaded by

Nalin Swaroop
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
26 views1 page

ODI-1217 Error: Date-Number Mismatch

The ODI session SILOS_SIL_ORDERITEMFACT failed with return code 932. The flow SIL_OrderItemFact.W_ORDERITEM_F failed during an integration operation to load data into the target table W_ORDERITEM_F. The failure was caused by an inconsistent data type error between a DATE column and a NUMBER value in the target ORACLE database BIAPPS_DW.

Uploaded by

Nalin Swaroop
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

ODI-1217: Session SILOS_SIL_ORDERITEMFACT (1659500) fails with return code 932.

ODI-1226: Step Run SIL_OrderItemFact.W_ORDERITEM_F fails after 1 attempt(s).


ODI-1240: Flow Run SIL_OrderItemFact.W_ORDERITEM_F fails while performing a Inte
gration operation. This flow loads target table W_ORDERITEM_F.
ODI-1228: Task SIL_OrderItemFact.W_ORDERITEM_F (Integration) fails on the target
ORACLE connection BIAPPS_DW.
Caused By: [Link]: ORA-00932: inconsistent datatypes:
expected DATE got NUMBER
at [Link]([Link])
at [Link]([Link])
at [Link]([Link])
at [Link]([Link])
at [Link]([Link])
at [Link]([Link])
at [Link].T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:217)
at [Link](T4CPreparedSta
[Link])
at [Link](OracleStateme
[Link])
at [Link](OraclePrep
[Link])
at [Link](OraclePreparedStat
[Link])
at [Link](OraclePrepa
[Link])
at [Link](SQLCommand.
java:163)
at [Link](SQLExecuto
[Link])
at [Link](SQLExecuto
[Link])
at [Link](Ta
[Link])
at [Link]([Link]
:2913)
at [Link]([Link]
625)
at [Link]([Link]
a:577)
at [Link]([Link]
)
at [Link]([Link])
at [Link]$2.d
oAction([Link])
at [Link](DwgOb
[Link])
at [Link]
rocessStartSessTask([Link])
at [Link]
ess$0([Link])
at [Link]$Sta
[Link]([Link])
at [Link](AgentTask.j
ava:137)
at [Link]$[Link](Defau
[Link])
at [Link]([Link])

You might also like