Hi @clint1028,

I don’t believe there’s a way of doing this through the application. You will have to create a oracle sequence for the Request No in the database and a BEFORE INSERT trigger which you can concatenate the string (‘ABC’) and the sequence number (‘001’). The trigger will look like this,

CREATE OR REPLACE TRIGGER eco_req_trig

BEFORE INSERT ON ECO_REQUEST_TAB 

FOR EACH ROW

BEGIN

  SELECT CONCAT('ABC-',eco_sequence.NEXTVAL)

  INTO   :new.request_no

  FROM   dual;

END;

/

However, it’s better to create a case and dispatch to IFS In order to get this done through a customization.

Hope this helps!

One option
Create new custom LU
When change request is created launch event what add line to this LU, change request id and your own id what you combine in sql event action.
Then custom field to original change request view to show value from this new custom LU

Hopefully you got my point what I try to explain ;)