What's new in Customer Journeys?

Connect and learn more! ×
While running an SQL - error ORA-01031: insufficient privileges — Cloud Customer Connect
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

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

Received Response
26
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!