+10
Hello,
I am in production at my client's site. He upgraded yesterday to version 25R1, and I am getting this error message when receiving an OF.
Have you ever seen this message before?
ORA-01400: impossible d'insérer NULL dans (\"IFSAPP\".\"SO_COST_DISTRIBUTION_TMP\".\"COST_BUCKET_PUBLIC_TYPE\")"}]
Best answer by Yathartha Karunananda
HI
If you have a zero-cost component within the shop order materials and issue it, the cost class "*" will be used for the actual costs.
Currently, this runs at receiving and closing of the shop order which leads into an ORA error message. The reason for this was COST_BUCKET_PUBLIC_TYPE column was not nullable.
+1Hello,
We have the same. WHat is the solution?
IFS Web Version: 25.1.2.20250702082751.0
Date: 2025-10-09T08:39:27.102Z
---------------------------------------------------------------------------
ReceiveShopOrder/ReceiveShopOrderAssistant@1 (erreur serveur)
Une erreur s'est produite avec la base de données. Contactez l'administrateur.
Error details: [{"code":1400,"message":"ORA-01400: impossible d'insérer NULL dans (\"IFSAPP\".\"SO_COST_DISTRIBUTION_TMP\".\"COST_BUCKET_PUBLIC_TYPE\")"}]
Request Id: a4d3ee6d-dc5c-4d40-a737-71dd642cc496
+1Hi, we are getting the same error. Any resolution for this?
body: "{"error":{"code":"DATABASE_ERROR","message":"Database error occurred. Contact administrator.","details":[{"code":1400,"message":"ORA-01400: cannot insert NULL into (\"IFSAPP\".\"SO_COST_DISTRIBUTION_TMP\".\"COST_BUCKET_PUBLIC_TYPE\")"}]}}"
+11Hi
This is a product defect. It will be fixed in 25R1 SU5 onwards.
+10Hi
Yes, I confirm that IFS wrote us a script to unblock production.
+10HI
Yes, I confirm that IFS wrote us a script to unblock production.
+8Hi
We have also encountered this error for some of our shop orders.
What kind of changes/updates is the script doing to unblock the problem?
But is it weird that some shop orders are okay, but others get this error?
Seems to be some basic data missing?
+26
+11HI
If you have a zero-cost component within the shop order materials and issue it, the cost class "*" will be used for the actual costs.
Currently, this runs at receiving and closing of the shop order which leads into an ORA error message. The reason for this was COST_BUCKET_PUBLIC_TYPE column was not nullable.
+10hi
Sorry, I'm talking about shop orders.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
