My Oracle Support Banner

OBIA 11g: FA On-Prem - SDE_FUSION_11_ADAPTOR_SDE_FUSION_ITEMREQUESTSTATUSHISTORYFACT fails with Fusion On-Premise Source (Doc ID 2376922.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

In direct ETL with fusion on premise as source following mappings failing because of extra bracket in the filter condition.
SDE_FUSION_ItemTradingPartnerDimension
SDE_FUSION_ItemRequestLine_Translate
SDE_FUSION_ItemRequestStatusHistoryFact
SDE_FUSION_ItemInterfaceFact

 ODI-1217: Session
SDE_FUSION_11_ADAPTOR_SDE_FUSION_ITEMREQUESTSTATUSHISTORYFACT (21844500)
fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target
ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: 8000 : null :
java.sql.SQLException: java.io.IOException: prepare query failed[nQSError:
43113] Message returned from OBIS.
[nQSError: 27002] Near <And>: Syntax error [nQSError: 26012] .
java.sql.SQLException: java.io.IOException: prepare query failed[nQSError:
43113] Message returned from OBIS.
[nQSError: 27002] Near <And>: Syntax error [nQSError: 26012] .
at
oracle.bi.jdbc.AnaJdbcPreparedStatementImpl.openAndPrepare(AnaJdbcPreparedStatementImpl.java:77)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.