Search Results aso_sup_instance_value_pk

Overview

ASO_SUP_INSTANCE_VALUE is a transactional table in the ASO - Order Capture module of Oracle E-Business Suite (validated in 12.1.1 and 12.2.2). Its documented purpose is to store the instance value of the template. In practical terms, it captures the individual data values entered or generated for fields (section components) on a specific instantiation of an order capture template. Each row associates a stored value with a template instance and a section component mapping, forming the leaf-level detail of the template-driven order capture model.

The ETRM metadata assigns this object a heuristic Data Vault classification of standalone, meaning the mined foreign-key structure does not present it as a classic hub, link, or satellite. From a modeling perspective, it is best treated as a detail or value-satellite table: its grain is one row per template instance value, keyed by INSTANCE_VALUE_ID, with the parent relationships acting as the descriptive dimensions.

Key Information Stored

The table contains 36 documented columns. The most significant are:

• INSTANCE_VALUE_ID — surrogate primary key, enforced by ASO_SUP_INSTANCE_VALUE_PK and the unique index ASO_SUP_INSTANCE_VALUE_U1. This is the documented business-key candidate for the table.
• TEMPLATE_INSTANCE_ID — foreign key to ASO_SUP_TMPL_INSTANCE, identifying the specific template instance to which the value belongs.
• SECT_COMP_MAP_ID — foreign key to ASO_SUP_SECT_COMP_MAP, identifying the section/component mapping that defines the field being valued.
• VALUE — the captured value itself for the mapped component.
• VALUE_TYPE_QUALIFIER — qualifier describing the semantics or type of the stored value.
• RESPONSE_ID — reference linking the value to the originating response or interaction.
• RTFDATA — rich-text form data associated with the value.
• FILE_ID — reference to an associated file, where the value is document-backed.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling multi-tenant/security-group visibility.
• OBJECT_VERSION_NUMBER — optimistic locking column used for concurrent update control.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit (WHO) columns.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive flexfield (DFF) columns, providing extensibility for customer-specific data.

Common Use Cases and Queries

Typical usage involves reconstructing the captured values for a template instance, joining to the section/component mapping to obtain field labels:

• Retrieve all values for a given template instance:

  SELECT v.INSTANCE_VALUE_ID, v.SECT_COMP_MAP_ID, v.VALUE, v.VALUE_TYPE_QUALIFIER
  FROM   ASO.ASO_SUP_INSTANCE_VALUE v
  WHERE  v.TEMPLATE_INSTANCE_ID = :instance_id;

• Join to the component map to resolve the field definition:

  SELECT v.VALUE, m.*
  FROM   ASO.ASO_SUP_INSTANCE_VALUE v,
         ASO.ASO_SUP_SECT_COMP_MAP m
  WHERE  v.SECT_COMP_MAP_ID = m.SECT_COMP_MAP_ID
  AND    v.TEMPLATE_INSTANCE_ID = :instance_id;

• Audit/reporting extracts filtered by security group, or by creation/update dates for change tracking.
• DFF-driven reporting using CONTEXT and ATTRIBUTE1–20 for customer extensions.

Related Objects

• ASO_SUP_TMPL_INSTANCE — joined via TEMPLATE_INSTANCE_ID; the parent template instance.
• ASO_SUP_SECT_COMP_MAP — joined via SECT_COMP_MAP_ID; defines the section/component being valued.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; governs row-level security grouping.
• ASO_SUP_INSTANCE_VALUE_PK / ASO_SUP_INSTANCE_VALUE_U1 — primary key constraint and unique index on INSTANCE_VALUE_ID.
• Order Capture (ASO) template and section/component configuration tables — the broader ASO template framework that supplies TEMPLATE_INSTANCE_ID and SECT_COMP_MAP_ID context.
• ASO Order Capture APIs — the public application interfaces that populate and read instance values during order capture processing.