Results for “customer_profile_id”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_DUN_CUST_LETTER_SET_CUR is a table in the IGI schema (Public Sector Financials International) within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to allow entry of currency records against a parent dunning letter set. Dunning letters are used in receivables and public-sector collections processes to notify customers of overdue balances; this table associates one or more currency codes with a customer dunning profile, enabling correspondence to be generated in the appropriate currency per customer.

From a Data Vault modeling perspective, the foreign key structure (a single parent reference to IGI_DUN_CUST_PROF) suggests a satellite-leaning classification. The table extends the parent customer profile entity with additional descriptive attributes — specifically the currency dimension — rather than acting as a standalone hub or a many-to-many link between two hubs. Its primary key is composite, and its business key is also composite, which is consistent with a dependent satellite keyed on a parent business key plus a qualifying attribute (currency).

Key Information Stored

The table is documented with seven columns, two of which form the business and functional keys:

The primary key is composite (CUSTOMER_PROFILE_ID, CURRENCY_CODE); there is no separate surrogate single-column key. Note that the unique index order is inverted relative to the PK column order, but functionally the two enforce the same uniqueness constraint: one currency record per customer profile per currency.

Common Use Cases and Queries

Typical scenarios include: listing all currencies configured for a given dunning customer profile, joining to the parent profile to retrieve customer-level attributes, and joining to IGI_DUN_CUST_LETTER_SET_LINES to confirm that letter lines exist for the configured currency. The following query pattern retrieves currencies for a profile together with parent profile details:

  • SELECT c.CUSTOMER_PROFILE_ID, c.CURRENCY_CODE, p.* FROM IGI.IGI_DUN_CUST_LETTER_SET_CUR c JOIN IGI.IGI_DUN_CUST_PROF p ON p.CUSTOMER_PROFILE_ID = c.CUSTOMER_PROFILE_ID WHERE c.CUSTOMER_PROFILE_ID = :profile_id;
  • Cross-check with lines: SELECT l.CUSTOMER_PROFILE_ID, l.CURRENCY_CODE FROM IGI.IGI_DUN_CUST_LETTER_SET_LINES l WHERE l.CUSTOMER_PROFILE_ID = :profile_id AND l.CURRENCY_CODE = :currency_code;
  • Audit query: SELECT CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGI.IGI_DUN_CUST_LETTER_SET_CUR WHERE LAST_UPDATE_DATE >= :since;

Reporting use cases include reconciliation of configured dunning currencies versus issued letters, and validation that no orphan currency records exist for profiles without corresponding letter lines.

Related Objects

The most significant related objects, based on documented foreign key relationships:

  • IGI_DUN_CUST_PROF — Parent table; joined on CUSTOMER_PROFILE_ID. A record must exist here before a currency row can be inserted.
  • IGI_DUN_CUST_LETTER_SET_LINES — Child/dependent table referencing this table via CUSTOMER_PROFILE_ID and CURRENCY_CODE. These are the letter lines associated with the configured currency.
  • IGI_DUN_CUST_LETTER_SET_CUR_PK — Primary key constraint enforcing uniqueness on (CUSTOMER_PROFILE_ID, CURRENCY_CODE).
  • IGI_DUN_CUST_LET_SET_CUR_U1 — Unique index on (CURRENCY_CODE, CUSTOMER_PROFILE_ID), a business-key candidate supporting efficient reverse lookups by currency.

Because the schema is deployed in the IGI product for Public Sector Financials International, related dunning letter setup and generation objects in the same schema should be reviewed for completeness, but the tables above represent the documented dependency footprint.