Error when trying to create output device

Document ID : KB000084838
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPWORX.SO_PRINT_IDX) violated
ORA-06512: at "APPWORX.AWAPI", line 4461
ORA-06512: at "APPWORX.AW_WEB_API", line 2270
ORA-06512: at line 1

When trying to add a new output device through the interface an error is thrown after defining it and hitting Apply.
 
Cause:
Cause type:
Other
Root Cause: This is caused by a mismatch of the sequence number in the so_printers table vs the maximum value in the so_seqs table for the so_printer_seqs value.
Resolution:
Log into SQLPlus as the Applications Manager Oracle user and run the following two SQL statements:
 
SQL> select MAX(so_printer_seq) "printer seq" from so_printers;
SQL> select * from so_seqs;

If the value from the first statement is greater than the value for so_printer_seq from the second, please contact support.

Fix Status: No Fix

Additional Information:
Workaround :
N/A