Search Results amw_evaluations_b_pk

Overview

AMW_EVALUATIONS_B is the evaluations base table within the AMW — Internal Controls Manager product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The table resides in the AMW schema and holds one row per evaluation executed against a registered business object, capturing the identity of the evaluated object, the evaluation context, the configured evaluation set, timing information, and the standard EBS audit columns. Its primary key is constrained by AMW_EVALUATIONS_B_PK on EVALUATION_ID.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. The evaluation identity (EVALUATION_ID) behaves as a hub-like business key, while the descriptive and audit attributes function as satellite content attached to that identity. The single documented foreign key, AMW_EVALUATIONS_B.SECURITY_GROUP_ID referencing FND_SECURITY_GROUPS, is organizational rather than hierarchical and does not change the standalone classification. The table is therefore best understood as an evaluation header, with scoring and detail rows maintained separately and linked by EVALUATION_ID.

Key Information Stored

EVALUATION_ID is the surrogate primary key and is additionally documented as a unique index (AMW_EVALUATIONS_B_U1), making it the effective business-key candidate. The remaining columns describe the evaluation itself:

• EVALUATION_SET_ID and EVALUATION_SET_STATUS_CODE — the evaluation set to which the evaluation belongs and its current status, providing the primary grouping and lifecycle indicator.
• EVALUATION_TYPE and EVALUATION_CONTEXT — the nature of the evaluation and the context in which it was executed.
• EVALUATION_OBJECT_NAME with PK1_VALUE through PK5_VALUE — a generic, denormalized key mechanism identifying the evaluated business object and its composite key values, which is why this table scales across many AMW object types.
• DATE_EVALUATED, EXECUTED_BY_ID, and ENTERED_BY_ID — when the evaluation ran and who executed and entered it.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, governing row-level access by operating unit or security group.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the AMW middle tier.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS who-columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard descriptive flexfield (DFF) columns for client-specific extension.

In total, 37 columns are documented in the 12.1.1 physical schema.

Common Use Cases and Queries

The table supports Internal Controls Manager reporting, where users need to review evaluation activity by set, type, status, or date, and to identify the responsible parties. A typical query retrieves recent evaluations for a security group:

SELECT e.evaluation_id, e.evaluation_set_id, e.evaluation_type,
       e.evaluation_object_name, e.date_evaluated, e.executed_by_id
 FROM amw.amw_evaluations_b e
 WHERE e.security_group_id = :p_security_group_id
   AND e.date_evaluated >= :p_from_date
 ORDER BY e.date_evaluated DESC;

Joining to the detail table yields scored results for a completed evaluation, while a status-based query filtered on EVALUATION_SET_STATUS_CODE supports open-item or aged-evaluation reports. Because the evaluated object is identified through EVALUATION_OBJECT_NAME and PK1_VALUE through PK5_VALUE, extracting object-specific data requires applying that context filter rather than a conventional foreign key join. Extracts into ETL staging tables commonly use EVALUATION_ID as the driving key.

Related Objects

Several objects depend on AMW_EVALUATIONS_B through EVALUATION_ID. The most significant are:

• AMW_EVALUATIONS_DETAILS.EVALUATION_ID — child detail rows holding the individual questions and responses for each evaluation.
• POA_CM_EVALUATION.EVALUATION_ID — the Public Sector / grants evaluation header that references the AMW evaluation.
• POA_CM_EVAL_SCORES.EVALUATION_ID — evaluation scores persisted against the evaluation header.
• POA_EDW_CSTM_MSR_F.EVALUATION_ID and POA_EDW_CSTM_MSR_FSTG.EVALUATION_ID — warehouse fact and staging tables populated from AMW evaluation data.
• OTA_EVALUATIONS.EVALUATION_ID — the Oracle Training Administration evaluations object that shares the same key reference.
• FND_SECURITY_GROUPS — referenced by AMW_EVALUATIONS_B.SECURITY_GROUP_ID and used to enforce access to evaluation rows.

Because multiple unrelated products reference EVALUATION_ID, integration and reporting designs should verify the owning application before assuming that a given identifier maps exclusively to an AMW evaluation.