Skip to main content
Question

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

  • May 15, 2024
  • 2 replies
  • 91 views

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)
  • 1298 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