Department Is Blanked Out Upon Idea/Project Creation
search cancel

Department Is Blanked Out Upon Idea/Project Creation

book

Article ID: 259417

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

When creating an idea, the following fields are populated
-Department
-Location

After saving and reviewing the field, the Department field is blanked out.

Environment

Release : All

Resolution

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  

 

Additional Information

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