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
(Doc ID 2386823.1)
Last updated on AUGUST 05, 2018
Applies to:Oracle Fusion Cost Management Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Cost Management - Version 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!