My Oracle Support Banner

PBCS: Netsuite Initialization Fails With Error ORA-00001: unique constraint (Doc ID 2723587.1)

Last updated on AUGUST 30, 2024

Applies to:

Oracle Enterprise Planning and Budgeting Cloud Service - Version 20.03.50 and later
Information in this document applies to any platform.

Symptoms

Netsuite Data load rule execution fails at Import step and when run initialize source system that also fails with the error mentioned below.

Initialize Error
-----------------------
DEBUG [AIF]: Registering application: PBCS - Trial Balance
ERROR [AIF]: ORA-00001: unique constraint (xxxxx.AIF_TARGET_APPLICATIONS_U2) violated
ERROR [AIF]: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (xxxxx.AIF_TARGET_APPLICATIONS_U2) violated
Error in DatasourceSetup - initializeNetSuiteSource
Traceback (most recent call last):
File "", line 25, in initializeNetSuiteSource
RuntimeException: java.lang.RuntimeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (xxxxx.AIF_TARGET_APPLICATIONS_U2) violated
INFO [AIF]: FDMEE Process End, Process ID: 1061

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
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.