My Oracle Support Banner

OBIA 11g: Scenario Still Uses Fusion 10 When Source Is Fusion 11 (Doc ID 2555764.1)

Last updated on DECEMBER 08, 2019

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Applications Consumer (OBIA) 11.1.1.10.2 version, 

Scenario used Fusion 10 when actual source is Fusion 11 after restart.

Due to incorrect source system, SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_PLANCANDIDATEDFFBIAM_FLEX_BI_PLANCANDIDATEDFF_VI failed during the initial load plan execution.

Upon restart, load plan failed again and upon checking the logs found that the schema used Fusion 10 where the source is Fusion 11 and the below errr

In the session log file, found the following error- 

Error:

[CDATA[ODI-1217: Session SDE_FUSION_11_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_PLANCANDIDATEDFFBIAM_FLEX_BI_PLANCANDIDATEDFF_VI (********) fails with return code 7000.

Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.

Task: 5 java.lang.Exception: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("L", "", "DS_FUSION_10_0_REPLSTG_FILES", "D") : SnpPschemaCont.getObjectByIdent :  SnpPschemaCont does not exist BSF info: Initialization and log header at line: 0 column: columnNo

at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:570)

at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:744)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2123)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:380)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:312)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:304)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:875)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.apache.bsf.BSFException: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("L", "", "DS_FUSION_10_0_REPLSTG_FILES", "D") : SnpPschemaCont.getObjectByIdent :  SnpPschemaCont does not exist BSF info: Initialization and log header at line: 0 column: columnNo

at bsh.util.BeanShellBSFEngine.eval(Unknown Source)

at bsh.util.BeanShellBSFEngine.exec(Unknown Source)

at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:556)

... 11 more

 

In the session logs, found the the startup variables still use Fusion 10,

Field type="java.lang.String" name="StartupVariables">
<![CDATA[
BIAPPS.PRUNE_DAYS=1
BIAPPS.ETL_PROC_WID=<PROC_ID>
BIAPPS.EXECUTION_ID=<EXECUTION_ID>
BIAPPS.CLOUD_FILE_NAME= 
BIAPPS.DIAG_AUTOCORRECT=Y
BIAPPS.DIAG_EXEC_NUMBER=0
BIAPPS.CLOUD_SDS_LSCHEMA=DS_FUSION_11_0_SDS
BIAPPS.DATASOURCE_NUM_ID=<DATASOURCE_ID>
BIAPPS.WH_DATASOURCE_NUM_ID=<WH_DATASOURCE_ID>
BIAPPS.DIAG_ERR_LOG_SUPPORTED=Y
BIAPPS.CLOUD_FILE_LOGICAL_SCHEMA=DS_FUSION_10_0_REPLSTG_FILES
BIAPPS.PRODUCT_LINE_VERSION_CODE=FUSION_11_0

Ran the below SQL against SDS Schema and found that "Table doesn't exist"

 

Environment Details:

  1. OBIA Version: 11.1.1.10.2
  2. ODI Version : 11.1.1.9.0
  3. Source System and its version: Oracle cloud FUSION 11 Fusion HCM, CRM, and FSCM
  4. Target Database: Oracle Database  12.1.0.2.0
  5. Modules being used: Financials, Project Analytics, Procurement and Spend, Human Resource

 

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.