Search Results db_rating




Overview
Explore in AI Chat

Overview

APPS.AMS_ORG_PROFILES_V is an Oracle E-Business Suite (EBS) read-only view owned by the APPS schema. It exposes organization profile information used by Oracle Advanced Marketing (AMS) and related modules that rely on customer and prospect intelligence data. The view presents a denormalized projection of organization-level attributes—demographic, financial, credit, and diversity classification data—originally sourced from the Trading Community Architecture (TCA) model.

In EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration surface for marketing, credit, and business-classification processes. Its columns support firmographic profiling, such as minority-owned and woman-owned designations, credit scores, Paydex scores, employee headcount, and D-U-N-S-derived attributes (for example, GLOBAL_ATTRIBUTE columns and DISADV_8A_IND). The view is frequently queried by marketing segmentation, lead qualification, and third-party data-enrichment routines.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, APPS.AMS_ORG_PROFILES_V is defined over a single referenced base object: HZ_ORGANIZATION_PROFILES, accessed via a synonym. HZ_ORGANIZATION_PROFILES is the primary TCA table that stores organization profile records, including financial standing, classification, and 20 seed attribute columns plus a 20-column GLOBAL attribute set. The view selects from this table and renames the key identifier column: ORGANIZATION_PROFILE_ID is aliased to AMS_ORG_PROFILE_ID, aligning the naming convention with the AMS module. Because it is a simple projection view with no aggregations or joins beyond the synonym, it inherits the row-level security and access characteristics of the underlying base table.

Key Columns

Common Use Cases and Queries

Typical uses include identifying 8(a) or minority-/woman-owned suppliers, filtering prospects by credit or Paydex score, and exporting firmographic data for campaign targeting. A representative query returns disadvantaged-business organizations with their credit standing:

  • SELECT AMS_ORG_PROFILE_ID, ORGANIZATION_NAME, PARTY_ID, DISADV_8A_IND, SMALL_BUS_IND, CREDIT_SCORE FROM APPS.AMS_ORG_PROFILES_V WHERE DISADV_8A_IND = 'Y';
  • SELECT ORGANIZATION_NAME, PAYDEX_SCORE, FAILURE_SCORE FROM APPS.AMS_ORG_PROFILES_V WHERE PAYDEX_SCORE IS NOT NULL ORDER BY PAYDEX_SCORE DESC;
  • SELECT PARTY_ID, EMPLOYEES_TOTAL, YEAR_ESTABLISHED FROM APPS.AMS_ORG_PROFILES_V WHERE SMALL_BUS_IND = 'Y';

Because the view is a direct projection of HZ_ORGANIZATION_PROFILES, query performance is governed by indexes on the base table; the PARTY_ID and primary key columns are the most efficient filter and join predicates.