Skip to main content
Solved

Extending the size of a char field

  • February 14, 2020
  • 6 replies
  • 487 views
eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • eqbstal
  • Superhero (Partner)
  • 701 replies

Hello,

A customer of mine has asked to extend one of the fields in IFS9.

My immediate answer was: no go. Don't do it.

The change is relatively simple when looking at the table itself, but the remaining things?

What is your opinion on this?

Regards,

Steve

Best answer by MikeArbon

Hi

I would never change a table setting in oracle. It may seem to be the obvious fix, but it really is not worth the risk. You may not see a problem for weeks/months/years, but when it does cause a problem, it will be a real headache. All changes should be via an IFS release (as annoying as that may be in some cases). 

Regards

Mike

Thanks for using the community, it helps me. I hope I can help you.

6 replies

Savinda Suvimal
Hero (Employee)
Forum|alt.badge.img+11
  • Savinda Suvimal
  • Hero (Employee)
  • 73 replies
  • February 14, 2020

Hi,

Does that means customer wants to increase the length of a column in database table?

/Savinda

Srikanth
Superhero (Partner)
Forum|alt.badge.img+18
  • Srikanth
  • Superhero (Partner)
  • 291 replies
  • February 14, 2020

I think you are right, don’t make any changes to standard fields and tables in IFS without checking with IFS as this can - 

  1. Invalidate the client’s IFS Support Contract for making changes to standard IFS objects
  2. There could be other dependent objects which will get affected.

Hope this helps.

Cheers, Srikanth
eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • eqbstal
  • Author
  • Superhero (Partner)
  • 701 replies
  • February 14, 2020

Customer wants to have more characters in the field. Here even a field with a lot of references and potential functionality: lot/batch on PO receipt. So I go with your remark, Srikanth, other dependent objects may/will be in place.

Thanks.

 

 

Thanks for using the community, it helps me. I hope I can help you.
MikeArbon
Hero (Customer)
Forum|alt.badge.img+10
  • MikeArbon
  • Hero (Customer)
  • 92 replies
  • Answer
  • February 14, 2020

Hi

I would never change a table setting in oracle. It may seem to be the obvious fix, but it really is not worth the risk. You may not see a problem for weeks/months/years, but when it does cause a problem, it will be a real headache. All changes should be via an IFS release (as annoying as that may be in some cases). 

Regards

Mike

https://www.linkedin.com/in/mikearbon
Mark.Feldpausch
Sidekick (Customer)
Forum|alt.badge.img+8
  • Mark.Feldpausch
  • Sidekick (Customer)
  • 30 replies
  • February 14, 2020

I think adding a custom field that is the size you need could be a reasonable work around.  You can display the custom field and hide the standard field that is too short.

eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • eqbstal
  • Author
  • Superhero (Partner)
  • 701 replies
  • February 15, 2020

@Mark.Feldpausch : The customer wants to have a field extended that has extra functionality against it: Part Master Data\Master Part\Part/Lot Tracking\Lot Batch Master for example. So a custom field will not do in my opinion.

Thanks for the input to all. I selected answer of @MikeArbon as best as this is also good to mention to customer.

 

Thanks for using the community, it helps me. I hope I can help you.


Terms & ConditionsCookie settingsAccessibility statement