Assalam o Alikum
I am facing a scenario of same position in many department.
The organization is a fertilizer company and at plant site they have many departments which contain same position. For example
Position: Supervisor (Mechanical)
Department: Ammonia (Maintenance)
Position: Supervisor (Mechanical)
Department: Phosphate (Maintenance)
Now problem here is positions are same but departments are different
and oracle check duplication of positions at Position name level irrespective of defining different departments. Organization filed is unavoidable due to its mandatory nature.
Is their any way to make a record compound like same position but different organization (dept).
(Members who knows database designing must be having a concept of compound key which is unique every time).
Or is their any way to change the organization mandatory property to non-mandatory.
Regards
Majid
same positions with different hr department...?
I posted this question on OTN forum too and here is the answer which is workable.
"
Yours is a common requirement. In such cases it is a usual practise to have the position flex field one more segment to capture short name of the organization.
You should not make the organization field optional in the positions screen. This would break the code/validations delivered by Oracle.
Hope that helps."
Regards
Majid
"
Yours is a common requirement. In such cases it is a usual practise to have the position flex field one more segment to capture short name of the organization.
You should not make the organization field optional in the positions screen. This would break the code/validations delivered by Oracle.
Hope that helps."
Regards
Majid
-
- Posts: 258
- Joined: Sun Oct 12, 2008 1:50 pm
- Location: Saudi Arabia
- Contact:
Who is online
Users browsing this forum: No registered users and 1 guest