Business Requirement: Need to display organization hierarchy diagrammatically with vacant and occupied/Active positions in each organization.
Report Should display default organization hierarchy of business group associated with responsibility from which Report is Opened.
Report Should also display active and vacant positions of whole Hierarchy as well as for individual Divisions/Departments/Sections/Units.
Following should be format of individual Division/Department/Section/Units of Hierarchy
.
Organization name : Name Of Organization
Organization Type : Division /Department/Section /Unit
Active Positions : No of Positions which are Occupied On Current date For
Given Organization.
Vacant Positions :No of Positions Which Are not Occupied By Employee in
Given Organization.
NOTE :
1)In Our case All Positions are Single Incumbent.
2)We are not Considering Business Group In Hierarchy our Hierarchy starts
from Division.
BG => Group =>Division =>Department => Section =>Units
So our hierarchy starts from Highlighted part.
The following should be Design of Report which contains one drop down list for selecting Division and Based On that Division
Report Should Be populated for selected division’s Hierarchy.
Challenges :
1)This kind of report is not possible to develop with report builder(Rtf/Rdf) or Discoverer Report.
2)Using OA Framework, you can create some charts but OA framework does not support organization charts as per our requirements..
Possible options for solutions :-
Solution Option 1) We can create Organization hierarchy using APEX(Oracle Application Express) but problem is for using Apex
we have to do whole installation of apex on production and then Integrate Apex With Oracle Apps and that process is time
consuming so we haven’t used this solution because of time limit.
Solution Option 2) We have found Google api for creating organization chart.you can check below link for Google api
Link : http://code.google.com/apis/chart/interactive/docs/gallery/orgchart.html
In this Google api you have to give data in particular format so it will create Hierarchy on given page. Here problem is how to give data
to Google Organization chart Api because we have to give dynamic data according to selected Division from Drop-Down List.
So I have decided to use (Solution Option 2) custom jsp page for retrieving data from database and giving that data to Google API.
Below Is the link for Source Code of Organization Chart. The jsp code below will be registered as a form function in Oracle Applications.
http://www.apps2fusion.com/training_demo/dakshesh/OrgChart/orgchart.jsp
Change Database credential in below shown Connection String whenever it is used in page.
2) Login to Putty in Your Application.
3) Execute below command in putty
5) Enter ftp_path of step 4 in remote system
6) Transfer attached orgchart.jsp jsp file to ftp.
7) go to putty and execute command: cd $FND_TOP/patch/115/bin
8) Execute below command in putty
10) Attach function To below menu.
11) Create below Responsibility and attach Below Menu.
12) Attach Responsibility created in Step 10 to your user.
13) Go to profile options and set below value of below profile option for responsibility created in step (11).
Organization Hierarchy Available
According to Your Requirement)
14) Login to Your User for Which New Created Responsibility
“Organization Chart Responsibility” is added.
You can Find Below Output .
OUTPUT:
Select Division From Drop Down list and Click on ok .It Will Display Below Chart.
Select All from Division DropDow List And Click on Ok , so it Will Display Organization Hierarchy For All Divisions.
Here size of report is very big for all division so you have to use navigation of browser for complete report.
You can save report using browsers Save as Functionality.
Below is output file using save as functionality.
http://www.apps2fusion.com/training_demo/dakshesh/OrgChart/SEHA_Organization_Chart.htm
NOTES :
1) Organization Chart is secured against responsibility so it will show Organization Hierarchy for business group associated with
responsibility from Where chart is opened. Business Group Value is Taken From Profile option ‘HR: Security Profile’ so
this Profile option must Be set For Showing Organization Hierarchy if you Don’t want this kind of security then
You can change Code of orgchart.jsp file according to Your requirement.
2) This Report Is Designed For One Particular Client requirement but You can change it According to your Requirement.
Report Should display default organization hierarchy of business group associated with responsibility from which Report is Opened.Report Should also display active and vacant positions of whole Hierarchy as well as for individual Divisions/Departments/Sections/Units.
Following should be format of individual Division/Department/Section/Units of Hierarchy
.
Organization name : Name Of Organization
Organization Type : Division /Department/Section /Unit
Active Positions : No of Positions which are Occupied On Current date For
Given Organization.
Vacant Positions :No of Positions Which Are not Occupied By Employee in
Given Organization.
NOTE :
1)In Our case All Positions are Single Incumbent.
2)We are not Considering Business Group In Hierarchy our Hierarchy starts
from Division.
BG => Group =>Division =>Department => Section =>Units
So our hierarchy starts from Highlighted part.
The following should be Design of Report which contains one drop down list for selecting Division and Based On that Division
Report Should Be populated for selected division’s Hierarchy.
Challenges :
1)This kind of report is not possible to develop with report builder(Rtf/Rdf) or Discoverer Report.
2)Using OA Framework, you can create some charts but OA framework does not support organization charts as per our requirements..
Possible options for solutions :-
Solution Option 1) We can create Organization hierarchy using APEX(Oracle Application Express) but problem is for using Apex
we have to do whole installation of apex on production and then Integrate Apex With Oracle Apps and that process is time
consuming so we haven’t used this solution because of time limit.
Solution Option 2) We have found Google api for creating organization chart.you can check below link for Google api
Link : http://code.google.com/apis/chart/interactive/docs/gallery/orgchart.html
In this Google api you have to give data in particular format so it will create Hierarchy on given page. Here problem is how to give data
to Google Organization chart Api because we have to give dynamic data according to selected Division from Drop-Down List.
So I have decided to use (Solution Option 2) custom jsp page for retrieving data from database and giving that data to Google API.
Below Is the link for Source Code of Organization Chart. The jsp code below will be registered as a form function in Oracle Applications.
http://www.apps2fusion.com/training_demo/dakshesh/OrgChart/orgchart.jsp
Deployment Steps:-
1) Open below orgcahrt.jsp file(Attached Above) and change password of your database instance when ever needed in page and save file.Change Database credential in below shown Connection String whenever it is used in page.
2) Login to Putty in Your Application.
3) Execute below command in putty
ftp_path : cd $COMMON_TOP/webapps/oacore/html
4) Login to ftp5) Enter ftp_path of step 4 in remote system
6) Transfer attached orgchart.jsp jsp file to ftp.
7) go to putty and execute command: cd $FND_TOP/patch/115/bin
8) Execute below command in putty
perl ojspCompile.pl --compile -s orgchart.jsp
9) Create one function in application.Function name : Organization Chart
Function Code : ORGANIZATION_CHART
html call : orgchart.jsp
10) Attach function To below menu.
Function Name : Organization Chart
User Name :Organization Chart Menu
Menu Name : ORG_CHART_MENU
11) Create below Responsibility and attach Below Menu.
Responsibility Name : Organization Chart Responsibility
Responsibility Key : ORG_CHART_RESP
Menu name : Organization Chart Menu
12) Attach Responsibility created in Step 10 to your user.
13) Go to profile options and set below value of below profile option for responsibility created in step (11).
Responsibility name : Organization Chart Responsibility
Profile option Name : HR: Security Profile
Profile Option value : Vision Industries (or You can Select
Other Business group WhereOrganization Hierarchy Available
According to Your Requirement)
14) Login to Your User for Which New Created Responsibility
“Organization Chart Responsibility” is added.
You can Find Below Output .
OUTPUT:
Select Division From Drop Down list and Click on ok .It Will Display Below Chart.
Select All from Division DropDow List And Click on Ok , so it Will Display Organization Hierarchy For All Divisions.
Here size of report is very big for all division so you have to use navigation of browser for complete report.
You can save report using browsers Save as Functionality.
Below is output file using save as functionality.
http://www.apps2fusion.com/training_demo/dakshesh/OrgChart/SEHA_Organization_Chart.htm
NOTES :
1) Organization Chart is secured against responsibility so it will show Organization Hierarchy for business group associated with
responsibility from Where chart is opened. Business Group Value is Taken From Profile option ‘HR: Security Profile’ so
this Profile option must Be set For Showing Organization Hierarchy if you Don’t want this kind of security then
You can change Code of orgchart.jsp file according to Your requirement.
2) This Report Is Designed For One Particular Client requirement but You can change it According to your Requirement.
Comments
(7)
Subscribe to this comment's feed
Issue after following the steps
written by sanjaysingh , October 31, 2011
written by sanjaysingh , October 31, 2011
Dear
I have followed all the steps as mentioned by you and I am trying to do this on 11.5.10.2 instance.
When I clik on my defined function, it opens the Oracle EBS login page and not the page which is been show in the article.
The log file at time of compiling the orgchart.jsp file is as below:
Forcibly recompiling list:
[invalid] /d04_testapp/appltop/testcomn/html/orgchart.jsp
OJSPC VERSION: 8i 1.1.0.2
synchronizing dependency file:
loading deplist...15417
enumerating jsps...15417
updating dependency...1
parsing jsp...1
writing deplist...15417
initializing compilation:
enumerating jsps...0
eliminating children...0 (-0)
searching uncompiled...0
1491058 FINISHING Mon Oct 31 18:03:08 2011
Have you come across this issue, if yes then please let us know where we are going wrong.
Regards,
Sanjay
Votes: +0
I have followed all the steps as mentioned by you and I am trying to do this on 11.5.10.2 instance.
When I clik on my defined function, it opens the Oracle EBS login page and not the page which is been show in the article.
The log file at time of compiling the orgchart.jsp file is as below:
Forcibly recompiling list:
[invalid] /d04_testapp/appltop/testcomn/html/orgchart.jsp
OJSPC VERSION: 8i 1.1.0.2
synchronizing dependency file:
loading deplist...15417
enumerating jsps...15417
updating dependency...1
parsing jsp...1
writing deplist...15417
initializing compilation:
enumerating jsps...0
eliminating children...0 (-0)
searching uncompiled...0
1491058 FINISHING Mon Oct 31 18:03:08 2011
Have you come across this issue, if yes then please let us know where we are going wrong.
Regards,
Sanjay
report abuse
vote down
vote up
Resolved the Initial Issue, But now the Division and Business Group field is coming as NULL
written by sanjaysingh , November 01, 2011
written by sanjaysingh , November 01, 2011
Hi,
I was just working on fixing the above issue and then I was receiving the following error:
Request URI:/OA_HTML/orgchart.jsp
Exception:
oracle.jsp.parse.JspParseException: Line # 1, Error: Invalid attribute: pageEncoding
To resolve the above issue in the orgchart.jsp file I replaced the first line -
with
and recompiled the page and now I am able to get the page but the Division LOV is showing no value and even Business group is coimg null and entire page is showing no data..
Any update on this will be really helpful. In the mean time I am working on it and will update if I get the fix.
Regards,
Sanjay
Votes: +0
I was just working on fixing the above issue and then I was receiving the following error:
Request URI:/OA_HTML/orgchart.jsp
Exception:
oracle.jsp.parse.JspParseException: Line # 1, Error: Invalid attribute: pageEncoding
To resolve the above issue in the orgchart.jsp file I replaced the first line -
with
and recompiled the page and now I am able to get the page but the Division LOV is showing no value and even Business group is coimg null and entire page is showing no data..
Any update on this will be really helpful. In the mean time I am working on it and will update if I get the fix.
Regards,
Sanjay
report abuse
vote down
vote up
Very Good Document - forward pls
written by Muhammad Salim , December 01, 2011
written by Muhammad Salim , December 01, 2011
Dear,
Pls forward to me this document as its very good efforts by you and very usefull for all.
regards,
Muhammad Salim
Votes: +0
Pls forward to me this document as its very good efforts by you and very usefull for all.
regards,
Muhammad Salim
report abuse
vote down
vote up
hi
written by dan mason , February 27, 2013
written by dan mason , February 27, 2013
hi trying to implement this in r11i
get the following error when compiling:
[20947] !!TRANSLATION ERROR(0) orgchart.jsp:
Parse error in orgchart.jsp:
oracle.jsp.parse.JspParseException: Line # 1,
Error: Invalid attribute: pageEncoding
Votes: +0
get the following error when compiling:
[20947] !!TRANSLATION ERROR(0) orgchart.jsp:
Parse error in orgchart.jsp:
oracle.jsp.parse.JspParseException: Line # 1,
Error: Invalid attribute: pageEncoding
report abuse
vote down
vote up
run in local jdeveloper
written by Omar Qabbani , April 09, 2013
written by Omar Qabbani , April 09, 2013
is it possible to run the jsp created on local machine under jdeveloper before load to application because in our development instance we have to stop_all start_all to check jsp affects after each code change
if yes could any one please define full steps
we use 12.0.6
thanks all
Votes: +0
if yes could any one please define full steps
we use 12.0.6
thanks all
report abuse
vote down
vote up
It was excellent idea and especially sharing this idea. I had this kind of requiremnt with my client but i said it is not possible. Now i feel much better. i will ask my technical team to test the same.
I hope similarly we can do the same for position hierarchy. This will be helpful during manpower planning.
Stalin G