Search Results okc_price_att_values

Overview

OKC_PRICE_ATT_VALUES is a Contracts Core (OKC) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the concrete values of price attributes used to derive the selling price of a contract header and its associated contract lines. The table holds a pricing context, a qualifier context, and up to 100 pricing attribute values plus up to 100 qualifier attribute values, effectively serving as a flexible, key-flexfield-style repository within the Contracts pricing engine.

Physically the table resides in the OKC schema, is marked VALID, and contains 217 documented columns. Its surrogate primary key is enforced by OKC_PRICE_ATT_VALUES_PK on the ID column, and a unique index OKC_PRICE_ATT_VALUES_U1 on ID is also documented. In Data Vault modeling terms, the heuristic classification mined from the foreign key structure is a link entity: the table connects contract header and contract line records to the pricing attributes that determine their derived price, rather than acting as a standalone hub or a descriptive satellite.

Key Information Stored

Although 217 columns are documented, only a small subset is operationally significant:

ID — The surrogate primary key, enforced by OKC_PRICE_ATT_VALUES_PK and by the unique index OKC_PRICE_ATT_VALUES_U1. This is the row-level identifier.
CHR_ID — Foreign key to OKC_K_HEADERS_B, identifying the contract header whose price the attribute values serve.
CLE_ID — Foreign key to OKC_K_LINES_B, identifying the contract line whose price the attribute values serve.
PRICING_CONTEXT — The context (flexfield structure) that governs how the pricing attributes are interpreted.
PRICING_ATTRIBUTE1 through PRICING_ATTRIBUTE100 — The 100 attribute value slots that carry the actual pricing inputs used by the pricing engine.
QUALIFIER_CONTEXT — The context structure governing the qualifier attributes.
QUALIFIER_ATTRIBUTE1 through QUALIFIER_ATTRIBUTE100 — The 100 qualifier attribute value slots used to qualify pricing rules.
FLEX_TITLE — The descriptive flexfield title associated with the pricing context.
SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, governing multi-tenant/security-group data access.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns, with LAST_UPDATE_DATE typically used for incremental extracts.
PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — Concurrent program traceability columns indicating which request last touched the row.
OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/ADF layer during updates.

Common Use Cases and Queries

The primary use case is price derivation and audit: understanding which attribute values drove the price on a given contract header or line. A typical query joins the table to both master tables using the documented foreign keys:

Header-level pricing inputs: SELECT p.PRICING_CONTEXT, p.PRICING_ATTRIBUTE1, p.PRICING_ATTRIBUTE2 FROM OKC.OKC_PRICE_ATT_VALUES p WHERE p.CHR_ID = :chr_id.
Line-level pricing inputs: SELECT p.PRICING_CONTEXT, p.QUALIFIER_CONTEXT, p.PRICING_ATTRIBUTE1 FROM OKC.OKC_PRICE_ATT_VALUES p WHERE p.CLE_ID = :cle_id.
Combined header/line view: join to OKC_K_HEADERS_B on CHR_ID and OKC_K_LINES_B on CLE_ID to reconstruct the full pricing picture for a contract.
Security-scoped extracts: filter on SECURITY_GROUP_ID to isolate data by operating unit or security group.
Incremental reporting: drive ETL or report extracts off LAST_UPDATE_DATE to capture recently changed pricing attributes.

Related Objects

OKC_K_HEADERS_B — Referenced via OKC_PRICE_ATT_VALUES.CHR_ID; the contract header master.
OKC_K_LINES_B — Referenced via OKC_PRICE_ATT_VALUES.CLE_ID; the contract line master.
FND_SECURITY_GROUPS — Referenced via OKC_PRICE_ATT_VALUES.SECURITY_GROUP_ID; controls data visibility.
OKC_PRICE_ATT_VALUES_PK — Primary key constraint on ID.
OKC_PRICE_ATT_VALUES_U1 — Unique index on ID, acting as a documented business-key candidate.

