OBIA 11g: Incremental Logic Not Working For Lot Dimension Translate (Doc ID 2246084.1)

Last updated on MARCH 21, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

Incremental Logic not working for Lot Dimension Translate 

The SIL ETL which loads data in to the table W_LOT_D_TL does always an insert. There seems to be no unique, Primary index present either on the table W_LOT_D_TL. This is leading to creation of duplicates in this table. 

 

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