Search Results ams_org_profiles_v




Overview
Explore in AI Chat

Overview

AMS_ORG_PROFILES_V is a public (APPS-owned, VALID) database view in the Oracle E-Business Suite Marketing (AMS) product family. As documented in the ETRM reference for release 12.2.2, it returns an organization profile for an organization and is used specifically for list generation within Oracle Marketing. In EBS terminology, a "list" is a named collection of customers, prospects, or contacts against which marketing campaigns, telemarketing efforts, and collateral fulfillment are executed. Because list generation requires a stable, denormalized projection of organization-level profile data, AMS provides this view as a read-only, consumer-facing interface rather than requiring callers to query the underlying marketing and trading community tables directly.

The view therefore serves two related roles: it abstracts the physical storage of organization profile attributes behind a public API-like object, and it exposes a consistent column set that Oracle Marketing's list-building concurrent programs and internal queries can rely upon across patch levels and releases.

Underlying Base Objects

Per the documented view metadata, AMS_ORG_PROFILES_V is defined over HZ_ORGANIZATION_PROFILES, referenced through a synonym in the APPS schema. HZ_ORGANIZATION_PROFILES is a core Trading Community Architecture (TCA) table that stores organization-level profile information such as legal status, employee counts, credit and failure scores, firmographics, and up to twenty descriptive (ATTRIBUTE) and twenty global (GLOBAL_ATTRIBUTE) flexfield segments. The view inherits this column set and, in the ETRM excerpt, is shown selecting those columns with the primary identifier aliased from ORGANIZATION_PROFILE_ID to AMS_ORG_PROFILE_ID, along with PARTY_ID and ORGANIZATION_NAME. In practice the view may be defined with one or more joins to the HZ_PARTIES / HZ_ORGANIZATIONS entities to surface ORGANIZATION_NAME and party linkage, but the ETRM documentation confirms HZ_ORGANIZATION_PROFILES as the base object of record for this view.

Key Columns

Common Use Cases and Queries

The principal use case is Oracle Marketing list generation: selecting organizations that satisfy segmentation criteria and presenting them as the membership of a campaign list. Typical SQL is straightforward, for example joining the view to HZ_ORGANIZATION_PROFILES on the aliased key or filtering by firmographic and score attributes.

SELECT AMS_ORG_PROFILE_ID, PARTY_ID, ORGANIZATION_NAME,
       LEGAL_STATUS, EMPLOYEES_TOTAL, DB_RATING
  FROM APPS.AMS_ORG_PROFILES_V
 WHERE INTERNAL_FLAG = 'N'
   AND EMPLOYEES_TOTAL > 100;

Because the view is read-only and holds no data of its own, it can also be used in reporting extracts, prospect list deduplication, and integration feeds that need a flattened organization profile without navigating the full TCA model. Queries against it execute directly against the base HZ_ORGANIZATION_PROFILES data, so standard performance tuning and indexing on that table apply.