Skip to content

Is there a way to auto-populate a new Change Request's number with an incrementing, prefixed sequence value, like 'ABC-0001,' 'ABC-0002,' and so on, purely through IFS application configuration?

Answer

No — there's no way to achieve an auto-incrementing, prefixed sequence number like this purely through IFS application configuration. The two realistic paths are: (1) implement it directly at the database level with a genuine Oracle SEQUENCE plus a BEFORE INSERT trigger on the relevant table that concatenates your fixed prefix string with the next sequence value into the target column, though this is a direct database-level customization outside the standard supported configuration mechanisms, carrying the general risks of any unofficial database-level change; or (2), the more supportable path, raise a case with IFS or your implementation partner to have this implemented as a proper customization through the standard development/release process instead.

← Browse Developer Studio, deployment, and upgrades questions