Get Started with Redwood for Oracle Cloud HCM Begin Now
While running an SQL - error ORA-01031: insufficient privileges
Hello,
While running the below SQL, I have the error
ORA-01031: insufficient privileges
This query is to extract transaction id of a worker
select /* SR <3-35231785471> */
p.person_number,
gp.goal_plan_name,
d.transaction_id,
d.status,
d.creation_date
from
fusion.hrc_txn_header h
JOIN fusion.hrc_txn_data d ON h.transaction_id=d.transaction_id
JOIN fusion.per_all_people_f p ON p.person_id=h.INITIATOR_USER_ID
JOIN fusion.hrg_goal_pln_assignments gpa ON gpa.goal_plan_assignment_id = h.object_id
JOIN fusion.hrg_goal_plans_vl gp ON gpa.goal_plan_id = gp.goal_plan_id
0