OBIA 11g Duplicates In FA_LEASE Table In EBS Causes Issues In BI Apps Pull (Doc ID 2017537.1)

Last updated on JANUARY 27, 2017

Applies to:

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

Symptoms

There are duplicate records in the EBS table FA_LEASE.  OBI uses this table to setup W_DOMAIN_MEMBER_G, W_DOMAIN_MEMBER_G_TL and as a result duplicates flow in the OBAW world and the load fails quite a number of times.

ORA-00001: unique constraint (OBI_BIACOMP.CSDMT1_PK) violated.


How can you resolve this issue?

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