Insert Period Cost Update Transaction via Inventory Interface Error:CSTPACIT.cost_det_move :CSTPPCIT.PERIODIC_COST_DET_MOVE:CSTPPCIT.PERIODIC_COST_DET_NEW_INSERT
(Doc ID 1641130.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterOracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
java/transaction/server/CostingManager.java
Symptoms
When attempting to performing Periodic Cost Update inserting a periodic cost adjustment using Open Interface MTL_TRANSACTIONS_INTERFACE (MTI) table,
the following error occurs.
ERROR
Error: CSTPACIT.cost_det_move :CSTPPCIT.PERIODIC_COST_DET_MOVE:ORA-01400:
cannot insert NULL into ("INV"."MTL_PAC_TXN_COST_DETAILS"."LAST_UPDATED_BY")
STEPS TO REPRODUCE
1. Inserting records directly into the mtl_transactions_interface for Periodic Cost Update.
WHAT IS WORKING
Periodic Cost Update through the form works successfully, but when doing it through Open Interface the error occurs.
Changes
CHANGES
-------------------
Started migration from 12.0.6 to 12.1.3.
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |