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.


12.1.3 version, Funds and Budgets

Getting Error When Team Member is Added to Accrual Budget


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.


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