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
Vacant Positions :No of Positions Which Are not Occupied By Employee in
1)In Our case All Positions are Single Incumbent.
2)We are not Considering Business Group In Hierarchy our Hierarchy starts
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.
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.
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/html4) Login to ftp
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
perl ojspCompile.pl --compile -s orgchart.jsp9) 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 SelectOther Business group Where
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 .
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.
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.
written by Stalin G , October 29, 2011
written by sanjaysingh , October 31, 2011
written by sanjaysingh , November 01, 2011
written by Muhammad Salim , December 01, 2011
written by dan mason , February 27, 2013
written by Omar Qabbani , April 09, 2013