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

Unable to Identify Join Between WLF_LI_ACTIVITIES_F and HRQ_QUESTIONNAIRES_B for Evaluation Details

Summary:

We need to retrieve evaluation details in our report. We are able to identify the evaluation records in the WLF_LI_ACTIVITIES_F table where the ACTIVITY_TYPE = 'ORA_DEF_QUESTIONNAIRE'. Additionally, we can access the questionnaire details in the HRQ_QUESTIONNAIRES_B table.

As shown in the screenshot, the evaluation details include a highlighted field that appears to be linked to the questionnaire name. However, we are unable to identify the correct join or linking table between WLF_LI_ACTIVITIES_F and HRQ_QUESTIONNAIRES_B.

Could you please help us identify the appropriate table or join condition to link these two tables?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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