Search Results sub_orgs_evaluated

Overview

AMW.AMW_AUDIT_SCOPE_ORGANIZATIONS is a transactional summary table within the Oracle E-Business Suite Governance, Risk, and Compliance (GRC) / Audit Management module, owned by the AMW schema. It captures the count of processes, risks, and controls for an organization within a specific audit engagement. Each row represents a summarized audit scope entry, aggregating evaluation statistics for a given organization under an audit project, identified by AUDIT_PROJECT_ID. This table enables auditors and compliance managers to review, at a glance, how many processes, risks, and controls were evaluated, and how many of those were found to be ineffective, unmitigated, or otherwise deficient.

The documented metadata classifies this object heuristically as a standalone data object, meaning that, based on foreign key analysis, it does not serve as a classic Data Vault hub, link, or satellite. Nevertheless, the presence of a foreign key to AMW_AUDIT_PROJECTS suggests that, from a modeling perspective, it behaves like a satellite of the audit project, carrying descriptive and aggregated measures keyed to that project and organization. The SECURITY_GROUP_ID foreign key to FND_SECURITY_GROUPS supports hosted or multi-tenant deployments.

Key Information Stored

The table contains 28 documented columns. The most significant columns include the following:

• AUDIT_PROJECT_ID — The audit project identifier and the primary foreign key linking each row to its parent engagement in AMW_AUDIT_PROJECTS.
• SUBSIDIARY_VS / SUBSIDIARY_CODE — The subsidiary value set and code, indicating the organizational unit in scope.
• LOB_VS / LOB_CODE — The line-of-business value set and code, enabling segmentation of audit scope by business line.
• ORGANIZATION_ID — The organization identifier for the scope entry.
• EVALUATION_OPINION_ID — The identifier of the evaluation opinion rendered for this scope organization.
• SUB_ORGS_EVALUATED, INEFFECTIVE_SUB_ORGS, TOTAL_SUB_ORGS — Counts of sub-organizations evaluated, found ineffective, and total in scope.
• PROCESSES_EVALUATED, INEFFECTIVE_PROCESSES, TOTAL_PROCESSES — The process-level counts. INEFFECTIVE_PROCESSES is a key metric for identifying weak process areas. This is the column most directly referenced by the user's search for "ineffective_processes."
• RISKS_EVALUATED, UNMITIGATED_RISKS, TOTAL_RISKS — Risk evaluation and mitigation summary counts.
• CONTROLS_EVALUATED, INEFFECTIVE_CONTROLS, TOTAL_CONTROLS — Control evaluation counts, including ineffective controls.
• OPEN_FINDINGS / OPEN_ISSUES — Counts of outstanding findings and issues.
• SECURITY_GROUP_ID — Used in hosted environments; references FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — Used for optimistic locking.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

The audit project identifier functions as the principal business key in combination with the organization and subsidiary/LOB descriptors. The table does not expose a separate surrogate primary key column in the documented metadata; identity is derived from the project and scope combination.

Common Use Cases and Queries

Typical use cases center on audit performance reporting and compliance dashboards. Analysts query this table to surface organizations and engagements with ineffective processes, unmitigated risks, or high counts of ineffective controls. Representative SQL patterns include:

• Retrieving all scope organizations for a project: SELECT * FROM AMW.AMW_AUDIT_SCOPE_ORGANIZATIONS WHERE AUDIT_PROJECT_ID = :p_project_id;
• Identifying ineffective processes: SELECT ORGANIZATION_ID, INEFFECTIVE_PROCESSES, TOTAL_PROCESSES FROM AMW.AMW_AUDIT_SCOPE_ORGANIZATIONS WHERE INEFFECTIVE_PROCESSES > 0;
• Aggregating risk exposure: SELECT SUM(UNMITIGATED_RISKS), SUM(TOTAL_RISKS) FROM AMW.AMW_AUDIT_SCOPE_ORGANIZATIONS WHERE AUDIT_PROJECT_ID = :p_project_id;
• Segmenting by line of business: SELECT LOB_CODE, SUM(INEFFECTIVE_CONTROLS) FROM AMW.AMW_AUDIT_SCOPE_ORGANIZATIONS GROUP BY LOB_CODE;

Related Objects

The most significant related objects, per the documented foreign key and schema relationships, are:

• AMW.AMW_AUDIT_PROJECTS — Parent engagement table joined via AUDIT_PROJECT_ID.
• FND_SECURITY_GROUPS — Join on SECURITY_GROUP_ID for hosted environment security.
• HR_ALL_ORGANIZATION_UNITS — Common join on ORGANIZATION_ID for organization names.
• AMW_AUDIT_SCOPE_PROCESSES — Detail-level process scope records that roll up into this summary.
• AMW_AUDIT_SCOPE_RISKS — Risk-level detail supporting UNMITIGATED_RISKS and TOTAL_RISKS.
• AMW_AUDIT_SCOPE_CONTROLS — Control-level detail supporting INEFFECTIVE_CONTROLS and TOTAL_CONTROLS.