Team Member is Added to Accrual Budget Error: "ORA-00001: Unique Constraint (AMS.AMS_ACT_ACCESS_U2) Violated" (Doc ID 2027341.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

12.1.3 version, Funds and Budgets

Getting Error When Team Member is Added to Accrual Budget

Error

ORA-00001: unique constraint (AMS.AMS_ACT_ACCESS_U2) violated in Package AMS_access_PVT Procedure create_access


Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Add Group1 in profile 'OZF : Default Team for Offers'.
  2. Create Fully Accrued Budget.
  3. Navigate to Team cuecard. Add Group1 in the Team UI.


Due to this issue, users cannot add Group to Fully Accrued Budget's team.

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