Search Results working_hours




Overview
Explore in AI Chat

Overview

APPS.ICX_PER_ORGANIZATION_UNITS_V is a reporting view in Oracle E-Business Suite that exposes organization unit definitions maintained in Oracle HRMS for use by procurement, iProcurement, and other ICX-family applications. The view is a thin projection of the underlying PER_ORGANIZATION_UNITS view and preserves the full column list without filtering or transformation, which means every column present in the base object is available to consuming reports, concurrent programs, and integrations.

The view is registered under the APPS schema and is documented as part of the ETRM reference set for both Oracle EBS 12.1.1 and 12.2.2. Its principal role is to provide a stable application-facing interface for organizational unit data — including inventory organizations, business groups, and internal units — so that downstream modules do not need to query the HRMS schema objects directly. Because it mirrors the base object, any row visible through ICX_PER_ORGANIZATION_UNITS_V is governed by the row-level security rules applied by the base object rather than by the view itself.

Underlying Base Objects

According to the documented ETRM metadata, the view is defined over the following objects:

  • PER_ORGANIZATION_UNITS (VIEW) — the direct source object. All sixteen exposed columns are selected from this view with no expressions, joins, or WHERE clause applied in the defining SQL.
  • HR_SECURITY (PACKAGE) — supplies the security profile logic that constrains which rows a given responsibility or user may see when querying the underlying HRMS data.
  • HR_GENERAL (PACKAGE) — provides supporting HRMS utility functions used by the organization unit access path.

Because ICX_PER_ORGANIZATION_UNITS_V selects directly from PER_ORGANIZATION_UNITS, it inherits that object's structure and its dependence on the HR_SECURITY and HR_GENERAL packages. Practically, this means the view returns the same row set as the base view would for the same session and security context, and it should not be treated as an independent data source.

Key Columns

  • ORGANIZATION_ID — primary identifier of the organization unit; the principal join key to HR_ALL_ORGANIZATION_UNITS and related HRMS tables.
  • BUSINESS_GROUP_ID — the business group to which the unit belongs; used to scope queries to a legal employer or enterprise.
  • NAME — the display name of the organization unit.
  • DATE_FROM / DATE_TO — effective date range governing when the unit definition is active.
  • INTERNAL_ADDRESS_LINE / LOCATION_ID — physical or internal location reference for the unit.
  • DEFAULT_START_TIME / DEFAULT_END_TIME — the default working start and end times for the unit. These are the columns most commonly sought by users searching for “default_start_time,” since the same field name appears on this view and on the base PER_ORGANIZATION_UNITS view.
  • WORKING_HOURS / FREQUENCY — the unit's standard working hours and recurrence frequency.
  • INTERNAL_EXTERNAL_FLAG / TYPE — classification of the unit as internal or external and its type.
  • COMMENTS — free-text notes attached to the unit.
  • COST_ALLOCATION_KEYFLEX_ID / SOFT_CODING_KEYFLEX_ID — key flexfield identifiers used for cost allocation and soft coding defaults.

Common Use Cases and Queries

Typical uses include validating organization unit configuration during iProcurement setup, defaulting working hours for requisition and receiving processes, and extracting organization metadata into downstream warehouses or integrations.

SELECT organization_id,
       business_group_id,
       name,
       default_start_time,
       default_end_time,
       working_hours,
       frequency
  FROM apps.icx_per_organization_units_v
 WHERE business_group_id = :p_business_group_id
   AND SYSDATE BETWEEN NVL(date_from, SYSDATE)
                   AND NVL(date_to, SYSDATE + 1);

A second common pattern retrieves the default start and end times for a single organization, for example when seeding a timekeeping or scheduling interface:

SELECT organization_id, name, default_start_time, default_end_time
  FROM apps.icx_per_organization_units_v
 WHERE organization_id = :p_org_id;

Because the view applies no filter of its own, results are always subject to HR_SECURITY. Queries should therefore be run under a responsibility whose security profile grants access to the intended business group, and callers should expect the row set to vary with session context.