Head Count Detail Report (XML) : Interpreting the Output

The concurrent report - Head Count Detail Report (XML) - is a quite buggy. It is also difficult to interpret give the lack of documentation. This note attempts to address both.

I used the following parameters to submit this report:

The output that I got was as follows. Issues or inputs are highlighted in yellow.

SJain1. Why does the report show 01-Apr-2012 to 30-Apr-2012, when I have run the report for 2-Apr-2012 to 1-May-2012?

A1. Looks like Custom Time Zone profile setup issue, check running some other XML report.

SJain2. What do Rev/ Non Rev mean and how is it derived?

A2. Work Structures > Job > Description > Extra Information button > Type=Job Category. Enter the Details field for Category Name and select Revenue Generating from the LOV

SJain3. Where does the application derive whether an employee is Permanent/Fixed Term/Contract? Headcount showing under “Contract” does not correspond to the number of active Contingent Workers existing in the system.

A3. It is based on the HR_PERSON_TYPE formula

SJain4. Why “29” days, when I have run the report for 30 days?

A4. Looks like Custom Time Zone profile setup issue, check running some other XML report.

SJain5. What determines whether a termination is voluntary or involuntary?

A5. It is based on the HR_MOVE_TYPE formula and HR_CWK_MOVE_TYPE formulas.

SJain6. Where is this coming from? Is it coming from the parameter “Days Prior to End Date”? If so, this is wrong. Report should display only either “31” or “29” depending on whether the hierarchy version is end dated or not. (See New Hire, Last 29 Days column, where the number “31” does not appear).

A6. Similar to Question 1 and may depend on the date parameters.

SJain7. We do have employees in BAE SYSTEMS Australia Ltd., which is the business group, but also an HR Organization. Why do these employees not show up on the report?

A7. Can you check with some other Business Groups and log a bug if the data is shown.

SJain8. What does it take to round the “%” calculated by the report down to 2 decimals?

A8. This is an Enhancement Request

Report Parameters
Business Group	Australia Business Group
Report Date From	01-APR-2012
Report Date To	30-APR-2012[SJain1]
Report Date	08-MAY-2012
Organization Hierarchy	Australia Ltd
Top Organization	Australia Ltd
Worker Type	B
Roll Up	Y
Budget	HEAD
Include Top Organization	Y
Include Assignment Type	A
Days Prior To End date	31

Organization Hierarchy					Australia Ltd						Version Number						1
Date From					01-APR-2012						Date To						30-APR-2012
Top Organization					Australia Ltd
Division	Rev / Non Rev[SJain2]	Begin ning Head/ FTE Count	Perm-anent	Contract		Fixed Term[SJain3]	NewHire/		Transfer			Offers		Vac-ant FTE	Termination/				End-ing Head/ FTE	Cha-nge	% Cha-nge
															PlacementEnd
							Last 29[SJain4]  Days	Cum-ula-tive	In	Out		Op-en	Acc- ept-ed		Volu-ntary	Invol-untary[SJain5]		Last 31[SJain6]  29 Days
AIR BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	21	0	1		21	0	0	1	0		0	0	0	0	0		0	22	1	4.76190
Australia Ltd	R	0 [SJain7]	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
COR BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	54	0	1		54	0	1	1	1		0	0	0	0	0		0	55	1	1.85185[SJain8]
DEL BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
LIS BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	11	0	0		11	0	0	0	0		0	0	0	0	0		0	11	0	0
MAR  BU	R	0	0	0		0	0	0	0	0		0	0	0	0	0		0	0	0	0
	N	17	0	2		17	0	3	0	0		0	0	0	0	0		0	20	3	17.6470

---

OLM : Organization Training Plans and other missing functionality (OLM)

Question I most often get asked in OLM implementations are:

1) I want to see a training calendar – basically a page which will show learners which future training classes are available.

2) I want to plan for my Training Budget

3) Training Requests - How can a manager request for a training which does not exist yet?

While you will have to wait for Oracle Fusion Applications which has functionality for Training Calendar, the training budget functionality is a bit of a mixed bag.

Basically, up until 11i, Oracle had a Sub Menu in the Training Administrator responsibility called “Organization Training Plans”. In the 11i OTA User Guide documentation from Oracle, there is a reference to how to set up the Training Plans functionality. (See MOS Note ID 296537.1).

However, in R12, Oracle has removed this Sub Menu from Learning Administrator Responsibility, as well as removed any reference to this documentation in the user or implementation guides.

On opening up an SR (#3-5750081811) with Oracle to check, the advice that I got was that to add the sub menu - OTA Organization Training Plans (Prompt - Organization Training Plans) to the Main Menu - OTA Learning Administrator Menu. However, I was also told that since OTA.J.RUP2 (released Oct 2007), Development will not support these forms. The only reason the Menu items still exist is to view historical data. Curiously, I was told to use learning paths in R12 for this functionality, but this functionality falls far short of what was being offered under Organization Training Plans functionality. Eventually, I had to raise an ER (Bug #14225543) for this.

As for a functionality to request for a new training session which does not exist yet, again, OLM falls short here. So there are few workarounds:

> a) Administrators can define a class as 'Planned'. Employees can enrol to this and if there is enough interest, the class can be scheduled.

> b) Define an SIT/ EIT through which managers or employees can request for training.

> c) Create a survey in OLM to request for training. Users could enrol for this and launch the questions needed to submit request for training. This information could then be reported on for planning purposes. I personally like this option the best, because this way, everything is integrated within OLM pages.

There are a number of other features that you would think is standard, but not available, e.g.: 

> Enrolling future dated hires into a future course.

> 

Exit Interview

XYZ Systems is committed to providing a positive work environment for its employees. This Exit Interview Process provides a valuable source of information to assist us to assess the overall quality of work life at XYZ. We therefore appreciate that you have agreed to take a few minutes to complete this questionnaire. Your responses will be treated with total confidence.

1. Name (optional):

2. Business Unit/Function:

i.e. Marketing, Financials, Purchasing, Land, AEW&C, Commercial, House Keeping ..….

6. Sex: Male Female

10. Please indicate the reason/s you are leaving XYZ Systems

Salary/Wage	Employment Conditions	Career Opportunities
Flexible work practices	Interesting Work	Work Location
Workplace Culture and Values	Family Reasons	End of Contract
Redundancy	Retirement	Others