您可以使用下面的API为用户分配职责。您可以创建一个包含所需详细信息的表，并创建一个程序/脚本来为用户分配职责。

-- ----------------------------------------------------------
-- Add Responsibility to Oracle FND User
-- -----------------------------------------------------------
DECLARE
    l_user_name              VARCHAR2 (100) := 'BALA';
    l_resp_appl_short_name   VARCHAR2 (100) := 'XDO';
    l_responsibility_key     VARCHAR2 (100) := 'XDO_ADMINISTRATION';
    l_security_group_key     VARCHAR2 (100) := 'STANDARD';
    l_resp_start_date        DATE := TO_DATE ('22-05-2019');
    l_resp_end_date          DATE := NULL;
BEGIN
    fnd_user_pkg.addresp (
        username         => l_user_name
        , resp_app         => l_resp_appl_short_name
        , resp_key         => l_responsibility_key
        , security_group   => l_security_group_key
        , description      => NULL
        , start_date       => l_resp_start_date
        , end_date         => l_resp_end_date
    );
    COMMIT;
EXCEPTION
    WHEN OTHERS THEN
        ROLLBACK;
        dbms_output.put_line (sqlerrm);
END;