In this postI will sho how to create the sequence of an ECO via script. This sequence can be created directly within the responsibility of Engineering.
Engineering -> Setup -> Automatic Numbering
Within the possibilities a unique sequence can be registered for all the users or a sequence can be registered for each user and for each organization of inventory as images below.
Any user by organization
Specific user by organization
If you wanted to do an API integration you can also use Oracle’s script to create this sequence.
declare l_nxt_eco_number VARCHAR2(30); l_return_status VARCHAR2(10); begin BOMPCOAN.BOM_ECO_AUTONUMBER(26300,196,1,l_nxt_eco_number,l_return_status); dbms_output.put_line(l_nxt_eco_number); end;
26300 -> user_id
196 -> organization_id
So it is possible to do any registration within the setups and without making any modification in the code use the above script to get the right sequence for the right user.