You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

While running an SQL - error ORA-01031: insufficient privileges

Received Response
51
Views
5
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!