| layout | default |
|---|---|
| title | HR Organization Upload | Oracle EBS SQL Report |
| description | Upload to create and update organizations, organization classifications, and organization information types within Oracle HRMS. Scope: - Create new… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Upload, Organization, hr_all_organization_units, hr_all_organization_units_tl, per_business_groups |
| permalink | /HR%20Organization%20Upload/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Upload to create and update organizations, organization classifications, and organization information types within Oracle HRMS.
Scope:
- Create new organizations, assign classifications and information types, and specify the information type attributes
- Update existing organization data, classifications (enable/disable), and the information type attributes
- Supports all organization classification types: Business Groups (excluding creation of new Business Groups), HR Organization, Operating Unit, GRE/Legal Entity, Company Cost Center, Inventory Organization, etc.
- Supports creation/update of single-row (GS) and multi-row (GM) organization information types and their attributes (org_information1..20) with dynamic LOVs and segment labels
- Supports creation/update of the Cost Allocation Key Flexfield segments against the HR Organization Classification (ORGANIZATION qualified segments only)
Constraints:
- Organizations can only be created/updated within the Business Group associated with the current responsibility
- Business Group creation is not supported - use the Define Organizations form
- The following organization information types cannot be updated via the API once created: Business Group Information, Canada Employer Identification. These can be created but not subsequently modified by this upload
- Only supports the creation and update of the single-row DFF and multi-row DFF information types.
- Organization information segments that reference self-referencing data may require a two-step upload: first create the info type, then update the self-referencing attribute in a second pass
Upload Mode, Business Group, Organization Type, Organization Name, Location, Organization Status, Classification, Classification Status, Information Type
hr_all_organization_units, hr_all_organization_units_tl, per_business_groups, hr_locations_all, pay_cost_allocation_keyflex, hr_organization_information, hr_org_info_types_by_class, hr_org_information_types, hr_org_information_types_tl, fnd_descr_flex_contexts
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | HR_Organization_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/hr-organization-upload/ |
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics