When creating an idea, the following fields are populated
-Department
-Location
After saving and reviewing the field, the Department field is blanked out.
Release : All
The field (Department OBS) is what drives the values of Department,Location
therefore the best practice is to set the following fields to be required on the object creation:
1. Department OBS
2. Department
3. Location
When creating a department, a corresponding OBS unit is also created based on the selected entity and the parent department.
If a department has not been associated with a location, the department can be deleted.
When a department is deleted, its sub departments are also deleted.
The associations can be viewed from either Administration > Finance > Setup > Location > Properties > Departments or
Home > Organization > Departments > Properties > Location.
The following query can be used to get the OBS department and location associations
select
O.id, O.name OBSNAME, O.UNIQUE_NAME, OU.ID unitid, OU.UNIQUE_NAME,
OU.DEPTH
FROM
PRJ_OBS_TYPES O,
PRJ_OBS_UNITS OU,
PRJ_OBS_ASSOCIATIONS a
where O.id = OU.TYPE_ID
and OU.ID = a.UNIT_ID
order by OU.TYPE_ID, OU.ID