Results for “csi_i_pricing_attribs_u02”

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

Overview

CSI.CSI_I_PRICING_ATTRIBS is a transactional table within the Oracle E-Business Suite (EBS) Customer Intelligence (CSI) schema. It stores instance pricing attributes — that is, the customer-defined descriptive and qualifying values attached to a specific item instance for the purpose of pricing, costing, or promotional determination. In Oracle EBS 12.1.1 and 12.2.2, this table belongs to the Applications Tablespace APPS_TS_TX_DATA and is registered in FND Design Data as CSI.CSI_I_PRICING_ATTRIBS with a status of VALID. The table is composed of a flexible attribute model in which a single pricing context governs up to one hundred numbered pricing attribute columns, allowing the CSI module to support configurable attribute sets without schema changes.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning. It carries descriptive pricing context that qualifies a parent entity (the item instance), and it is keyed by its own surrogate identifier, so it is best modeled as a satellite dependant on the CSI_ITEM_INSTANCES hub rather than as an independent hub or link.

Key Information Stored

The most significant columns of this table are:

• PRICING_ATTRIBUTE_ID (NUMBER, mandatory) — the surrogate primary key, enforced by the unique index CSI_I_PRICING_ATTRIBS_PK and the unique index CSI_I_PRICING_ATTRIBS_U01.
• INSTANCE_ID (NUMBER) — the foreign key to CSI_ITEM_INSTANCES, identifying the item instance to which the pricing attributes belong.
• PRICING_CONTEXT (VARCHAR2(30)) — the context that determines which pricing attribute columns are meaningful for the row. Together with INSTANCE_ID it forms the unique business key enforced by index CSI_I_PRICING_ATTRIBS_U02.
• PRICING_ATTRIBUTE1..PRICING_ATTRIBUTE100 (VARCHAR2(150) each) — the flexfield columns holding the actual pricing attribute values. These are interpreted according to PRICING_CONTEXT and the applicable flexfield definition.
• ACTIVE_START_DATE and ACTIVE_END_DATE (DATE) — the activation window for the pricing attribute record. ACTIVE_END_DATE is indexed by the non-unique index CSI_I_PRICING_ATTRIBS_N02, supporting date-range queries.
• CONTEXT and ATTRIBUTE1..ATTRIBUTE15 — the standard descriptive flexfield columns used for additional extensible detail.
• SECURITY_GROUP_ID (NUMBER) — foreign key to FND_SECURITY_GROUPS, enabling multi-tenant or organizational access control.
• MIGRATED_FLAG — indicates whether the row was migrated from a prior data source.
• OBJECT_VERSION_NUMBER and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — provide optimistic locking and auditability.

The documented physical schema contains 129 columns in total. The surrogate primary key is PRICING_ATTRIBUTE_ID, while the unique business-key candidate is the composite of INSTANCE_ID and PRICING_CONTEXT.

Common Use Cases and Queries

Typical usage centers on retrieving the active pricing attribute set for a given item instance and context, and on joining those attributes back to the instance for pricing and reporting.

• Retrieve the active pricing attributes for an instance and context:

SELECT instance_id, pricing_context,
       active_start_date, active_end_date,
       pricing_attribute1, pricing_attribute2
  FROM csi.csi_i_pricing_attribs
 WHERE instance_id = :p_instance_id
   AND pricing_context = :p_context
   AND TRUNC(SYSDATE) BETWEEN active_start_date
                         AND NVL(active_end_date, TRUNC(SYSDATE));

• Find all attribute rows for a set of instances:

SELECT i.instance_id,
       p.pricing_context,
       p.pricing_attribute1
  FROM csi.csi_item_instances i,
       csi.csi_i_pricing_attribs p
 WHERE i.instance_id = p.instance_id
   AND i.instance_id IN (:p_instance_list);

• Identify obsolete or expired attribute records for housekeeping, taking advantage of index CSI_I_PRICING_ATTRIBS_N02 on ACTIVE_END_DATE.
• Feed pricing and promotional engines with instance-level attribute values keyed by context.

Related Objects

• CSI.CSI_ITEM_INSTANCES — parent entity; joined on INSTANCE_ID.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for access control.
• CSI.CSI_I_PRICING_ATTRIBS_H — history table that references this table through PRICING_ATTRIBUTE_ID, capturing prior revisions.
• The pricing attribute flexfield definitions that interpret PRICING_CONTEXT and the PRICING_ATTRIBUTE columns.
• CSI public APIs and concurrent programs that maintain item instance pricing data, which read and write this table through the INSTANCE_ID and PRICING_CONTEXT business key.