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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

BI tables data differences - e.g. WLF_LI_COURSES_F vs WLF_LEARNING_ITEMS_F

edited Dec 12, 2024 2:12PM in Learning 6 comments

Summary:

WLF_LI_COURSES_F, WLF_LI_CLASSES_F, WLF_LI_ACTIVITIES_F, WLF_LI_SPECIALIZATIONS_F

Content (please ensure you mask any confidential information):

Hi,

can someone explain what are the differences between the tables?

Two scenarios as an example:

  1. WLF_ASSIGNMENT_RECORDS_F joined to WLF_LI_COURSES_F (WLF_LI_COURSES_F.LEARNING_ITEM_ID = WARF.LEARNING_ITEM_ID)
  2. WLF_ASSIGNMENT_RECORDS_F joined to WLF_LEARNING_ITEMS_F (WLIFT.learning_item_id = WARF.learning_item_id AND WARF.learning_item_type IN 'ORA_COURSE')

Other tables I'm wondering about are: WLF_LI_CLASSES_F, WLF_LI_ACTIVITIES_F, WLF_LI_SPECIALIZATIONS_F

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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