Training Calendar BIP report for Learning Module

Srinivas Venkatesh

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Blackbox Ltd

Description (Required):

We are developing the BIP report to fetch all the learning courses and displaying it based on employee login, we are trying to add DFF and split the courses based on functional and technical courses.

We are unable to get the training calendar displayed for whole month based on the functional/technical courses

Use Case and Business Need (Required):

We have developed new BIP report to display the learning courses in calendar view based on the parameters(month) for each employees login, we are trying to display the courses separately in 2 templates based on functional/technical courses which is mentioned in DFF field.

We are unable to link the DFF field with the main query, so any inputs on this would be helpful

Attaching the report catalogue

DFF query to link in main data set

Learning Calendar.zip

select distinct WLCF.CRS_ATTRIBUTE2 from WLF_LI_COURSES_F WLCF

where 1=1 

and L.LEARNING_ITEM_ID=WLCF.LEARNING_ITEM_ID(+)

and WALIV.learning_item_id=WLCF.LEARNING_ITEM_ID

and TRUNC(SYSDATE) BETWEEN WLCF.EFFECTIVE_START_DATE AND WLCF.EFFECTIVE_END_DATE

Enhancement Request / Service Request: