Adding and saving a Component to a new Process Flow results in a 'Duplicate' error

Document ID : KB000084501
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ErrorMsg: AwE-5001 Database Query Error (8/14/17 10:28 AM)
Details: null
java.sql.SQLException: ORA-20034: Could not Add "" - duplicate
ORA-06512: at "AM9.AWAPI2", line 477
ORA-06512: at "AM9.AWAPI2", line 450
ORA-06512: at "AM9.AWAPI", line 112
ORA-06512: at "AM9.AWAPI", line 1390
ORA-06512: at "AM9.AW_WEB_API", line 181
ORA-06512: at line 1

When creating a new Process Flow, adding components and selecting the 'Apply' between components will result in an 'ORA-20034 duplicate' error.

Investigation
  1. Open Process Flow Selector
  2. Select New
  3. Define items in General tab
  4. Open Components tab
  5. Add a TEST_JOB
  6. Apply (don't click ok to close)
  7. Add another TEST_JOB
  8. Apply or OK will throw the error.
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Cllicking 'Apply' between adding components to a new Process flow results in a 'Duplicate' error. This is a bug.
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Applications Manager 9.2.1 - Available
Additional Information:
Workaround :
This only occurs the first time a second Component is added to a Process Flow and Apply/OK is selected. Closing/reopening or continuing to build Process Flow will not be met with the same error.