Skip to main content
Solved

Error message when receiving an OF

  • Sep 26, 2025 2:34 PM UTC
  • 14 replies
  • 486 views
audreyS
Sidekick (Partner)
Forum|alt.badge.img+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 ​@IWAAIOL ​@matt.watters,

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.

View original

    14 replies

    Do Gooder (Partner)
    Forum|alt.badge.img+1
    • AUDE DEBLOOS
    • Do Gooder (Partner)
    • Oct 9, 2025 8:46 AM UTC

    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

    Do Gooder (Partner)
    Forum|alt.badge.img+1
    • Warna
    • Do Gooder (Partner)
    • Oct 16, 2025 7:00 PM UTC

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

     

    Hero (Partner)
    Forum|alt.badge.img+12
    • malik.sally
    • Hero (Partner)
    • Oct 17, 2025 1:24 AM UTC

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

    Yathartha Karunananda
    Superhero (Employee)
    Forum|alt.badge.img+12

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

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

    ~If this response resolves your issue, mark it as the best answer~
    audreyS
    Sidekick (Partner)
    Forum|alt.badge.img+10
    • audreyS
    • Author
    • Sidekick (Partner)
    • Oct 21, 2025 3:44 PM UTC

    Hi ​@Yathartha Karunananda 

     

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

      audreyS
      Sidekick (Partner)
      Forum|alt.badge.img+10
      • audreyS
      • Author
      • Sidekick (Partner)
      • Oct 21, 2025 3:45 PM UTC

      HI ​@Yathartha Karunananda 

       

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

      GISANCAR
      Sidekick (Customer)
      Forum|alt.badge.img+8
      • GISANCAR
      • Sidekick (Customer)
      • Nov 24, 2025 11:59 AM UTC

      Hi ​@audreyS ,

      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?

      Do Gooder (Customer)
      Forum|alt.badge.img+6
      • IWAAIOL
      • Do Gooder (Customer)
      • Nov 24, 2025 3:36 PM UTC

      But is it weird that some shop orders are okay, but others get this error?

      Seems to be some basic data missing? 

      matt.watters
      Ultimate Hero (Partner)
      Forum|alt.badge.img+26
      • matt.watters
      • Ultimate Hero (Partner)
      • Nov 24, 2025 4:36 PM UTC

      ​@audreyS what is an OF?

      ​@Yathartha Karunananda what is the defect?

      If a response resolves your issue, please use "Best Answer" so that the thread can be closed and others can find solutions more easily. Regards - Matt
      Yathartha Karunananda
      Superhero (Employee)
      Forum|alt.badge.img+12

      HI ​@IWAAIOL ​@matt.watters,

      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.

      ~If this response resolves your issue, mark it as the best answer~
        audreyS
        Sidekick (Partner)
        Forum|alt.badge.img+10
        • audreyS
        • Author
        • Sidekick (Partner)
        • Nov 25, 2025 12:40 PM UTC

        hi ​@matt.watters

         

        Sorry, I'm talking about shop orders.

         

         

        Do Gooder (Partner)
        Forum|alt.badge.img+1
        • K.K
        • Do Gooder (Partner)
        • Dec 3, 2025 7:36 AM UTC

        Hi ​@audreyS,

        We're having the same error. Is it possible to send this script?

        audreyS
        Sidekick (Partner)
        Forum|alt.badge.img+10
        • audreyS
        • Author
        • Sidekick (Partner)
        • Dec 3, 2025 3:35 PM UTC

        hi ​@K.K 

        The correctid was provided on 25R1 SU5.

         

        ALTER TABLE SO_COST_DISTRIBUTION_TMP
        MODIFY (
            COST_BUCKET_PUBLIC_TYPE VARCHAR2(20 CHAR) NULL

          Do Gooder (Partner)
          Forum|alt.badge.img+2
          • YaheLK
          • Do Gooder (Partner)
          • Feb 10, 2026 9:21 AM UTC

          We have a similar issue in a customer for a different column in the same table. 

           

          Error details: [{"code":1407,"message":"ORA-01407: cannot update (\"IFSAPP\".\"SO_COST_DISTRIBUTION_TMP\".\"ACCUM_COST\") to NULL"}] 

           

          customer is in 25R1 SU5.

          Terms & ConditionsAccessibility statement