Question

Calendar generation stop with error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

  • 25 March 2022
  • 3 replies
  • 354 views
A
Rank
Userlevel 5
Badge +9

Hi,

 

We are on IFS 10 upd 3

When generating the default manufacturing calendar in one of our sites  we get error:

Error while updating Shop Order. Order No: 2722487, Release No: *, Sequence No: *,Revised Start Date: 17-MAR-22, Due Date: 21-MAR-22. ORA-06502: PL/SQL: numeric or value error: character string buffer too small

What value on shoporder could cause this issue when generating the calendar?

 

Regards,

Anna

This topic has been closed for comments

3 replies

Charana Udugama
Rank
Userlevel 7
Badge +11

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

https://lk.linkedin.com/in/charanau
Tharindu Rasnakawewa
Rank
Userlevel 5
Badge +9

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

A
Rank
Userlevel 5
Badge +9

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

Terms & ConditionsCookie settings