Search Results cd_name

Overview

FND_CONFLICTS_DOMAIN is a core Configuration table owned by the APPLSYS schema within the FND — Application Object Library product of Oracle E-Business Suite. It stores the Conflict Resolution Manager (CRM) conflict domain definitions used by the Concurrent Manager subsystem to govern how concurrent programs may execute against one another. Each row defines a named domain that determines whether a given concurrent request may run in parallel with other requests, or whether it must run in isolation. This mechanism is central to protecting shared resources — such as a general ledger period, an inventory organization, or a payroll run — from concurrent, conflicting access.

From a dimensional modeling perspective, the ETRM metadata classifies this object as satellite-leaning based on its foreign key structure. That is a heuristic suggestion rather than a definitive categorization: the table carries descriptive business attributes (domain name, run-alone flag, dynamic flag) alongside audit columns, which is typical of a satellite or reference/lookup dimension extending core entities.

Key Information Stored

The documented physical schema contains 11 columns. The most significant are:

• CD_ID — The surrogate primary key (FND_CONFLICTS_DOMAIN_PK), a system-generated identifier uniquely keying each conflict domain row. It is also exposed as a unique index (FND_CONFLICTS_DOMAIN_U1).
• CD_NAME — The business-key name of the conflict domain, carried by unique index FND_CONFLICTS_DOMAIN_U2. This is the value referenced in concurrent program definitions and conflict definitions.
• USER_CD_NAME — A user-facing or translated label for the domain, often surfaced in administrative and diagnostics screens.
• RUNALONE_FLAG — Indicates whether programs assigned to this domain must run alone, preventing any concurrent overlap with other requests in the same domain. This is the operative control attribute.
• DYNAMIC — Flags the domain as dynamically evaluated, meaning membership or conflict behavior is resolved at runtime rather than statically.
• DESCRIPTION — Free-text explanation of the domain's purpose, aiding administrators in maintenance.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns, with the _BY and LOGIN columns carrying foreign keys to FND_USER and FND_LOGINS respectively.

Common Use Cases and Queries

Administrators and DBA/technical consultants query this table to understand CRM configuration, troubleshoot why a concurrent request is waiting, or audit conflict domain setup. A typical lookup of run-alone domains is:

• SELECT cd_id, cd_name, user_cd_name, runalone_flag, dynamic FROM applsys.fnd_conflicts_domain WHERE runalone_flag = 'Y';
• Joining to FND_CONCURRENT_REQUESTS on CD_ID to identify which requests are associated with each domain and diagnose serialization of the concurrent queue.
• Comparing the CRM domain definition with conflict definitions maintained by the Conflict Resolution Manager to validate that business-critical programs are protected from overlap.

Reporting scenarios include periodic reviews of dynamic domains, inventory of run-alone domains across environments, and impact analysis before modifying a domain that affects high-volume concurrent programs.

Related Objects

• FND_CONCURRENT_REQUESTS — References this table via CD_ID. This is the principal dependent object and the primary join path for operational and diagnostic queries.
• FND_USER — Referenced by CREATED_BY and LAST_UPDATED_BY for audit attribution.
• FND_LOGINS — Referenced by LAST_UPDATE_LOGIN to identify the login session responsible for the last change.
• FND_CONFLICTS_DOMAIN_PK / U1 / U2 — The enforcing primary key and unique indexes on CD_ID and CD_NAME.
• Conflict Resolution Manager (CRM) — The Concurrent Manager component that consumes these definitions at runtime to serialize conflicting requests.

Together these relationships establish FND_CONFLICTS_DOMAIN as the authoritative reference for concurrent conflict domain configuration in Oracle EBS releases 12.1.1 and 12.2.2.