The number of training hours for your employees is displayed in the Training Success report and in the following workbooks:
Student Training Success (External Students) Analysis Workbook
Student Training Success (Internal Students) Analysis Workbook
Training Cost and Revenue Analysis Workbook
Employee Training Attendance Success (Organization Hierarchy) Status Analytics Workbook
Employee Training Attendance Success (Organization Hierarchy) Trend Analytics Workbook
The number of training hours is also displayed in the following KPI reports:
Training Attendance Status
Training Attendance with Job Category Status
Within Oracle Learning Management you can record the duration of a training event using a time period of your choice. For example, rather than recording an event in hours you might record it in weeks or months.
To enable the reports to display the number of hours of an event, a predefined formula,, TEMPLATE_BIS_TRAINING_CONVERT_DURATION, converts your time periods into hours.
OTA is installed with four predefined time periods. If you record the duration of events using these predefined time periods the formula automatically converts them into the following hours:
D (Day) = 8 Hours
W (Week) = 40 Hours
M (Month) = 169 Hours
Y (Year) = 2028 Hours
Note: You set up time periods in Oracle Training Administration using the Lookup type FREQUENCY.
However, you should copy and amend the formula if:
The number of hours per time period does not match those of your enterprise.
You have set up different time periods using the Lookup type FREQUENCY.
Additional frequencies you have set up are not automatically converted to hours using the predefined formula.
Amending the Default Hours
To ensure that the report and workbooks calculate the correct hours for your training events you can configure the predefined formula.
Adding Additional Training Time Periods
If you have defined your own training time periods using the FREQUENCY Lookup you must copy and amend the predefined formula. If you do not add your additional time periods to the formula the hours for these events will not be included in the report and workbooks.