Cost Accounting Creation Process (CM_CSTACCTG) failed due to Error "805 - ORA-00001: unique constraint (EMDBO.PS_CM_DEP_VAR_COST) violated " at step CM_COSTING.DepCost.GBL.default.1900-01-01.DepCost.OnExecute (Doc ID 2862513.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Symptoms

Cost Accounting Creation Process  (CM_CSTACCTG) failed due to Error "805 - ORA-00001: unique constraint (EMDBO.PS_CM_DEP_VAR_COST) violated " at step CM_COSTING.DepCost.GBL.default.1900-01-01.DepCost.OnExecute

The issue can be reproduced at will with the following steps:
     1. Navigate : Items > Define Items and Attributes > Define Item
          Create new Item (T5)
          Click Purchasing Item Attributes
          Enter Standard Price 0.166
          Click Item Supplier
          Enter Supplier SCM0000001
     2. Navigate : Items > Define Items and Attributes > Define Business Unit Item
          Create Business US010
     3. Navigate: Purchasing > Purchase Orders > Add/Update POs
          Create Two Purchase orders (0000000445 & 0000000446) with Purchase Order quantity 300 and Sales Tax (Tax Code : NYC; Rate : 4.25) in the Schedule Page
          Enter Matching : STANDARD
          Enter IN Unit : US010
          Save and Dispatch (PO ID : 0000000445)
     4. Create another PO 0000000446  as same as 0000000445  and dispatch it
     5. Navigate: Purchasing > Receipts > Add/Update Receipts
          Create Receipt (0000000168) for PO 0000000445
          Note : Interface Receipt is checked
          Click Pending of INV Status Enter Putaway Location
     6. Create Receipt (0000000169) for PO 0000000446
          Navigate : Inventory > Manage Inventory > Analyze Inventory > Review Transaction History
          Search the Item
          Putaway created for both receipts
     7. Navigate : Accounts Payables > Vouchers > Regular Entry
          Create the  voucher for the receipt 0000000168, Select Use Tax.
          Run Matching and Posting
     8. Create the voucher for the receipt 0000000169. [Check at the line level and use Sales Tax]
          Run Matching and Posting
     9. Create Purchase order (0000000447) with 900 quantity
          Matching : STANDARD
          IN Unit : US010
          Sales Tax : NYC
          Save and Dispatch it
     10. Create receipt for PO ID 0000000447 with  639 quantity
          Enter Putaway & Interface Receipt is checked
     11. Create receipt for PO ID 0000000447 with  261 quantity
          Enter Putaway & Interface Receipt is checked
     12. Navigate : Accounts Payables > Vouchers > Regular Entry
          Create the  voucher by copying the purchase order 0000000447
          Quantity 639
          Enter Sales Tax 4.51 and Total 110.58
          Click Payments
          Enter Gross Amount 110.58
          Save
          Click Ok
          Do matching
     13. Navigate : Purchasing > Return to Vendor
          Create RTV  by selecting the receipt 0000000171
          Dispatch Option : Dispatch when Shipped
          Action : Replace
          Disposition : Ship
          Return Quantity 261
          Click RTV Defaults
          RTV Adjustment Voucher : Create Adjustment
          Save     
     14. Navigate : Inventory > Fulfill Stock Orders > Stock Requests > Express Issue
          BU : US010 Request Type : Supplier Returns
          Select RTV
          Save and Deplete on Hand Quantity
          Say ok for the message [RTV, 0000000012, has been scheduled for dispatch.  The process instance number is 254492. (10302,108)]
     15. Navigate : Inventory > Manage Inventory > Analyze Inventory > Review Transaction History
          Search the Item
          Four putaways and one RTV is created
          Navigate : Purchasing > Return to Vendor  > Reconcile RTVs
          Navigate : Accounts Payables > Batch Processes > Voucher Build
          Voucher Build Interfaces : Return to Vendor (Supplier)
          Run Voucher Build Process
     16. Navigate : Accounts Payables > Vouchers > Regular Entry
          Open the created adjustments voucher
          Run Matching and posting
     17. Navigate : Accounts Payables > Batch Processes > Extracts and Loads > Extract Landed Cost
          Run LC_EXTRACT process
     18. Navigate : Cost Accounting > Inventory and Mfg Accounting > Cost Accounting Creation
          Run Cost Accounting process for US010
          SQL error. Function:  SQLExec

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.