Team Member is Added to Accrual Budget Error: "ORA-00001: Unique Constraint (AMS.AMS_ACT_ACCESS_U2) Violated"
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:
- Add Group1 in profile 'OZF : Default Team for Offers'.
- Create Fully Accrued Budget.
- 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