My Oracle Support Banner

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 11.13.17.11.0 and later
Oracle Fusion Cost Management - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

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.


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.



STEPS
-----------------------
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.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.