Table: OKC_PRICE_ATT_VALUES 12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES, object_name:OKC_PRICE_ATT_VALUES, status:VALID, product: OKC - Contracts Core , description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. , implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES ,
Table: OKC_PRICE_ATT_VALUES 12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES, object_name:OKC_PRICE_ATT_VALUES, status:VALID, product: OKC - Contracts Core , description: Values of price attributes for an object to be used to derive the price for a contract header and contract line , implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES ,
SYNONYM: APPS.OKC_PRICE_ATT_VALUES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_PRICE_ATT_VALUES, status:VALID,
SYNONYM: APPS.OKC_PRICE_ATT_VALUES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_PRICE_ATT_VALUES, status:VALID,
PACKAGE: APPS.OKS_EXTWARPRGM_OSO_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKS_EXTWARPRGM_OSO_PVT, status:VALID,
PACKAGE: APPS.OKS_EXTWARPRGM_OSO_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKS_EXTWARPRGM_OSO_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_SPLIT2_PAV_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_SPLIT2_PAV_PVT, status:VALID,
PACKAGE: APPS.OKS_CONTRACTS_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKS_CONTRACTS_PUB, status:VALID,
PACKAGE: APPS.OKS_CONTRACTS_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKS_CONTRACTS_PUB, status:VALID,
PACKAGE BODY: APPS.OKC_SPLIT1_PAV_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_SPLIT1_PAV_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_PAV_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_PAV_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_PAV_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_PAV_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_OC_INT_PRICING_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_OC_INT_PRICING_PVT, status:VALID,
PACKAGE: APPS.OKS_EXTWARPRGM_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKS_EXTWARPRGM_PVT, status:VALID,
PACKAGE: APPS.OKS_EXTWARPRGM_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKS_EXTWARPRGM_PVT, status:VALID,
PACKAGE: APPS.OKC_PAV_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_PAV_PVT, status:VALID,
PACKAGE: APPS.OKC_PAV_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_PAV_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_OC_INT_PRICING_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_OC_INT_PRICING_PVT, status:VALID,
PACKAGE: APPS.OKS_COPY_CONTRACT_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKS_COPY_CONTRACT_PVT, status:VALID,
PACKAGE: APPS.OKS_COPY_CONTRACT_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKS_COPY_CONTRACT_PVT, status:VALID,
APPS.OKC_PAV_PVT SQL Statements 12.2.2
Table: OKC_K_HEADERS_B 12.2.2
product: OKC - Contracts Core , description: Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract. , implementation_dba_data: Not implemented in this database ,
Table: OKC_K_HEADERS_B 12.1.1
product: OKC - Contracts Core , description: Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract. , implementation_dba_data: Not implemented in this database ,
VIEW: OKC.OKC_PRICE_ATT_VALUES# 12.2.2
owner:OKC, object_type:VIEW, object_name:OKC_PRICE_ATT_VALUES#, status:VALID,
Table: OKC_K_LINES_B 12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_K_LINES_B, object_name:OKC_K_LINES_B, status:VALID, product: OKC - Contracts Core , description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. , implementation_dba_data: OKC.OKC_K_LINES_B ,
Table: OKC_K_LINES_B 12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_K_LINES_B, object_name:OKC_K_LINES_B, status:VALID, product: OKC - Contracts Core , description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. , implementation_dba_data: OKC.OKC_K_LINES_B ,
PACKAGE BODY: APPS.OKC_VERSION_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_VERSION_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_VERSION_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_VERSION_PVT, status:VALID,
View: OKC_PRICE_ATT_VALUES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_V, object_name:OKC_PRICE_ATT_VALUES_V, status:VALID, product: OKC - Contracts Core , description: View for table OKC_PRICE_ATT_VALUES , implementation_dba_data: APPS.OKC_PRICE_ATT_VALUES_V ,
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.OKS_RENCPY_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKS_RENCPY_PVT, status:VALID,
View: OKC_PRICE_ATT_VALUES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_V, object_name:OKC_PRICE_ATT_VALUES_V, status:VALID, product: OKC - Contracts Core , description: View for table OKC_PRICE_ATT_VALUES , implementation_dba_data: APPS.OKC_PRICE_ATT_VALUES_V ,
APPS.OKC_PAV_PVT SQL Statements 12.1.1
PACKAGE BODY: APPS.OKS_RENCPY_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKS_RENCPY_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.OKS_COPY_CONTRACT_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKS_COPY_CONTRACT_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
12.1.1 DBA Data 12.1.1
VIEW: APPS.OKC_PRICE_ATT_VALUES_V 12.2.2
VIEW: APPS.OKC_PRICE_ATT_VALUES_V 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.OKS_COPY_CONTRACT_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKS_COPY_CONTRACT_PVT, status:VALID,
VIEW: OKC.OKC_PRICE_ATT_VALUES# 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
APPS.OKC_SPLIT1_PAV_PVT SQL Statements 12.2.2
APPS.OKC_SPLIT2_PAV_PVT SQL Statements 12.2.2