My Oracle Support Banner

OBIA 11g:FA13: During Icremental ETL the FTS task fail for VO RETURNREASONBASE & RETURNREASON (Doc ID 2480234.1)

Last updated on DECEMBER 05, 2018

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

In the 10.2 ETL run with Fusion-SCM fact groups, the following FTS tasks fail during Incremental ETL:
FTS_FUSION_FSCMTOPMODELAM_DOOTOPAM_RETURNREASONBASE
FTS_FUSION_FSCMTOPMODELAM_PRCPOZPUBLICVIEWAM_SUPPLIERPVO
FTS_FUSION_FSCMTOPMODELAM_DOOTOPAM_RETURNREASON

Error Details:
Load Plan Step Name:FTS_FUSION_FSCMTOPMODELAM_DOOTOPAM_RETURNREASONBASE
ODI-1217: Session
SDE_FUSION_11_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_DOOTOPAM_RETURNREASONBASE
(14698500) 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 "", line 12, in at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall

Load Plan Step Name:FTS_FUSION_FSCMTOPMODELAM_PRCPOZPUBLICVIEWAM_SUPPLIERPVO
ODI-1217: Session
SDE_FUSION_11_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_PRCPOZPUBLICVIEWAM_SUPPLIERPVO
(14749500) 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 "", line 12, in at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at
oracle.jdbc.driver.T4C8Oall.doOALL(T4C

Load Plan Step Name : FTS_FUSION_FSCMTOPMODELAM_DOOTOPAM_RETURNREASON
ODI-1217: Session
SDE_FUSION_11_ADAPTOR_FTS_FUSION_FSCMTOPMODELAM_DOOTOPAM_RETURNREASON
(14786500) 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 "", line 12, in at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.jav

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.