Cmlwsv(390): ORA-00001: unique constraint (WIP.WIP_SCRAP_VALUES_U1) violated (Doc ID 1990804.1)

Last updated on MARCH 18, 2015

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Costing Transaction Errors

Cost Worker fails with the following error:

cmlwsv(390): ORA-00001: unique constraint (WIP.WIP_SCRAP_VALUES_U1) violated

ERROR
-----------------------
cmlwsv(390): ORA-00001: unique constraint (WIP.WIP_SCRAP_VALUES_U1) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Cost Management -> Submit transactions to be costed
2. Request completes in error
3. Review the log file and see the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot cost transactions and close the accounting period.

Cause

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