Skip to main content
Question

Can I increase the field length of an IFS object table?


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14

Can I increase the field length of an IFS object table, specifically the field in the Scrapping_Cause_Tab, “REJECT_MESSSAGE”? Its length is 35 and we want to increase the field length to 100. Will this cause any issues? 

Please let me know if there are any options?

Thank you,

 

 

2 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1273 replies
  • May 15, 2024

@arebbeadle I did a quick check in IFS 23R2 DB and it seems that only the SCRAPPING_CAUSE_TAB contains the REJECT_MESSAGE column. This means that in the rest of the tables it’s referenced by REJECT_REASON.

 

It would seem safe to alter the length of the field, but I’d also wait for some confirmation from someone from R&D.

REJECT_REASON appears in quite a few places:

 


Forum|alt.badge.img+21
  • Superhero (Employee)
  • 427 replies
  • May 16, 2024

Hi @arebbeadle ,

My recommendation would be to stay away from doing this as changes to core tables become a nightmare when it comes to upgrades. You might also get issues with the variable lengths defined in the PL/SQL logic if they are set in a static manner. 

Not sure exactly what you are trying to do but have you considered using a custom attribute for an extended reject message so something similar?

Cheers


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings