Release 12 Upgrade - Collection Failing Due To More Than One Row In Column Period_Name On Table CN_PERIOD
(Doc ID 1264609.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Incentive Compensation - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run collection process the following error occurs.
'The value NOV-09 for value set CN_SRS_OPEN_PERIODS occurs in more than one row in column period_name of table cn_periods and duplicate values are not allowed. Please choose a different value or contact your system administrator.'
The issue can be reproduced at will with the following steps:
(R) Compensation Manager
(N) Tasks > Collect Transactions
- Enter Operating Unit
- Transaction Source
- Transaction Type
- Enter start and end dates
- Schedule Request
Error is encountered
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |