Search Results hri_cl_org_cc_v




Overview
Explore in AI Chat

Overview

HRI_CL_ORG_CC_V is a read-only database view belonging to the HRI – Human Resources Intelligence product family within Oracle E-Business Suite. In the ETRM metadata for releases 12.1.1 and 12.2.2, the object is explicitly flagged as Obsolete and is documented as "Not implemented in this database." This notation indicates that the view is not created or shipped in the standard Oracle EBS schema; it persists only as legacy documentation from earlier releases where Human Resources Intelligence provided analytical and reporting constructs over HR organization data.

The view's purpose was to expose organization-level company and cost center attributes in a denormalized, reporting-friendly form. It flattens the pipe-delimited ORG_INFORMATION1 flexfield segment stored in HR_ORGANIZATION_INFORMATION into discrete COMPANY and COST_CENTER columns, keyed by organization and effective-dated using START_DATE and END_DATE. Because the object is obsolete and absent from the database, it cannot be queried directly in a current 12.1.1 or 12.2.2 instance; organizations requiring equivalent output must reproduce the logic against the underlying HR tables.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the embedded view text establishes the three source tables on which HRI_CL_ORG_CC_V depends:

  • HR_ORGANIZATION_INFORMATION (aliased OINF) — the key flexfield storage for organization information. The view restricts this table to rows where ORG_INFORMATION_CONTEXT = 'COMPANY COST CENTER', supplying the source value ORG_INFORMATION1 from which the company and cost center segments are parsed.
  • HR_ALL_ORGANIZATION_UNITS (aliased ORG) — the base organization definition, providing ORGANIZATION_ID, DATE_FROM, and DATE_TO.
  • HR_ALL_ORGANIZATION_UNITS_TL (aliased ORGT) — the translatable organization name table, joined on ORGANIZATION_ID and filtered by ORGT.LANGUAGE = USERENV('LANG') to return the name in the session language.

All three are joined on ORGANIZATION_ID. The view also invokes HR_GENERAL.END_OF_TIME to substitute a high date where DATE_TO is null, and the entire statement is declared WITH READ ONLY.

Key Columns

  • ID — the ORGANIZATION_ID of the organization unit.
  • VALUE — the organization name from the translated name table, current for the user's language.
  • START_DATE — the organization's effective start date (DATE_FROM).
  • END_DATE — the effective end date, defaulted to HR_GENERAL.END_OF_TIME when DATE_TO is null.
  • SEGMENTS — the raw pipe-delimited value of ORG_INFORMATION1.
  • COMPANY — the segment between the first and second pipe characters, derived via INSTR/SUBSTR parsing.
  • COST_CENTER — the remainder of the string following the third pipe character.

Common Use Cases and Queries

The original use case was HR reporting and integration in which downstream consumers needed a single row per organization exposing company and cost center in separate columns rather than as a concatenated key flexfield. Because the view is obsolete and unimplemented, it should not be referenced in new development. Where equivalent output is required, the query can be reproduced directly against the base tables, as shown below.

  • Cost center allocation and organization hierarchy reporting in HR analytics.
  • Feeding company/cost center attributes into general ledger or payroll reconciliation extracts.
  • Effective-dated organization reference queries for point-in-time reporting.

A functionally equivalent query against the documented base tables is:

SELECT org.organization_id id, orgt.name value, org.date_from start_date, NVL(org.date_to, hr_general.end_of_time) end_date, oinf.org_information1 segments, SUBSTR(oinf.org_information1, INSTR(oinf.org_information1,'|',1,1)+1, INSTR(oinf.org_information1,'|',1,2) - (INSTR(oinf.org_information1,'|',1,1)+1)) company, SUBSTR(oinf.org_information1, INSTR(oinf.org_information1,'|',1,3)+1) cost_center FROM hr_organization_information oinf, hr_all_organization_units org, hr_all_organization_units_tl orgt WHERE oinf.org_information_context = 'COMPANY COST CENTER' AND org.organization_id = oinf.organization_id AND org.organization_id = orgt.organization_id AND orgt.language = USERENV('LANG');

Because the metadata records no implementation in 12.1.1 or 12.2.2, any dependency on HRI_CL_ORG_CC_V inherited from legacy customizations must be remediated by rewriting to the query above or to a supported replacement object.