How to set only 2 pointed users can change Inventory Part Status from A to D, or D to A?

Not the solution, but it gives an idea:

declare

  project_id_  varchar2(30);

  rev_no_   varchar2(10); 

  allowed_reg_pur_ varchar2(10);

  user_id_   varchar2(20);

  dummy     number;

  cursor get_usr_group is

    select count(0) from user_group_user

    where user_id= user_id_ 

    and user_group_id = (select user_group_id from user_group where upper(name) = 'PROJECT APPROVERS');

begin

  project_id_  := '&OLD:PROJECT_ID';

  -- Check if user is part of special  user group

  user_id_ := Fnd_Session_API.get_fnd_user;

  open get_usr_group;

  fetch get_usr_group into dummy;

  close get_usr_group;

  if (dummy = 0) then

     Error_SYS.Appl_General('General', 'ERR: You are not a member of the Project Approvers user group.' || chr(10) || chr(13) || 'You are not allowed to approve this project.');

  end if;

end;

Hi,

I would prepare an event action,

Assign these two users the same role and write a PL/SQL block one cursor will check Auth and count later if block check counter.

Best regard.

@nafismertapaydin Makes sense if you don't want to touch user groups (as in my example). This is a better solution as it keeps security in one type of functionality.