Search Results jtf_hz_organization_profiles_v




Overview
Explore in AI Chat

Overview

JTF_HZ_ORGANIZATION_PROFILES_V is an APPS-owned view within the JTF – CRM Foundation product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes organization profile information, presenting attributes of organizations as parties in the TCA (Trading Community Architecture) model. The view retrieves information about people as contacts for organizations, including context-specific details such as job title or rank held by a contact within a given organization. Because it is a view rather than a base table, it is intended primarily for reporting and integration consumption rather than direct maintenance; DML against the underlying organization profile data is normally performed through the base table or supported APIs.

The object carries VALID status in the ETRM metadata, confirming that its definition compiles successfully against the documented base objects. Its role in EBS reporting and integration is to provide a stable, query-friendly projection of organization profile attributes that can be joined to other TCA and CRM entities by PARTY_ID or ORGANIZATION_PROFILE_ID.

Underlying Base Objects

The documented reference for this view is the base object HZ_ORGANIZATION_PROFILES, exposed through a synonym. HZ_ORGANIZATION_PROFILES is the TCA table that stores organization-level profile data, including firmographics, financial and credit indicators, DUNS information, and extensive descriptive flexfield (DFF) and global DFF columns. JTF_HZ_ORGANIZATION_PROFILES_V is a passthrough-style view defined over this foundation, including the ROWID pseudo-column so that consumers can address the underlying row where privileges permit.

Because the view reflects the organization profile structure directly, its columns mirror those of HZ_ORGANIZATION_PROFILES, including the full ATTRIBUTE1 through ATTRIBUTE20 and GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20 descriptor columns. Changes committed to the base table are immediately visible through the view, since no materialization or aggregation is involved.

Key Columns

Common Use Cases and Queries

Typical uses include organization profile lookups in CRM and TCA reporting, fuzzy name matching via the phonetic column, and enrichment joins against contacts and accounts. A direct query returning the profile identified by an organization name phonetic value is shown below.

  • SELECT organization_profile_id, party_id, organization_name, organization_name_phonetic, duns_number, credit_score FROM jtf_hz_organization_profiles_v WHERE organization_name_phonetic = :search_value;
  • SELECT p.organization_name, p.employees_total, p.year_established, p.sic_code FROM jtf_hz_organization_profiles_v p WHERE p.party_id = :party_id;
  • SELECT organization_name, duns_number, paydex_score FROM jtf_hz_organization_profiles_v WHERE duns_number = :duns;
  • SELECT organization_name, best_time_contact_begin, best_time_contact_end FROM jtf_hz_organization_profiles_v WHERE best_time_contact_begin IS NOT NULL;
  • SELECT organization_profile_id, attribute1, attribute2 FROM jtf_hz_organization_profiles_v WHERE global_attribute_category = :category;

These queries are read-only and rely exclusively on the documented base object and columns exposed by the view.