Search Results ame_mandatory_attributes




Overview
Explore in AI Chat

Overview

AME_MANDATORY_ATTRIBUTES is a table owned by the HR schema within the Oracle E-Business Suite, classified under the PER (Human Resources) product module. It is part of the Oracle Approvals Management Engine (AME) infrastructure, which governs approval routing, rules evaluation, and transaction attribute processing across multiple EBS applications. The table records mandatory attributes associated with specific attribute-to-action-type combinations, defining which attributes must be present or enforced for approval actions to be evaluated correctly.

The ETRM metadata classifies this object heuristically, based on its foreign key structure, as a standalone entity. This classification suggests the table functions as a reference or configuration store rather than participating in the traditional Data Vault hub, link, or satellite pattern. In a Data Vault modeling exercise, it would most naturally map to a reference satellite or a standalone configuration table, given its single documented foreign key relationship and its lack of join dependencies to multiple parent entities.

Key Information Stored

The table contains twelve documented columns in ETRM 12.2.2. The most operationally significant are the business-key components and the audit/versioning columns that govern the record lifecycle.

The unique index AME_MANDATORY_ATTRIBUTES_UK1 (ATTRIBUTE_ID, ACTION_TYPE_ID, START_DATE, END_DATE, ZD_EDITION_NAME) represents the principal business-key candidate, distinguishing surrogate identity from the logical key that enforces uniqueness of the effective-dated rule.

Common Use Cases and Queries

This table is typically queried during AME configuration audits, approval-rule troubleshooting, and effective-dated rule validation. A representative query retrieves the mandatory attributes active for a given action type within a date range:

  • Identify all attributes currently enforced for an action: SELECT ATTRIBUTE_ID, ACTION_TYPE_ID, START_DATE, END_DATE FROM AME_MANDATORY_ATTRIBUTES WHERE ACTION_TYPE_ID = :action_id AND SYSDATE BETWEEN START_DATE AND END_DATE;
  • Audit security-group scoped records: join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to confirm access boundaries.
  • Track configuration changes over time using START_DATE/END_DATE windows and the audit columns.
  • Reconcile AME setup against approval rule definitions to detect missing or duplicated mandatory-attribute entries.
  • Validate edition-based patching by filtering on ZD_EDITION_NAME.

Related Objects

The documented foreign key defines the most direct dependency: SECURITY_GROUP_ID references FND_SECURITY_GROUPS. Beyond this, AME_MANDATORY_ATTRIBUTES logically integrates with the broader AME and FND security infrastructure, including AME attribute and action-type definition tables referenced by ATTRIBUTE_ID and ACTION_TYPE_ID, and versioning/edition objects tied to ZD_EDITION_NAME. Its placement in the HR schema also aligns it with EBS Human Resources configuration objects that consume AME approval processing.