Create ECO sequence at Script

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.