Search Results std_process_id

Overview

AMW.AMW_NONSTANDARD_VARIATIONS_B is a transactional table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 AMW schema, owned by the application module responsible for process manufacturing and standard/non-standard process mapping. The table stores details of non-standard process variations, capturing the relationship between a standard process, its revision, its associated child entities, and the corresponding non-standard process, revision, and child entities. It functions as the authoritative repository for variation mappings that allow downstream process execution, costing, or compliance logic to substitute non-standard process definitions in place of their standard counterparts.

Heuristically, the metadata indicates a standalone classification under Data Vault modeling conventions. The only documented foreign key is SECURITY_GROUP_ID, which references FND_SECURITY_GROUPS and is used solely in hosted (multi-tenant) environments. Because the table does not reference other AMW process tables through declared FK constraints, it is best modeled as a standalone hub-and-satellite pattern, where VARIATION_ROW_ID serves as the hub business key and the remaining attributes behave as descriptive satellite data. This classification is a modeling suggestion derived from the absence of FK dependencies; logical relationships to process and child tables exist through the STD_PROCESS_ID, NON_STD_PROCESS_ID, STD_CHILD_ID, and NON_STD_CHILD_ID columns.

Key Information Stored

The table consists of 16 documented columns. The unique index AMW_NONSTANDARD_VARIATIONS_U1 on VARIATION_ROW_ID establishes that column as the surrogate primary key and business-key candidate. The non-unique index AMW_NONSTANDARD_VARIATIONS_N1 covers the primary lookup path across STD_PROCESS_ID, STD_PROCESS_REV_NUM, NON_STD_PROCESS_ID, NON_STD_PROCESS_REV_NUM, STD_CHILD_ID, and NON_STD_CHILD_ID.

• VARIATION_ROW_ID — Surrogate primary key and unique business-key candidate; uniquely identifies each variation record.
• STD_PROCESS_ID / STD_PROCESS_REV_NUM — The standard process identifier and its revision number.
• NON_STD_PROCESS_ID / NON_STD_PROCESS_REV_NUM — The non-standard process identifier and its revision number that replaces the standard process.
• STD_CHILD_ID / NON_STD_CHILD_ID — The standard and non-standard child identifiers, mapping a standard child entity to its non-standard equivalent.
• START_DATE / END_DATE — Effective date range during which the variation mapping is active.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Who columns providing audit traceability.
• SECURITY_GROUP_ID — Supports hosted (multi-tenant) deployments; FK to FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — Used for optimistic locking during concurrent updates.

Common Use Cases and Queries

The table is typically queried to resolve which non-standard process definition applies to a standard process and child combination at a given point in time. Because of the composite non-unique index, the most efficient access path filters on the process and child identifiers. For example, to retrieve active variations for a given standard process:

SELECT VARIATION_ROW_ID, STD_PROCESS_ID, NON_STD_PROCESS_ID,
       NON_STD_PROCESS_REV_NUM, STD_CHILD_ID, NON_STD_CHILD_ID
FROM   AMW.AMW_NONSTANDARD_VARIATIONS_B
WHERE  STD_PROCESS_ID = :p_std_process_id
AND    STD_PROCESS_REV_NUM = :p_std_rev
AND    TRUNC(SYSDATE) BETWEEN NVL(START_DATE, SYSDATE)
                          AND NVL(END_DATE, SYSDATE);

Reporting scenarios include auditing active versus expired variations, reconciling standard-to-non-standard mappings before production runs, and validating completeness of child-level substitutions. Point-in-time reconciliation queries commonly join on VARIATION_ROW_ID when intersecting with downstream execution or cost records.

Related Objects

The documented FK relationship is limited to a single outbound reference; logical dependencies are inferred from the process and child identifier columns.

• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for hosted environment security filtering.
• AMW.AMW_NONSTANDARD_VARIATIONS_TL — Translation table typically paired with the _B base table for descriptive attributes.
• Standard process definition tables within the AMW schema keyed by STD_PROCESS_ID and STD_PROCESS_REV_NUM.
• Non-standard process definition tables keyed by NON_STD_PROCESS_ID and NON_STD_PROCESS_REV_NUM.
• Child/component entity tables referenced logically through STD_CHILD_ID and NON_STD_CHILD_ID.
• FND_OBJECTS / FND_DESIGN_DATA — Registration metadata, since the object carries FND Design Data designation AMW.AMW_NONSTANDARD_VARIATIONS_B.

Because no explicit FK constraints exist between this table and the process or child tables, joins must be performed manually on the identifier and revision columns, and integrity is enforced at the application layer.