Define Organizations - Part IV

Frequently Asked Questions (FAQs)

How can I find the LOV used by a segment in the Information Type I select from the ‘Others’ button?

Query up the DFF ‘Org Developer DF’ and select the context whose name matches the name of the Information type you selected from the ‘Others’ button. The Segments screen lists the fields defined for that information type. The LOV will come from the validation used by the relevant segment.

Can I define 2 organizations with the same name?

This is possible but is not recommended and certainly not recommended when the system profile HR:Cross Business Group is set to ‘Yes’.

Where is the information from the Organization Manager Relationship screen held?

The Organization Manager Relationship screen uses the ‘Org Developer DF’ DFF. It is just another UI to the information type ‘Reporting Information’ for an organization with a classification of Cost Center. Only organizations with a classification of Cost Centre can be queried in the Organization Manager Relationship screen.

What sql can I run to show the classifications defined for an organization?

This sql will prompt you for an organization name

select i.organization_id, o.name, l.meaning
from hr_all_organization_units o
, hr_organization_information i
, fnd_lookup_values l
where o.organization_id = i.organization_id
and o.name = ‘&Organization_Name’
and i.org_information1 = l.lookup_code
and l.lookup_type = ‘ORG_CLASS’
and i.org_information_context = ‘CLASS’

What sql can I run to see the segment values for a specific Information Type for my organization?

This will be different depending on which Information Type you select. First open the Org Developer DF and find the structure for the Information type you require e.g. Work Day Information

See the COLUMN value for each segment. In this example: Segment Name Column Normal Start Time ORG_INFORMATION1 Normal End Time ORG_INFORMATION2 Working Hours ORG_INFORMATION3 Frequency ORG_INFORMATION4 Now create the sql selecting those columns from HR_ORGANIZATION_INFORMATION. The below mentioned sql will prompt you for an organization name

select o.name
, i.org_information1 Normal_Start_Time
, i.org_information2 Normal_End_Time
, i.org_information3 Working_Hours
, i.org_information4 Frequency
from hr_organization_information i
, hr_all_organization_units o
where o.name = ‘&Organization_Name’
and o.organization_id = i.organization_id
and i.org_information_context = ‘Work Day Information’

To create the sql for a different Information Type simply replace the SELECT section with the COLUMNs and aliases for that Information Type.

PREVIOUS POST || NEXT POST