Hi @atvanst,

This error can cause due to basically 3 reasons. 

1. When you try to assign a value to a numeric variable, but the value is larger than the variable can handle.
2. When you try to assign a value to a numeric variable, but the value is larger than the variable can handle
3. When you are trying to assign a NULL value to a NOT NULL constrained variable.

But it’s really hard to determine the exact reason without more information. If you are unable to determine and resolve the issue with this, please go ahead and raise a case to support. That’s the best option. 

Best Regards,
Charana

Hi @atvanst ,

As Charana very correctly mentioned, the ORA error can occur due to various reasons. And if we more focus on the particular ShopOrd LU, again there can be several functional verifications you need to do for this.
- If any revisions happened,  SOs Revised date can be set outside of the calendar range.
- Start dates can be checked to verify whether they are within the valid schedules.
- This can be an issue that shopord.api file got corrupted for some reason

Likewise there can be many reason to observe this issue in your environment. You can change the particular calendar and check if you have the ability to check the same in a test environment. Any way before for a judgement, this needs an investigation to find the exact root cause,
So as Charana suggested better if you and log a support case for further investigations.

Thanks and Best Regards,
Tharindu R

Thanks for your answers.

We managed to work around the issue by changing the site default manufacturing calender to once that was in generated status. When calender was no longer the default calendar we could generate it without any problem. Changing it back to be the default calendar also worked without any issue.

/Anna