WebCenter Content: Imaging Attachments Cause SOA Error "ORA-00001: unique constraint (DEV_SOAINFRA.WFATTACHMENT_UNIQUE) violated"
Last updated on MAY 02, 2017
Applies to:Oracle WebCenter Content: Imaging - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
When processing invoices through Imaging and into the SOA Managed Server, some BPEL processes report this error in the SOA log:
Error occurred while inserting a task attachment record.
Error occurred while inserting attachment 3.IPM_001657 for task 220253.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.
... 150 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_SOAINFRA.WFATTACHMENT_UNIQUE) violated
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