Search Results amw_fin_process_flat

Overview

AMW_FIN_PROCESS_FLAT is a table within the Oracle E-Business Suite module AMW — Internal Controls Manager, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table stores flattened parent-child process relationships that have a direct impact on the items or accounts included in a financial certification. In other words, rather than requiring a recursive traversal of a hierarchical process tree at runtime, the flattening operation precomputes and persists every ancestor-descendant pairing so that downstream certification logic can resolve the full set of affected processes through a simple lookup.

From a data modeling perspective, the heuristic Data Vault classification for this table is standalone, as mined from its foreign key structure. This suggests treating AMW_FIN_PROCESS_FLAT as neither a pure hub nor a pure link in a strict Data Vault sense, though its parent-child pairing columns (PARENT_PROCESS_ID and CHILD_PROCESS_ID) exhibit link-like behavior connecting two process entities, while the surrounding audit and certification columns have satellite characteristics. The ETRM metadata notes that this table is not implemented in this database, meaning the object exists in the documented schema but may be absent or inactive in the current instance. Its owner is AMW, and 13 columns are documented for the 12.1.1 physical schema.

Key Information Stored

The most significant columns documented for this table are:

• FIN_CERTIFICATION_ID — Identifies the financial certification under which the flattened process relationships apply. This is the principal business-key candidate, scoping each row to a certification context.
• ORGANIZATION_ID — The operating unit or organization context, enabling multi-org partitioning of the flattening results.
• PARENT_PROCESS_ID — The ancestor process in the hierarchy, forming one side of the flattened relationship.
• CHILD_PROCESS_ID — The descendant process, forming the other side of the flattened relationship. Together, PARENT_PROCESS_ID and CHILD_PROCESS_ID constitute the meaningful business key of the pairing.
• APPROVAL_DATE — Timestamp recording when the flattened relationship or associated certification was approved.
• DELETION_APPROVAL_DATE — Timestamp recording approval of deletion, supporting soft-delete governance for auditability.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing row-level security and data access partitioning.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle EBS framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified the record and when.

The table does not expose a documented surrogate primary key in the metadata; the FK relationship on SECURITY_GROUP_ID to FND_SECURITY_GROUPS is the only explicitly documented referential constraint.

Common Use Cases and Queries

Because the table precomputes hierarchy flattening, its primary use case is certification scope resolution — determining which processes feed into which certified items or accounts without recursive queries. A typical reporting pattern resolves all descendants of a given process for a certification:

• Select CHILD_PROCESS_ID for a given PARENT_PROCESS_ID and FIN_CERTIFICATION_ID to enumerate affected sub-processes.
• Join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to restrict results to the user's authorized security group.
• Filter on APPROVAL_DATE versus DELETION_APPROVAL_DATE to distinguish active from retired relationships.
• Aggregate by ORGANIZATION_ID to report certification coverage per operating unit.

A representative query pattern would be:

SELECT p.CHILD_PROCESS_ID, p.APPROVAL_DATE FROM AMW_FIN_PROCESS_FLAT p WHERE p.FIN_CERTIFICATION_ID = :cert_id AND p.PARENT_PROCESS_ID = :parent_id AND p.DELETION_APPROVAL_DATE IS NULL;

Given the module's obsolete status, such queries are primarily relevant to historical data migration, audit reconstruction, or legacy reporting rather than active transaction processing.

Related Objects

The following objects are most significant to AMW_FIN_PROCESS_FLAT:

• FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID; the only explicitly documented foreign key target, providing security partitioning.
• AMW_FIN_PROCESSES — The underlying hierarchical process definition table whose parent-child relationships are flattened into this table (referenced conceptually through PARENT_PROCESS_ID and CHILD_PROCESS_ID).
• AMW_FIN_CERTIFICATIONS — The certification header referenced by FIN_CERTIFICATION_ID.
• AMW_FIN_ITEMS / AMW_FIN_ACCOUNTS — The items and accounts whose certification is impacted by the flattened processes, per the documented description.
• FND_ORGANIZATION_UNITS — Source for ORGANIZATION_ID multi-org context.

Because the table is classified as standalone with limited documented relationships, integration is primarily through the certification and process tables rather than through public APIs, consistent with the module's obsolete designation.