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 to [Release 11g]
Information in this document applies to any platform.


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

(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 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.odi.query.JDBCTemplate.executeQuery(


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.