Skip to main content
Question

Error message when receiving an OF

  • September 26, 2025
  • 6 replies
  • 120 views

audreyS
Sidekick (Partner)
Forum|alt.badge.img+10
  • Sidekick (Partner)
  • 104 replies

 

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\")"}]

6 replies

Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 3 replies
  • October 9, 2025

Hello,

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


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 1 reply
  • October 16, 2025

Hi, 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\")"}]}}"

 


Forum|alt.badge.img+11
  • Hero (Partner)
  • 232 replies
  • October 17, 2025

Looks like a bug, and I would be reporting it to IFS.


Yathartha Karunananda
Hero (Employee)
Forum|alt.badge.img+9

Hi ​@audreyS ​@AUDE DEBLOOS ​@Warna,

This is a product defect. It will be fixed in 25R1 SU5 onwards.


audreyS
Sidekick (Partner)
Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 104 replies
  • October 21, 2025

Hi ​@Yathartha Karunananda 

 

Yes, I confirm that IFS wrote us a script to unblock production. 


audreyS
Sidekick (Partner)
Forum|alt.badge.img+10
  • Author
  • Sidekick (Partner)
  • 104 replies
  • October 21, 2025

HI ​@Yathartha Karunananda 

 

Yes, I confirm that IFS wrote us a script to unblock production.