Search Results ce_hr_bus_grps_v




Overview
Explore in AI Chat

Overview

CE_HR_BUS_GRPS_V is a reporting view owned by the APPS schema within the Cash Management (CE) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified in the ETRM repository as a "Retrofitted" object, indicating that it was carried forward or adapted to preserve backward compatibility for dependencies that reference business group data in the Human Resources organization model. The view exposes a filtered list of Human Resources business groups, restricted to organizations whose classification identifies them as HR business groups. In practice, CE_HR_BUS_GRPS_V serves as a lightweight, read-only projection over the HR organization tables, allowing Cash Management and adjacent modules to resolve business group identifiers, names, and currency codes without querying the full HR organization schema directly.

Underlying Base Objects

The view is defined over three principal HR objects. The primary source is HR_ORGANIZATION_UNITS, exposed in the APPS schema as a synonym or view, which supplies the organization identity, name, and effective dates. It is joined to HR_ORGANIZATION_INFORMATION twice: once (aliased O2) to filter on the 'CLASS' context where ORG_INFORMATION1 equals 'HR_BG' and ORG_INFORMATION2 equals 'Y', and once (aliased O3) in an outer join on the 'BUSINESS GROUP INFORMATION' context to retrieve the currency code. The documented metadata also lists HR_GENERAL and HR_SECURITY packages as referenced base objects; these are invoked through the underlying HR_ORGANIZATION_UNITS view to enforce row-level security and business group access rules. Because ORG_INFORMATION_CONTEXT is not a mandatory key for every organization, the outer join on O3 (indicated by the (+) operator) prevents the view from dropping business groups that lack an explicit currency record.

Key Columns

  • BUSINESS_GROUP_ID — The identifier of the business group organization, used throughout EBS as the partitioning key for HR and financial data.
  • ORGANIZATION_ID — The unique organization identifier of the business group unit itself.
  • NAME — The display name of the business group as defined on HR_ORGANIZATION_UNITS.
  • CURRENCY_CODE — Sourced from ORG_INFORMATION10 of the business group information context; represents the functional currency associated with the business group, which is significant for Cash Management and multi-currency processing.
  • DATE_FROM / DATE_TO — The effective date range of the organization unit, enabling date-effective filtering so that only currently valid business groups are selected.

Common Use Cases and Queries

The view is typically used to populate business group list-of-values, to drive secured reporting across Cash Management, and to validate the business group context applied to bank account and cash transaction data. A representative query selecting active business groups is shown below:

SELECT business_group_id,
       organization_id,
       name,
       currency_code,
       date_from,
       date_to
FROM   apps.ce_hr_bus_grps_v
WHERE  SYSDATE BETWEEN NVL(date_from, SYSDATE)
                   AND NVL(date_to, SYSDATE) + 0.99999
ORDER BY name;

Because the view inherits HR security through HR_ORGANIZATION_UNITS, results are automatically constrained by the operating unit and security profile of the session. Queries intended for integration or interface extraction should therefore be executed under the appropriate responsibility to ensure the expected business group rows are returned. For reconciliation or currency reporting, joining CURRENCY_CODE to GL_CURRENCIES or FND_CURRENCIES provides a natural extension of the view's documented output.