Search Results amw_certification_b_pk

Overview

The AMW_CERTIFICATION_B table is the certifications base table within the AMW – Internal Controls Manager module of Oracle E-Business Suite. It serves as the central repository for certification records generated during internal control and financial compliance processes, including SOX-style certification cycles. Each row represents a single certification instance that a designated owner must review, attest to, and complete within a defined period.

This table functions as the transactional core around which certification dashboards, evaluation summaries, and execution scopes are organized. It captures the identity of the certification owner, the certification type and status, the target and actual completion dates, and the outcome of the certification.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a hub-leaning classification. The CERTIFICATION_ID acts as the natural business key candidate, and several downstream tables reference it, reinforcing its role as a central hub entity with associated descriptive satellites.

Key Information Stored

The table contains 39 documented columns. The most significant include:

• CERTIFICATION_ID – Surrogate primary key and the primary business-key candidate, enforced by unique index AMW_CERTIFICATION_B_U1 and constraint AMW_CERTIFICATION_B_PK.
• CERTIFICATION_OWNER_ID – Identifies the individual responsible for completing the certification.
• CERTIFICATION_TYPE and CERTIFICATION_STATUS – Classify the certification and track its lifecycle state.
• CERTIFICATION_CREATION_DATE, TARGET_COMPLETION_DATE, and CERTIFICATION_COMPLETION_DATE – Capture the timeline of the certification.
• CERTIFICATION_PERIOD_NAME and CERTIFICATION_PERIOD_SET_NAME – Link the certification to a GL period and period set.
• CERTIFICATION_RESULT – Stores the outcome of the certification review.
• CERTIFICATION_REMINDER and LAST_REMINDER_DATE – Support notification and reminder workflows.
• SECURITY_GROUP_ID – Governs row-level access through FND_SECURITY_GROUPS.
• ORIG_SYSTEM_REFERENCE, OBJECT_TYPE, STATEMENT_GROUP_ID, and FINANCIAL_STATEMENT_ID – Provide contextual and integration references.
• Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the OBJECT_VERSION_NUMBER support auditing and optimistic locking.

Common Use Cases and Queries

Typical reporting scenarios include tracking outstanding certifications by owner, measuring on-time completion against TARGET_COMPLETION_DATE, and summarizing certification results per period. A common query retrieves active certifications due in a given GL period:

• SELECT CERTIFICATION_ID, CERTIFICATION_OWNER_ID, CERTIFICATION_STATUS, TARGET_COMPLETION_DATE FROM AMW_CERTIFICATION_B WHERE CERTIFICATION_PERIOD_NAME = :period AND CERTIFICATION_STATUS != 'COMPLETE';
• Joining to AMW_CERT_DASHBOARD_SUM on CERTIFICATION_ID to produce dashboard-level rollups.
• Aggregating certification results by CERTIFICATION_TYPE for compliance reporting.
• Auditing reminder activity using CERTIFICATION_REMINDER and LAST_REMINDER_DATE.

Related Objects

The following objects depend on or reference AMW_CERTIFICATION_B:

• AMW_CERT_DASHBOARD_SUM – References CERTIFICATION_ID for dashboard summaries.
• AMW_PROC_CERT_EVAL_SUM – References CERTIFICATION_ID for process certification evaluations.
• AMW_EXECUTION_SCOPE – References ENTITY_ID, relating execution scope to the certification.
• GL_PERIODS – Referenced through CERTIFICATION_PERIOD_SET_NAME and CERTIFICATION_PERIOD_NAME.
• FND_SECURITY_GROUPS – Referenced through SECURITY_GROUP_ID for access control.