My Oracle Support Banner

OBIA 11g: FA On-Prem - Task SDE_FUSION_GLBALANCEFACT_FULL_fails in Fusion On-Premise Source (Doc ID 2376879.1)

Last updated on MARCH 21, 2018

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

Task SDE_FUSION_GLBALANCEFACT_FULL_fails with Fusion On-Premise Source with following error:

ODI-1217: Session SDE_FUSION_11_ADAPTOR_SDE_FUSION_GLBALANCEFACT_FULL
(16303500) 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: ODI-1227: Task SrcSet0 (Loading)
fails on the source ORACLE_BI connection ds_fa11_finscm.
Caused By: java.sql.SQLException: PreparedStatement execute failed
java.io.IOException: execute query failed[nQSError: 43113] Message returned
from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 17001] Oracle Error code: 904, message: ORA-00904:
"GLBALANCES"."LEDGER_ID": invalid identifier
at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation failed.
at
oracle.bi.jdbc.AnaJdbcPreparedStatementImpl.execute(AnaJdbcPreparedStatementIm
pl.java:542)
at
oracle.bi.jdbc.AnaJdbcPreparedStatementImpl.executeQuery(AnaJdbcPreparedStatem
entImpl.java:204)
at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)

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!


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