OBIA 11g: Some Scenarios Are Not Dropping Work Objects On Completion. (Doc ID 2016026.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

OBIA v11.1.1.8.1 +PB6
Target Database v12.1.0.2.2
Source Database v11.2.0.1.0
Source App EBS R12.1.2
Analytics Modules - Financials and Procurement & Spend
WebLogic 10.3.6
OBIEE 11.1.1.7.0
ODI 11.1.1.7.0
O/S Red Hat 6.3

There appears to be a loss of functionality, you have noticed that a number off the Source View Synonyms, created on the OBIA warehouse to point to views created on the source, are not being deleted after the scenarios complete.  There are 186 synonyms dating as far back as January, and you are able to cross reference them back to the scenarios which created them, but only back to 13 May.

Some can be expected, for example, if a run was killed, these 4 remain after 2 successful INCR Load runs


you have checked the tasks in the scenario session, and found the task required to drop the synonyms is missing in these 4.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms