Unique Constraint Error Due To Creating Manual Transactions
(Doc ID 824573.1)
Last updated on FEBRUARY 07, 2021
Applies to:Oracle Incentive Compensation - Version 18.104.22.168 to 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
When creating manual transactions, Oracle Incentive Compensation allows you to create a transaction, then change the values and create another one without navigating back to Transaction > Adjust > New Transaction.
If you have already created one transaction, Oracle Incentive Compensation allows you to change the Resource Number and create another transaction without first selecting the resource from the list of values. When you do this, the salesrep_id from the first transaction and the new resource number you entered are associated with the new transaction, which is incorrect. This causes the below error when trying to load the transactions.
Steps To Reproduce:
(R) Incentive Compensation Super User
- New Transaction
- Select a resource using the LOV.
- Enter a processed_date, transaction amount and invoice number.
- Click on Create.
- Enter the same resource number in the Resource Number field and click on Create again WITHOUT selecting the resource from the LOV.
- Try to load the transaction by navigating to Transaction > Load > Submit Request
- Error is encountered
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