Try using below SQL to search required Priviliges to run a specific ESS job in Oracle Fusion when user find below error message while submitting the ESS job.
ESS-02002: User 'XYZ' doesnot have sufficient priviliges to perform operation submitrequest 'ess job name'
SELECT p.code privilege
, t.name
, perm.code code
, perm.resource_type_name
, perm.action
FROM fusion.ase_privilege_b p
, fusion.ase_permission_b perm
, fusion.ase_privilege_tl t
WHERE p.privilege_id = perm.privilege_id
AND p.privilege_id = t.privilege_id (+)
AND t.language = 'US'
AND sysdate BETWEEN p.effective_start_date AND nvl(p.effective_end_date, sysdate)
AND sysdate BETWEEN perm.effective_start_date AND nvl(perm.effective_end_date, sysdate)
AND perm.code LIKE '%'|| :p_ess_job_name|| '%'
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.