Search Results csi_i_pricing_attribs




Overview
Explore in AI Chat

Overview

CSI_I_PRICING_ATTRIBS, owned by the CSI schema, is the Install Base (CSI) table that stores Instance Pricing Attributes. In Oracle E-Business Suite 12.1.1 and 12.2.2, it records the pricing-relevant descriptive attribute values captured against a customer product instance (an installed asset) maintained in Oracle Install Base. These attribute values are used by Oracle Advanced Pricing, Order Management, and Service Contracts to qualify a given instance for pricing context, modifier treatment, or promotional eligibility.

Each row is anchored to a specific instance in CSI_ITEM_INSTANCES via INSTANCE_ID, so the table functions as a descriptive extension of the instance record. The physical schema documents 129 columns, dominated by 100 generic PRICING_ATTRIBUTE1 through PRICING_ATTRIBUTE100 slots plus a 15-column DFF-style ATTRIBUTE1–15 block and a CONTEXT column. This flexible-column design is characteristic of Oracle's descriptive-flexfield pattern, where the authoritative meaning of each slot is defined by configuration in the pricing setup rather than by column name.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification: PRICING_ATTRIBUTE_ID is the surrogate primary key, INSTANCE_ID is the parent-instance foreign key, and the descriptive payload (pricing attribute values, context, dates, audit columns) is dependent on the parent rather than being a business entity in its own right. This is offered as a modeling suggestion only; the table is a conventional 3NF EBS child table.

Key Information Stored

The most operationally significant columns are:

  • PRICING_ATTRIBUTE_ID — surrogate primary key (CSI_I_PRICING_ATTRIBS_PK) and also the target of unique index U01; the internally generated identifier for each pricing-attribute row.
  • INSTANCE_ID — foreign key to CSI_ITEM_INSTANCES. Identifies the installed instance to which the pricing attributes belong.
  • ACTIVE_START_DATE and ACTIVE_END_DATE — effective-dating window controlling which attribute row is valid at a point in time.
  • PRICING_CONTEXT — together with INSTANCE_ID, forms unique index U02 (CSI_I_PRICING_ATTRIBS_U02), acting as the business-key candidate that identifies the distinct pricing context per instance.
  • PRICING_ATTRIBUTE1 … PRICING_ATTRIBUTE100 — the generic pricing attribute value slots whose meaning is defined by pricing setup for the applicable context.
  • CONTEXT and ATTRIBUTE1 … ATTRIBUTE15 — the descriptive flexfield context and segment columns used for additional instance-level descriptive data.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — standard audit, concurrency, and optimistic-locking columns maintained by the EBS framework.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, used in a multi-organization/security-group partitioned data model.
  • MIGRATED_FLAG — indicates rows migrated from a legacy source during upgrade or data conversion.

Common Use Cases and Queries

Typical uses include: reporting on pricing attributes held against a customer's installed asset; qualifying service contract lines or order lines by instance pricing context; and auditing the effective-dated history of attribute values for a given instance.

Retrieving current attributes for a specific instance:

  • SELECT p.PRICING_ATTRIBUTE_ID, p.PRICING_CONTEXT, p.PRICING_ATTRIBUTE1, p.ACTIVE_START_DATE, p.ACTIVE_END_DATE FROM CSI.CSI_I_PRICING_ATTRIBS p WHERE p.INSTANCE_ID = :instance_id AND TRUNC(SYSDATE) BETWEEN p.ACTIVE_START_DATE AND NVL(p.ACTIVE_END_DATE, SYSDATE);

Joining to the installed instance and the owning item:

  • SELECT i.INSTANCE_ID, i.INSTANCE_NUMBER, p.PRICING_CONTEXT, p.PRICING_ATTRIBUTE1 FROM CSI.CSI_I_PRICING_ATTRIBS p, CSI.CSI_ITEM_INSTANCES i WHERE p.INSTANCE_ID = i.INSTANCE_ID;

Because the pricing attribute slots are generic, reporting queries generally join to pricing setup or flexfield definitions to resolve the display name of each populated slot. The secondary unique index on (INSTANCE_ID, PRICING_CONTEXT) is useful for upsert patterns and for confirming that only one active row exists per instance and context.

Related Objects

The most significant related objects are:

  • CSI_ITEM_INSTANCES — parent of the FK CSI_I_PRICING_ATTRIBS.INSTANCE_ID to CSI_ITEM_INSTANCES.INSTANCE_ID; the installed-asset header record.
  • CSI_I_PRICING_ATTRIBS_H — the history (or _H) table, related through the FK CSI_I_PRICING_ATTRIBS_H.PRICING_ATTRIBUTE_ID referencing CSI_I_PRICING_ATTRIBS.PRICING_ATTRIBUTE_ID.
  • FND_SECURITY_GROUPS — referenced by CSI_I_PRICING_ATTRIBS.SECURITY_GROUP_ID.
  • CSI_I_PRICING_ATTRIBS_PK / U01 / U02 — the primary key and unique indexes that enforce identity on PRICING_ATTRIBUTE_ID and the (INSTANCE_ID, PRICING_CONTEXT) business key.
  • CSI_ITEM_INSTANCES dependent applications (Oracle Advanced Pricing, Order Management, Service Contracts) that consume instance pricing attributes for qualification and modifier logic.