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

Query to extract performance goal approver

edited Mar 11, 2025 3:18PM in Performance Management 5 comments

Summary:

I need to extract the name and person number of a performance goal approver (via BI Publisher)

Content (please ensure you mask any confidential information):

Hello,

I am working on a performance goal report in which I need to fetch the data of the level 1 approver.
I have searched multiple data tables in order to find a link but without success.

Here are the tables I use :
HRG_GOALS
FND_BPM_TASK_ASSIGNEE
HRC_TXN_DATA
HRC_TXN_HEADER

The link between HRG_GOALS and HRC_TXN_HEADER is the HRG_GOALS .goal_id = HRC_TXN_HEADER.object_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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