Search Results create_entity_control

Overview

AMW_LOAD_RCM_ORG_DATA is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite environment. It forms part of the Application Management Workspace (AMW) module, which provides the infrastructure for Risk and Control Management (RCM) functionality used in Oracle EBS governance, risk, and compliance processes. The package is classified as "OTHER" in the API taxonomy and exists in VALID status in both Oracle EBS 12.1.1 and 12.2.2.

Its primary business function is to load and manage organizational Risk and Control Management data by creating and associating risks, controls, objectives, assertions, and components across the AMW data model. It acts as a data-loading utility that bridges interface data with the underlying RCM repository, enabling organizations to establish structured risk frameworks and control hierarchies at the organizational level. This is particularly relevant for setups involving internal controls over financial reporting and audit compliance initiatives.

Key Procedures and Functions

The package exposes seventeen documented routines, which can be grouped by function:

• CREATE_RISKS_AND_CONTROLS — Creates the core risk and control records used in the RCM model.
• UPDATE_INTERFACE_WITH_ERROR — Records error information against the loading interface, supporting troubleshooting and validation feedback.
• RISK_TYPES, CONTROL_OBJECTIVES, CONTROL_ASSERTIONS, CONTROL_COMPONENTS — Populate and manage reference/list data for risk types, control objectives, assertions, and components.
• CREATE_PROCESS_OBJECTIVES — Establishes objectives tied to processes.
• CREATE_AMW_CTRL_ASSOC, PROCESS_AP_CTRL_ASSOC_RCM, PROCESS_AP_CTRL_ASSOC_ORG — Build control associations, including organizational-scoped variants.
• CREATE_AMW_AP_ASSOC, CREATE_AMW_OBJ_ASSOC, CREATE_AMW_RISK_ASSOC — Create association records linking accounting points, objectives, and risks.
• ADD_OWNER_PRIVILEGE — Assigns owner-level privileges to entities, supporting security and ownership tracking.
• CHECK_FUNCTION — Performs validation or availability checks, often used as a gate before processing.
• CREATE_ENTITY_RISK, CREATE_ENTITY_CONTROL — Create risks and controls at the entity level.

Tables Accessed

The package references a range of AMW tables via APPS synonyms, including AMW_AP_ASSOCIATIONS and its _S sequence-backed table, AMW_ASSESSMENT_COMPONENTS and _S, AMW_CONTROLS_B and AMW_CONTROLS_TL (with _S1), AMW_CONTROL_ASSERTIONS and _S, AMW_CONTROL_ASSOCIATIONS and _S, AMW_CONTROL_OBJECTIVES and _S, and AMW_OBJECTIVE_ASSOCIATIONS and _S. These tables store the persistent risk, control, objective, and assertion data along with their associations. The package reads and writes to these tables during load operations to construct the complete RCM organizational data set, and its dependence on SYS.STANDARD reflects use of standard PL/SQL built-ins.

Usage Notes

This package is typically invoked during RCM data loading and setup activities, often behind forms or concurrent programs that populate organizational risk and control structures. It is referenced by itself (AMW_LOAD_RCM_ORG_DATA), indicating recursive or internal procedural calls. Because it is not referenced by other packages, its primary consumers are forms, concurrent requests, or custom deployment scripts executing the load logic directly. Developers extending RCM functionality should treat the documented procedures as the supported entry points and avoid bypassing them to write directly to the underlying AMW tables.