OBIA 11g - SIL_APTransactionFact Fails With Error "ORA-00001: unique constraint (W_AP_XACT_F_U1) violated" (Doc ID 1990332.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

OBIA 11g with EBS R12:

When running full load, SIL_APTransactionFact fails with the following error:

ORA-00001: unique constraint (W_AP_XACT_F_U1) violated

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