Search Results amw_fin_proc_cert_relan




Overview
Explore in AI Chat

Overview

AMW_FIN_PROC_CERT_RELAN is a table within the Oracle E-Business Suite Internal Controls Manager (ICM) module, documented under the AMW product schema. Its stated purpose is to store the relationship between financial statement certifications and the underlying process certifications that support them — essentially the associative data connecting a top-level certification of financial statements to the individual business processes whose controls must be attested. The ETRM metadata describes this object as obsolete and, notably, "Not implemented in this database," indicating the table exists only in certain historical releases and configurations of the ICM application.

From a Data Vault modeling perspective, the heuristic classification inferred from the mined foreign key structure is standalone, meaning it does not exhibit the dense inbound/outbound reference patterns typical of a pure hub or link. The two unique indexes nonetheless expose a composite business key (FIN_STMT_CERT_ID with PROC_CERT_ID), which suggests the table behaves as an associative entity recording the pairing of parent certifications to their constituent process certifications.

Key Information Stored

The table carries eleven documented columns in the 12.1.1 physical schema. The most significant are summarized here.

  • FIN_PROC_CERT_ID — the surrogate primary key, enforced by the unique index AMW_FIN_PROC_CERT_RELAN_U1. This single column uniquely identifies each relationship row.
  • FIN_STMT_CERT_ID — the financial statement certification identifier to which the process certification is attached; part of the composite business key.
  • PROC_CERT_ID — the process certification identifier being related; the second component of the composite business key captured by AMW_FIN_PROC_CERT_RELAN_U2.
  • SECURITY_GROUP_ID — the multi-tenant / operating unit security grouping, foreign-keyed to FND_SECURITY_GROUPS, governing row-level access.
  • END_DATE — the effective end date of the relationship, supporting date-tracked or expired associations.
  • OBJECT_VERSION_NUMBER — the optimistic locking column used by the EBS framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording creation and modification provenance and session context.

Common Use Cases and Queries

The primary reporting use case is determining which process certifications roll up into a given financial statement certification, and vice versa. A typical query joins the relationship row to the parent and child certification tables by their identifier columns:

  • List all process certifications for a statement certification: SELECT PROC_CERT_ID FROM AMW_FIN_PROC_CERT_RELAN WHERE FIN_STMT_CERT_ID = :stmt_cert AND (END_DATE IS NULL OR END_DATE > SYSDATE);
  • Reverse lookup to find the parent statement certification supporting a process certification by filtering on PROC_CERT_ID.
  • Security-scoped extracts filtering on SECURITY_GROUP_ID to respect the caller's operating unit.
  • Audit and change-tracking reports using the WHO columns and OBJECT_VERSION_NUMBER to identify recently modified or concurrently edited relationships.

Because the object is documented as not implemented, these patterns apply only where the ICM financial statement certification feature was actively configured; queries against an empty or absent table should be treated as expected in modern deployments.

Related Objects

The documented foreign key identifies one explicit dependency, and the business-key indexes imply further relationships to the certification entities referenced by their identifiers.

  • FND_SECURITY_GROUPS — joined on AMW_FIN_PROC_CERT_RELAN.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID; governs row visibility.
  • Financial statement certification table (AMW_FIN_STMT_CERT) — joined on FIN_STMT_CERT_ID; supplies parent certification attributes.
  • Process certification table (AMW_PROC_CERT) — joined on PROC_CERT_ID; supplies the constituent process certification details.
  • FND_OBJECTS / FND_APPLICATION — for metadata registration and module identification within the AMW schema.
  • Standard WHO and security-group infrastructure tables — including FND_USER references implied by CREATED_BY and LAST_UPDATED_BY.

Implementers should treat AMW_FIN_PROC_CERT_RELAN as a legacy, release-specific associative table. Its documented obsolescence and non-implementation mean that dependent integrations should be validated against the actual target database before relying on its presence.