My Oracle Support Banner

FTS_FUSION_FSCMTOPMODELAM_PJFPROJECTDEFINITIONAM_PROJECTCUSTOMERPVO fails with ORA-00001 error (Doc ID 2504223.1)

Last updated on AUGUST 15, 2019

Applies to:

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

Symptoms

FscmTopModelAM.PjfProjectDefinitionAM.ProjectCustomerPVO retrieves multiple records and the FTS_FUSION_FSCMTOPMODELAM_PJFPROJECTDEFINITIONAM_PROJECTCUSTOMERPVO fails with the below error:

Caused By: java.sql.SQLException: ORA-20942: ODI-1227: Task FTS_FUSION_FscmTopModelAM.PjfProjectDefinitionAM.ProjectCustomerPVO (Integration) fails on the source ORACLE connection BIA_SDS_FUSION_11.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BIA_SDS_FUSION_11.FSC_PJ_PRJCTCSTMRPTMRPV859336) violated

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.