Search Results hr_all_organization_units
The HR_ALL_ORGANIZATION_UNITS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical data structure within the Human Resources (HR) module, serving as the foundation for organizational hierarchy management. This table stores comprehensive information about all organizational units, including departments, divisions, business groups, and other enterprise structures, enabling businesses to model their workforce hierarchy effectively. Below is a detailed summary of its structure, purpose, and key attributes.
Overview and Purpose
The HR_ALL_ORGANIZATION_UNITS table acts as a central repository for organizational entities within Oracle HRMS (Human Resource Management System). It supports multi-org functionality, allowing organizations to define and manage hierarchical relationships across business units, legal entities, and operating units. This table is integral to workflows involving employee assignments, reporting structures, and security profiles.Key Columns and Descriptions
The table comprises several critical columns, each serving a specific purpose in organizational management:- ORGANIZATION_ID: Primary key uniquely identifying each organizational unit.
- NAME: Descriptive name of the organization (e.g., "Finance Department").
- TYPE: Classifies the organization type (e.g., "DEPARTMENT," "BUSINESS GROUP," "LEGAL ENTITY").
- DATE_FROM and DATE_TO: Define the active date range for the organization.
- INTERNAL_EXTERNAL_FLAG: Distinguishes between internal (company-owned) and external (third-party) organizations.
- LOCATION_ID: References the physical location (from HR_LOCATIONS) associated with the unit.
- BUSINESS_GROUP_ID: Links the organization to its parent business group.
- INTERNAL_ADDRESS_LINE: Stores internal contact details for the unit.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1-20: Flexfield columns for custom attributes.
Integration with Other Modules
The table integrates with multiple Oracle EBS modules:- Payroll: Determines cost centers and assignment hierarchies for payroll processing.
- GL (General Ledger): Maps organizations to accounting entities for financial reporting.
- Security: Forms the basis for role-based access control (RBAC) via HR_ORGANIZATION_UNITS.
- Projects: Links project teams to organizational units.
Technical Considerations
- Multi-Org Support: The table adheres to Oracle's Multi-Org architecture, segregating data by ORG_ID for secure access.
- Indexing: Key columns like ORGANIZATION_ID and BUSINESS_GROUP_ID are indexed for performance.
- Flexfields: Descriptive flexfields enable customization to meet industry-specific requirements.
Usage in Business Processes
Organizations leverage this table for:- Hierarchy Management: Defining parent-child relationships via HR_ORG_UNIT_CLASSES and HR_ORG_UNIT_HIERARCHIES.
- Reporting: Generating org charts and headcount analytics.
- Compliance: Tracking legal entities for regulatory reporting.
Conclusion
The HR_ALL_ORGANIZATION_UNITS table is a cornerstone of Oracle EBS HRMS, providing the structural framework for organizational modeling. Its design supports scalability, compliance, and integration across financial, payroll, and operational modules, making it indispensable for enterprise workforce management in Oracle EBS 12.1.1 and 12.2.2.-
Table: HR_ALL_ORGANIZATION_UNITS
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: PER - Human Resources , description: Organization unit definitions. , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
-
Table: HR_ALL_ORGANIZATION_UNITS
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: AS - Sales Foundation , description: - Retrofitted , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
-
Table: HR_ALL_ORGANIZATION_UNITS
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: AS - Sales Foundation , description: - Retrofitted , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
-
Table: HR_ALL_ORGANIZATION_UNITS
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: PER - Human Resources , description: Organization unit definitions. , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
-
APPS.PAY_KW_GENERAL dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.POA_CM_EVAL_SCORES_ICX dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PER_ASG_BUS1 dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.ITG_X_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.OTA_TRAINING_SS dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.BEN_EXT_PERSON dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PSB_WORKFLOW_PVT dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.HR_ORGANIZATION_API dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PAY_DK_SICKNESS_DP202 dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PAY_PAYRPBLK1_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PAY_SA_GOSI_REPORTS dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.WSH_MBOLS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.OE_ACKNOWLEDGMENT_PVT dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.AME_APPROVER_TYPE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.OKE_DTS_WORKFLOW dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.ARP_CORRECT_CC_ERRORS dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.JAI_RCV_OPM_COSTING_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PA_HR_UPDATE_API dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.HR_NL_ORG_INFO dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.HR_ORU_DEL dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.OTA_EL_ENROLL_SS dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.OTA_TPS_BUS1 dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PQH_PQIPED6_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PO_MASS_UPDATE_PO_PVT dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.ITA_SETUP_REC_VALUES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.HR_PERSON_INTERNAL dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PQP_PROFESSIONAL_BODY_FUNCTION dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PER_QH_SUMMARY_QUERY dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.AHL_APPR_SPACE_UNAVL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PQH_FR_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PER_ZA_WSP_LOOKUP dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PER_ECO_BUS dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.EDW_MTL_INVENTORY_LOC_M_SZ dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.GMO_OC_TRANS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PSP_PSPLDAWD_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.ZX_PTP_MIGRATE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PAY_ES_RULES dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PA_ASGMT_WFSTD dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1
-
APPS.PAY_US_1099R_MAG_REPORTING dependencies on HR_ALL_ORGANIZATION_UNITS
12.1.1