My Oracle Support Banner

OBIA 11g:FA13: BIAipps FA REL13.18.10 ETL data extract fix (Doc ID 2480225.1)

Last updated on FEBRUARY 07, 2019

Applies to:

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

Symptoms

Issue 1

FA13 18.10 BIApps ETL Load Fails with following Error:
ODI-1217: Session
SDE_FUSION_11_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_PRCPOZPUBLICVIEWAM_SUPPLIERPVO
(12990500) fails with return code 7000.
ODI-1226: Step Update Fusion Deletes fails after 1 attempt(s).
ODI-1232: Procedure Process Deletes execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 12, in <module>
java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException:
ORA-00904: "TT"."BUSCLASS6CLASSIFICATIONID": invalid identifier  

Issue 2: Projects DW tables not populated

Issue 3: SDE_FUSION_10_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_EGPITEMSPUBLICMODELAM_ITEM hangs

 

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
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.