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 laterInformation 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,
<![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:
- OBIA Version: 11.1.1.10.2
- ODI Version : 11.1.1.9.0
- Source System and its version: Oracle cloud FUSION 11 Fusion HCM, CRM, and FSCM
- Target Database: Oracle Database 12.1.0.2.0
- 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 |