Results for “orgs_evaluated”
7 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The AMW_FIN_CERT_EVAL_SUM table is a core summary object within the Oracle E-Business Suite Internal Controls Manager (AMW) module. It stores the computed ratios and aggregated evaluation results for each financial item and natural account combination associated with a financial certification. In practice, this table functions as the quantitative backbone of the financial certification workflow: as management and process owners complete their evaluations of processes, organizations, risks, and controls, the AMW engine rolls those results up and persists the resulting metrics here for reporting, dashboards, and sign-off decisions.
From a dimensional modeling perspective, the heuristic Data Vault classification derived from the foreign key structure is standalone, meaning the table does not behave as a strict hub, link, or satellite. It instead acts as a denormalized summary or fact-style table, holding both the qualifying business keys (certification, statement, item, account) and a rich set of derived numeric measures. This classification should be treated as a modeling suggestion rather than a formal constraint, since the table's primary purpose is performance-oriented aggregation rather than normalized relationship storage.
Key Information Stored
The table contains 37 documented columns. The most operationally significant are the identifiers and the computed measure/percentage pairs. The composite business key is defined by the unique index AMW_FIN_CERT_EVAL_SUM_U1, which spans FIN_CERTIFICATION_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, and NATURAL_ACCOUNT_ID. These four columns identify the exact certification, statement line, financial item, and natural account to which the summarized metrics belong. Additional qualifiers include ACCOUNT_GROUP_ID and OBJECT_TYPE.
- FIN_CERTIFICATION_ID – Surrogate reference to the parent financial certification record.
- FINANCIAL_STATEMENT_ID / FINANCIAL_ITEM_ID / NATURAL_ACCOUNT_ID – Business-key qualifiers identifying the reporting context.
- PROC_PENDING_CERTIFICATION, PROC_CERTIFIED_WITH_ISSUES, PROC_EVALUATED, PROCS_FOR_CERT_DONE – Process-level counts tracking certification progress.
- ORGS_EVALUATED, ORGS_FOR_CERT_DONE, TOTAL_NUMBER_OF_ORGS – Organization coverage measures.
- UNMITIGATED_RISKS, RISKS_VERIFIED, TOTAL_NUMBER_OF_RISKS – Risk evaluation counts.
- INEFFECTIVE_CONTROLS, CONTROLS_VERIFIED, TOTAL_NUMBER_OF_CTRLS – Control assessment counts.
- *_PRCNT columns (e.g. PRO_PENDING_CERT_PRCNT, INEFECTIVE_CONTROLS_PRCNT) – Precalculated ratio percentages derived from the raw counts.
- OBJ_CONTEXT, SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER – Multitenancy, security, and concurrency control.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns.
Common Use Cases and Queries
The table is typically queried to drive financial certification dashboards and sign-off reports. A common pattern joins the summary back to certification and statement metadata while filtering on the business key. For example:
SELECT fce.FIN_CERTIFICATION_ID,
fce.FINANCIAL_STATEMENT_ID,
fce.NATURAL_ACCOUNT_ID,
fce.INEFECTIVE_CONTROLS_PRCNT,
fce.UNMITIGATED_RISKS_PRCNT
FROM AMW_FIN_CERT_EVAL_SUM fce
WHERE fce.FIN_CERTIFICATION_ID = :cert_id
ORDER BY fce.FINANCIAL_ITEM_ID;
Reporting scenarios include monitoring the percentage of processes pending certification, identifying financial items with ineffective controls above tolerance, and summarizing unmitigated risk exposure by natural account. Because the percentage columns are precalculated, reports avoid expensive runtime aggregation, making this table valuable for high-volume executive dashboards.
Related Objects
The documented foreign key links SECURITY_GROUP_ID to FND_SECURITY_GROUPS, enforcing multitenant data segregation. The primary business relationships flow through the certification and financial statement model, so significant related objects include AMW_FIN_CERTIFICATIONS, AMW_FIN_STATEMENTS, AMW_FIN_ITEMS, and the natural account/account group reference tables. Joins are performed on FIN_CERTIFICATION_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, and NATURAL_ACCOUNT_ID. The table does not act as a parent to other tables, consistent with its standalone classification.
-
The Ratios computed for Each Financial Item and Natural Accounts for a Financial Certification are Stored here
-
eTRM - AMW Tables and Views 12.1.1
This fact table stores the summary data related to the Significant Account Evaluation report