Results for “xns_cp_fes”

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

Overview

XNS_CP_FES is a fulfillment element assignment table within the Oracle E-Business Suite XNS (Service for Communications) module. It records the association between customer products and their fulfillment elements, providing the data foundation that links a provisioned product instance to the individual fulfillment elements that comprise or support it. Conceptually, XNS_CP_FES answers the question: "which fulfillment elements are attached to this customer product?"

The ETRM metadata classifies this object as Not implemented in this database, and the XNS product is flagged as obsolete. In Oracle EBS 12.1.1 and 12.2.2 environments, the table may exist as a dormant or legacy artifact, so implementations should verify its presence and row counts before designing dependencies on it. Where present, it functions as a pure intersection or association table.

Using a Data Vault modeling heuristic derived from the foreign key structure, XNS_CP_FES suggests a link classification. It carries no independent descriptive attributes beyond its own surrogate key; its purpose is to resolve a many-to-many relationship between two hubs — CSI_ITEM_INSTANCES (customer product) and XDP_FES (fulfillment element definitions).

Key Information Stored

The table's documented structure is intentionally narrow, reflecting its role as a relationship holder rather than an attribute-rich entity. The most significant columns are:

• CP_FE_ID — The surrogate primary key, defined by the constraint XNS_CP_FES_PK. It uniquely identifies each fulfillment element assignment row and is the column the user searched for under the index name xns_cp_fes_pk. This is a system-generated identifier, not a business key.
• CUSTOMER_PRODUCT_ID — Foreign key to CSI_ITEM_INSTANCES. Identifies the specific customer product instance on which the fulfillment element is defined. This is the dominant business-key candidate, since fulfillments are scoped to a product instance.
• FE_ID — Foreign key to XDP_FES. Identifies the fulfillment element definition being assigned to the customer product. Together with CUSTOMER_PRODUCT_ID, this column forms the logical unique business key of the relationship.

No additional attribute columns are documented in the ETRM record. Implementers should not assume the existence of date, status, or quantity columns without verifying against the physical dictionary (ALL_TAB_COLUMNS).

Common Use Cases and Queries

Practical use of XNS_CP_FES centers on resolving fulfillment element configuration for a given customer product and auditing referral integrity between installed base and fulfillment definitions.

• Fulfillment element lookup for a customer product:
  SELECT f.cp_fe_id, f.customer_product_id, f.fe_id
FROM xns_cp_fes f
WHERE f.customer_product_id = :p_customer_product_id;
• Enumerating fulfillments with their definitions:
  SELECT f.customer_product_id, d.fe_id, d.*
FROM xns_cp_fes f, xdp_fes d
WHERE f.fe_id = d.fe_id;
• Installed-base reconciliation: joining XNS_CP_FES to CSI_ITEM_INSTANCES to identify products with or without assigned fulfillment elements, useful for provisioning audits and migration validation.
• Orphan detection: left-outer joins from each parent table to XNS_CP_FES to detect fulfillment assignments referencing deleted or missing definitions, a common data-quality check during upgrades to 12.2.2.

Because the XNS module is obsolete, these queries are primarily relevant to legacy data migration, archival reporting, or clean-up initiatives rather than ongoing transactional processing.

Related Objects

The following objects are the most significant relative to XNS_CP_FES, based on the documented foreign key relationships:

• CSI_ITEM_INSTANCES — Parent of the CUSTOMER_PRODUCT_ID foreign key. Represents the installed base item instance and is referenced by XNS_CP_FES.CUSTOMER_PRODUCT_ID.
• XDP_FES — Parent of the FE_ID foreign key. Holds fulfillment element definitions and is referenced by XNS_CP_FES.FE_ID.
• XNS_CP_FES_PK — The primary key constraint/index (on CP_FE_ID) targeted by the user's search term.
• Sibling XNS customer-product tables (for example, related XNS_CP_* association tables) that share the CSI_ITEM_INSTANCES parent and collectively describe full product configuration.
• CSI-related inquiry and concurrent programs that read installed base structures, which may implicitly traverse this table in legacy deployments.

Given the obsolete classification, downstream dependencies are expected to be minimal, and the table is best treated as a historical link entity supporting fulfillment element attribution on customer products.