My Oracle Support Banner

OBIA 11g: SDE_FUSION_11_ADAPTOR_SDE_FUSION_FIXEDASSETLOCATIONDIMENSION mapping fails with ORA-00904: "FLEXVO"."LOC_STATE_": invalid identifier error (Doc ID 2509744.1)

Last updated on NOVEMBER 29, 2019

Applies to:

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

Symptoms

SDE_FUSION_11_ADAPTOR_SDE_FUSION_FIXEDASSETLOCATIONDIMENSION OOTB Mapping Failing with error "ORA-00904: "FLEXVO"."LOC_STATE_": invalid identifier"

The Location 'KFF' for Fixed assets is not enabled in Fusion and is not pulled in BICCC extraction process.

Error:

Error:::java.sql.SQLSyntaxErrorException: ORA-00904: "FLEXVO"."LOC_STATE_": invalid identifier 


at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146) 
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322) 
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170) 
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473) 
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47) 
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1) 
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) 
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925) 

Environment Details: 

  1. BI Apps Version: OBIA 11.1.1.10.2
  2. Source System: Oracle Cloud Application Revision 13.18.10 (11.13.18.10.0 )
  3. No changes made to OOTB mappings. 
  4. Modules involved: Finance and HCM

Changes

 

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