Adhoc roles can be created through PL/SQL from database or they can be created from
Applications using User Management Responsibility. If PL/SQL is used to create roles,
all user names and role names in UPPER case to avoid some errors:
Script to Create an Adhoc Role:
-------------------------------
DECLARE
vRole VARCHAR2(100) := 'XAOATESTROLE';
vRoleDesc VARCHAR2(100) := 'XAOATESTROLE';
BEGIN
wf_directory.createAdhocRole( vRole,
vRoleDesc,
NULL,
NULL,
'Test Role for All Oracle Apps
users',
'MAILHTML',
'OPERATIONS', --USER NAME SHOULD BE IN CAPS
NULL,
NULL,
'ACTIVE',
NULL
);
dbms_output.Put_line( 'Created Role'
||' '
||vRole);
COMMIT;
END;
/
Result:
Created Role XAOATESTROLE