same positions with different hr department...?

[mamajid]

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

[mamajid]

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

[admin]

True you should use segment of flexfield where seems you were not using or was taking name in single segment. tks

[eng_ahmad_2007]

Dear Majid

The purpose of defining the "organization" segment is to work around the uniqueness nature of positions and be able to save the record with same position names.

Best Regards

Ahmad Ghanem

[razib]

I think Majed Vie is Correct.............