My Oracle Support Banner

Scenario RESET_SUBJECT_AREA Is Failing When Running "Execute Reset Data Warehouse For Fact Groups" In OBIA 11.1.1.10.3 (Doc ID 2770556.1)

Last updated on OCTOBER 28, 2022

Applies to:

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

Symptoms

In OBIA 11.1.1.10.3, scenario RESET_SUBJECT_AREA is failing with below error when "Execute Reset Data Warehouse for Fact Groups" is executed in BIACM for AP, AR & GL fact groups.

Error:
ODI-1217: Session RESET_SUBJECT_AREA (74540) fails with return code 7000.
ODI-1226: Step RESET_SUBECT_AREA fails after 1 attempt(s).
ODI-1232: Procedure RESET_SUBECT_AREA execution fails.
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 8, in <module>
File "<string>", line 8, in <module>

java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Caused by: Traceback (most recent call last):
File "<string>", line 8, in <module>
File "<string>", line 8, in <module>

java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Caused by: Error : 936, Position : 238, Sql =
SELECT DATASOURCE_NUM_ID, PACKAGE_NAME, TARGET_TABLE_NAME, ETL_USAGE_CODE, ETL_PROC_WID, LOAD_PLAN_ID, LAST_MAX_DATE, ETL_LOAD_DATE, FACT_GROUP, COMMITTED, WIP_LOAD_START_DATE FROM W_ETL_LOAD_DATES WHERE TARGET_TABLE_NAME IN () ORDER BY 1 DESC NULLS LAST
, OriginalSql =
SELECT DATASOURCE_NUM_ID, PACKAGE_NAME, TARGET_TABLE_NAME, ETL_USAGE_CODE, ETL_PROC_WID, LOAD_PLAN_ID, LAST_MAX_DATE, ETL_LOAD_DATE, FACT_GROUP, COMMITTED, WIP_LOAD_START_DATE FROM W_ETL_LOAD_DATES WHERE TARGET_TABLE_NAME IN () ORDER BY 1 DESC NULLS LAST
, Error Msg = ORA-00936: missing expression

Changes

 NA

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.