Cost Accounting Distributions Ends In Error With ORA-00001: Unique Constraint (FUSION.CST_LAYER_COSTS_U1) Violated, Work Orders Were Not Costed With The Error Work Order Close Transaction Could Not Be Processed Because There Are Unprocessed Transactions
Last updated on MAY 01, 2018
Applies to:Oracle Fusion Cost Management Cloud Service - Version 22.214.171.124.0 and later
Oracle Fusion Cost Management - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Work orders are not costed and following can be seen in the 'Review Cost Accounting Distributions' UI when reviewing cost accounting distributions. The cost accounting distributions ends in error and with following error.
Process rolled back and aborted due to SQL Exception on ReceiptCost/StdCostReceiptCostIns: ORA-00001: unique constraint (FUSION.CST_LAYER_COSTS_U1) violated
Cost Accounting Process UI shows the below warning for the work order
The work order close transaction could not be processed because there are unprocessed transactions on this work order.
The issue can be reproduced at will with the following steps:
1. Create a workorderless non standard order
2. Complete the order
3. Navigate Costing > Cost Accounting
4. Tasklist > Create Cost Accounting Distributions
5. Search for cost org and cost book.
6. The cut off date is set
7. Click on Scheduled Process > Click Submit on "Create Cost Accounting Distributions" job
8. The process ends in error.
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