Labels

2017 absence absence management Account accounting AIM aliases AME and API application application utilities lookups approval assignments ATO Australia Bank bi publisher budget business business groups CAGR candidates cartisian product case CEMLI Center Stage channels Classification competency concurrent Configuration configuration profile constants contextualization conversion correction cost costing coverage area customization data database date DateTracked deductions define design develop DFF diagnostics document earnings ebs EIT Element employee enhancements erp excel expression extension failure Fastformula FBT Flexfield FND fndload foreign key forms Formula fringe benefit FRM-40654 from FTE Functions fund fusion GL global transfer grade help hierarchy HR HRMS human resource management system implementation income information interfaces internet interview job join key flexfield KFF KPI language learning leave legal employer legislation links lists localization location management New Year obia obiee OLF onboarding oracle oracle applications oracle descriptive flex field oracle descriptive flexfield oracle ebs oracle erp oracle fusion HCM oracle hrms oracle hrms interview questions oracle hrms modules oracle hrms modules list oracle hrms organization oracle hrms table oracle hrms tables oracle hrms tutorial oracle irecruitment oracle legal entities oracle lookups oracle organization hierarchy oracle payroll oracle payroll interview questions oracle payroll tables oracle self service order by Organization organization type otbi package package body package specification patch payg Payment payroll people group perform person personalisation phase pl/sql position primary key process profile programs project qualifier Query question questions Recruiting Center Recruitment regex regular expression reporting tool reports requests requirement requisition resume retropay RICE salary schema security profile select SIT smartorg sql statutory stores STP Super Superannuation system systems Table Taleo taleo 15B Taleo Recruitment tax termination test testing trunc update user group user management user type value set variables View Views Web ADI webadi where work relationship

Friday, 14 November 2014

Define Organizations - Part III


Related Oracle HRMS Tables

HR_ALL_ORGANIZATION_UNITS: The basic details of oracle erp organizations are stored here. There is also a translation table HR_ALL_ORGANIZATION_UNITS_TL for the organization name in each language installed.


HR_ORG_INFORMATION_TYPES: This holds the different types of organization information. Each type is defined in the oracle descriptive flex field - Org Developer DF as a context value. E.g. Work Day Information, Business Group Information, etc. When using the Organizations screen you would see the information types relevant to the org classification.

HR_ORG_INFO_TYPES_BY_CLASS: This oracle hrms table holds the org information types that are available for each classification. This data is seeded and there is no screen that displays these groupings. When you select a classification on the Org screen and press the Other button, this table is referenced to display the relevant org information types.

HR_ORGANIZATION_INFORMATION: This oracle hrms table is more complicated as it stores two distinct sets of information. To know which type of information is stored you need to check the value in column ORG_INFORMATION_CONTEXT.

When the value is ‘CLASS’ the row is used to link an organization to a classification. There will be one row for every classification used by an organization. The classification name is held in column ORG_INFORMATION1. If you create an organization, a row will be added here for every classification you save against that org. When the value is set to an information type (from HR_ORG_INFORMATION_TYPES) the columns ORG_INFORMATION1-20 are used to hold the values for that information type. So when you are in the Define Organizations screen and you press the others button and select an information type, the values you see in the fields on the screen come from this table.

The information type is a oracle descriptive flexfield context with some segments defined. Each segment is mapped to one of the ORG_INFORMATION columns in this table. When you open the information type field you see the individual segments and the value for each segment is held in the column in table HR_ORGANIZATION_INFORMATION that matches the column specified in the segment definition.

 The lookup ORG_TYPE holds values for the ‘Type’ field on the Define Organization screen. The lookup ORG_CLASS holds values for the Classifications Name field on the Define Organization screen.
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)