Unable To Set Partner Status From INACTIVE-EXPIRED To ACTIVE From Rest For A Partner Record

(Doc ID 2289913.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Partner Management

Unable to Set Partner Status from INACTIVE-EXPIRED to ACTIVE from rest api for a Partner Record
Customer is getting below error when we are trying to update Partner Status from INACTIVE-EXPIRED to ACTIVE for Partner with Company Number as 9180.
ORA-00001: unique constraint (FUSION.HZ_PARTY_USG_ASSIGNMENTS_U1) violated

We have tried same Operation for Other partner with Company Number as 9064 and it worked fine for us.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot change status of the record multiple times a day.

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