AASoftech Inc. provides an interface that enables you to generate an organizational chart using Oracle database.
Web Organization Chart / Organization Chart .Net (Ora Version) is used to connect to the Oracle database. Ora version of "Web Organization Chart" selects information from the Oracle (HR) tables and converts it into a format that is readable for the Orgchart software.
Web Organization Chart / Organization Chart .Net (Ora Version) can also connect to Oracle Human Resources software (part of the Oracle E-business Suite -Oracle ERP). Web Organization Chart (Ora Version) can connect to the View in the Oracle Human Resources software to provide the hierarchical information of the human resource database.
Web Organization Chart / Organization Chart .Net (Ora Version) interface is made available by AASoftech.
Integration of WebOrgChart with Oracle HRMS 11i
The following are the steps for integrating weborgchart application with Oracle HRMS 11i
1) Create the View ReportTable (SQL Script attached). The View is based on several Core HRMS tables which store Employee, Department and Employee’s Assignment/Job Information (SQL Scripts attached).
2) Create a System/File DSN and add the following connection string in the Setting.asp file:
GetConnectionString = "dsn=DSN Name;UID=Oracle User ID;Password=Oracle User Password
Example: If you create a System DSN and the DSN Name is Chart and the Oracle Apps username is Apps (which will most likely be the case), then the connection string will be as follows:
GetConnectionString = "dsn=Chart; UID=apps;Password=apps"
Note: You will have to require Oracle ODBC Driver to create the DSN if the Oracle Database Server is on a Non-Windows Machine, Eg. Unix, Linux, Sun Solaris
Oracle Applications Versions used:
Oracle HRMS 11i(11.5.8), part of Oracle E-Business Suite 11i(11.5.8)
Oracle Database Server Enterprise Edition Version 8i(8.1.7.4.0) and 9i(9.2.0.2.0)
