You are browsing the archive for Oracle Internal Controls Manager.

Oracle Internal Controls Manager Tables

Key tables information related to Oracle Internal Controls Manager module of Oracle Apps:

  • AMW_ACCOUNT_ASSERTIONS
  • AMW_ACCT_ASSOCIATIONS
  • AMW_APPROVED_HIERARCHIES
  • AMW_AP_ASSOCIATIONS
  • AMW_AP_EXECUTIONS
  • AMW_AP_EXT_B
  • AMW_AP_EXT_TL
  • AMW_AP_INTERFACE
  • AMW_AP_STEPS_B
  • AMW_AP_STEPS_TL
  • AMW_AP_TASKS
  • AMW_ASSESSMENTS_B
  • AMW_ASSESSMENTS_TL
  • AMW_ASSESSMENT_COMPONENTS
  • AMW_ASSESSMENT_CONTEXTS
  • AMW_ASSESS_PROCEDURES_B
  • AMW_ASSESS_PROCEDURES_TL
  • AMW_ASSESS_PROCEDURE_ASSOCS
  • AMW_ASSESS_PROCEDURE_STEPS_B
  • AMW_ASSESS_PROCEDURE_STEPS_TL
  • AMW_AUDIT_OBJECTIVES_B
  • AMW_AUDIT_OBJECTIVES_TL
  • AMW_AUDIT_OBJ_ASSOC
  • AMW_AUDIT_PROCEDURES_B
  • AMW_AUDIT_PROCEDURES_TL
  • AMW_AUDIT_PROCEDURE_INTERFACE
  • AMW_AUDIT_PROJECTS
  • AMW_AUDIT_PROJECTS_TL
  • AMW_AUDIT_SCOPE_ORGANIZATIONS
  • AMW_AUDIT_SCOPE_PROCESSES
  • AMW_AUDIT_TASKS_B
  • AMW_AUDIT_TASKS_TL
  • AMW_CERTIFICATION_B
  • AMW_CERTIFICATION_TL
  • AMW_CERT_DASHBOARD_SUM
  • AMW_COMPLIANCE_ENVS_B
  • AMW_COMPLIANCE_ENVS_TL
  • AMW_COMPLIANCE_ENV_ASSOCS
  • AMW_CONSTRAINTS_B
  • AMW_CONSTRAINTS_TL
  • AMW_CONSTRAINT_ENTRIES
  • AMW_CONSTRAINT_EXT_B
  • AMW_CONSTRAINT_EXT_TL
  • AMW_CONSTRAINT_INTERFACE
  • AMW_CONSTRAINT_WAIVERS
  • AMW_CONSTRAINT_WAIVERS_B
  • AMW_CONSTRAINT_WAIVERS_TL
  • AMW_CONTROLS_B
  • AMW_CONTROLS_TL
  • AMW_CONTROL_AP
  • AMW_CONTROL_ASSERTIONS
  • AMW_CONTROL_ASSOCIATIONS
  • AMW_CONTROL_OBJECTIVES
  • AMW_CONTROL_PURPOSES
  • AMW_CONTROL_REPORTS
  • AMW_CTRL_EXT_B
  • AMW_CTRL_EXT_TL
  • AMW_CTRL_INTERFACE
  • AMW_ENTITY_HIERARCHIES
  • AMW_EVALUATIONS_B
  • AMW_EVALUATIONS_DETAILS
  • AMW_EVALUATIONS_TL
  • AMW_EXCEPTIONS_B
  • AMW_EXCEPTIONS_REASONS
  • AMW_EXCEPTIONS_TL
  • AMW_EXECUTION_SCOPE
  • AMW_FIN_CERT_CTRL_SUM
  • AMW_FIN_CERT_EVAL_SUM
  • AMW_FIN_CERT_SCOPE
  • AMW_FIN_ITEMS_KEY_ACC
  • AMW_FIN_ITEM_ACC_CTRL
  • AMW_FIN_ITEM_ACC_RISK
  • AMW_FIN_ITEM_FLAT
  • AMW_FIN_KEY_ACCOUNTS_B
  • AMW_FIN_KEY_ACCOUNTS_TL
  • AMW_FIN_KEY_ACCT_FLAT
  • AMW_FIN_ORG_EVAL_SUM
  • AMW_FIN_PROCESS_EVAL_SUM
  • AMW_FIN_PROCESS_FLAT
  • AMW_FIN_PROC_CERT_RELAN
  • AMW_FIN_STMNT_B
  • AMW_FIN_STMNT_ITEMS_B
  • AMW_FIN_STMNT_ITEMS_TL
  • AMW_FIN_STMNT_SELECTION
  • AMW_FIN_STMNT_TL
  • AMW_KEY_ACC_INTERFACE
  • AMW_LATEST_HIERARCHIES
  • AMW_MEASURE_ASSOCIATIONS
  • AMW_NONSTANDARD_VARIATIONS_B
  • AMW_NONSTANDARD_VARIATIONS_TL
  • AMW_OBJECTIVE_ASSOCIATIONS
  • AMW_OBJECTS
  • AMW_OBJECT_ASSESSMENTS
  • AMW_OBJECT_OPINION_TYPES
  • AMW_OBJECT_RULES
  • AMW_OPINIONS
  • AMW_OPINIONS_LOG
  • AMW_OPINION_COMPONTS_B
  • AMW_OPINION_COMPONTS_TL
  • AMW_OPINION_DETAILS
  • AMW_OPINION_LOG_DETAILS
  • AMW_OPINION_TYPES_B
  • AMW_OPINION_TYPES_TL
  • AMW_OPINION_VALUES_B
  • AMW_OPINION_VALUES_TL
  • AMW_OPINION_VALUE_CODES
  • AMW_ORG_CERT_EVAL_SUM
  • AMW_ORG_HIERARCHY_DENORM
  • AMW_PARAMETERS
  • AMW_PROCESS
  • AMW_PROCESSES_INTERFACE
  • AMW_PROCESS_EXT_B
  • AMW_PROCESS_EXT_TL
  • AMW_PROCESS_LOCKS
  • AMW_PROCESS_NAMES_TL
  • AMW_PROCESS_OBJECTIVES_B
  • AMW_PROCESS_OBJECTIVES_TL
  • AMW_PROCESS_ORGANIZATION
  • AMW_PROCESS_ORG_RELATIONS
  • AMW_PROCESS_RISK_CONTROLS
  • AMW_PROCESS_RISK_CTRL_AP
  • AMW_PROC_CERT_EVAL_SUM
  • AMW_PROC_HIERARCHY_DENORM
  • AMW_PROC_ORG_EXT_B
  • AMW_PROC_ORG_EXT_TL
  • AMW_RCM_ORG_INTERFACE
  • AMW_RISKS_B
  • AMW_RISKS_TL
  • AMW_RISK_ASSOCIATIONS
  • AMW_RISK_CTRL_INTERFACE
  • AMW_RISK_EXT_B
  • AMW_RISK_EXT_TL
  • AMW_RISK_TYPE
  • AMW_ROLE_CONSTRAINT_DENORM
  • AMW_SECURITY_ROLE_MAPPINGS
  • AMW_SETUP_RISK_TYPES_B
  • AMW_SETUP_RISK_TYPES_TL
  • AMW_SIGNIFICANT_ELEMENTS
  • AMW_SURVEY_ASSOCS
  • AMW_THRESHOLD_VALUES
  • AMW_VIOLATIONS
  • AMW_VIOLATION_USERS
  • AMW_VIOLAT_USER_ENTRIES
  • AMW_WORK_CATEGORIES_B
  • AMW_WORK_CATEGORIES_TL
  • AMW_WORK_EXT_B
  • AMW_WORK_EXT_TL
  • AMW_WORK_TYPES_B
  • AMW_WORK_TYPES_TL
  • RCI_COMPL_ENV_CHG_SUMM_F
  • RCI_DR_INC
  • RCI_ORG_CERT_RISKS_F
  • RCI_ORG_CERT_SUMM_F
  • RCI_PROC_CERT_SUM_F

Internal Controls Manager Profile Options

Oracle Internal Controls Manager Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
AMW_DISPLAY_IMPORTED_FINSTMT AMW: Display Already Imported Financial Statements
AMW_FIN_DISPLAY_NAV AMW: Display Natural Account Value with Key Account Name
AMW_DELT_KEY_ACC_INTF AMW: Process to Key Account Associations – Delete after Import
AMW_CORRECTIONREQ_ACCESS AMW: Correction Request Access
AMW_FINDING_ACCESS AMW: Finding Access
AMW_ISSUE_ACCESS AMW: Issue Access
AMW_REMEDIATION_ACCESS AMW: Remediation Access
AMW_COMPILED_MENU_FUNCTIONS AMW: flat view for menu function relation
AMW_WFT_FILE_DIRECTORY AMW: Directory Name for Saving WFT Files
AMW_DELT_RISK_CNTRL_INTF AMW: Risks and Controls – Delete after import .
AMW_CONTROL_NAME_PREFIX AMW: Control Name Prefix
AMW_DELT_RCM_ORG_INTF AMW: Risks Controls in Organization – Delete after Import
AMW_PROC_ORG_ASS_APPRV AMW: Auto-Approve Process During Org Association
AMW_PROC_IMP_APPL_OWNER_COL AMW Process Import Application Owner Column
AMW_PROC_IMP_FINANCE_OWNER_COL AMW Process Import Finance Owner Column
AMW_APPROVAL_TIMEOUT_VALUE AMW : Time-out limit for Control, Risk and Audit Procedure Approval (number, in days)
AMW_DISABLE_WORKFLOW_APPROVAL AMW : Disable Workflow Approval
AMW_NATRL_ACCT_VALUE_SET AMW: Natural Account Value Set
AMW_SUBSIDIARY_AUDIT_UNIT AMW: Subsidiary Value Set for Audit Units
AMW_LOB_AUDIT_UNITS AMW: LOB Value set for Audit Units
AMW_AUDIT_PROJECT_TYPE AMW: Audit Project Type
AMW_DELT_PROCESS_INTF AMW: Processes – Delete after Import
AMW_FORM_FUNCTIONS_VL AMW: View for function name
AMW_MENU_ENTRIES AMW: Table for menu entries
AMW_MENUS AMW: Table for menus
AMW_RESP_FUNCTIONS AMW: Table for exclusion function rules
AMW_RESPONSIBILITY AMW: Table for responsibilities
AMW_USER_RESP_GROUPS AMW: Table for user responsibilities
AMW_USER AMW: Table for users
AMW_MENUS_VL AMW: View for menu names
AMW_RESPONSIBILITY_VL AMW: View for responsibility name
AMW_GLOBAL_ORG_ID AMW: Headquarters
AMW_SET_STD_PROCESS AMW: Default Processes to Standard Process
AMW_CALENDAR AMW: Default Calendar
AMW_EXCEPTION_CHECKBOX AMW: Exception Checkbox Values
AMW_DELT_CTRL_INTF AMW: Controls – Delete after Import
AMW_DELT_AP_INTF AMW: Audit Procedures – Delete after Import
AMW_DEFAULT_TRANSACTIONAL_CURRENCY AMW: Default Transactional Currency
AMW_FIN_IMPORT_FROM_FSG AMW: Use Oracle Financial Statement Generator
AMW_STMNT_SOURCE_VIEW AMW:  View for Financial Statements in External Apps
AMW_FINITEM_SOURCE_VIEW AMW:  View for Financial Items in External Apps
AMW_FIN_ITEM_ACC_RELATIONS_VIEW AMW:  View for Financial Item and Account Relation in External Apps
AMW_STMNT_SOURCE_TL_VIEW AMW:  View for Financial Statment Descriptions in External Apps
AMW_FINITEM_SOURCE_TL_VIEW AMW:  View for Financial Item Descriptions in External Apps
AMW_ACCOUNT_SOURCE_VIEW AMW: View for Key Account in External Apps
AMW_ACCOUNT_NAMES_VIEW AMW: View for Key Account Names in External Apps
AMW_INCLUDE_FINITM_WITH_PROCS_ONLY AMW: Include Financial Item with Processes Only
AMW_OPINION_DISPLAY_OPTION AMW: Display option for evaluation and certification
AMW_THRSH_DISPLAY_OPTION AMW: Display option for threshold values
AMW_ACCESS_ALL_ORGS AMW: Access All Organizations
AMW_CTRL_UOM_CLASS AMW: Unit of Measure Class for Control Frequency
AMW_CTRL_NAME_REQUIRED AMW: Control name is required
AMW_SET_SIG_PROCESS AMW: Default for Significant Process during process creation
AMW_DATA_SECURITY_SWITCH AMW: Implement Data Security
AMW_ACCESS_ALL_PROCESSES AMW: Access All Processes
AMW_USER_ROLES AMW: view for valid user roles on the current sysdate
AMW_GRANTS AMW: table for grants
AMW_USER_ROLE_ASSIGNMENTS AMW: view for user roles
AMW_REQUEST_GROUP_UNITS AMW: table for request group units
AMW_CONCURRENT_PROGRAMS_VL AMW: view for concurrent programs
AMW_REQUEST_GROUPS AMW: table for request groups
AMW_ALL_ROLES_VL AMW: view for roles
AMW_APPLICATION_VL AMW: view for applications
AMW_DELT_CST_INTF AMW: Constraints – Delete after Import
AMW_PROC_IMP_PROC_OWNER_COL AMW Process Import Process Owner Column
AMW_FIN_ASSERTION_DISPLAY_OPTIONS AMW: Display Option for Showing Account Assertion
AMW_SHOW_FINITMS_WITH_NO_CTRL_VIEWBY_CLASSIFICATIONS AMW : Show Financial Items with no Control Assertions, Components and Categories
AMW_OPINION_NUMBERS_OPTION AMW: Display option for evaluation and certification numbers
AMW_MIGRATE_AP_ATTCH AMW: Migrate Audit Project AP Attachments
AMW_REVERSE_PROCESS_ORDERS AMW: Reverse Process Orders
AMW_ENABLE_DEBUG_LOG AMW: Enable Report Log
AMW_DEBUG AMW: Debug Mode
AMW_DEBUG_LEVEL AMW: Debug Level
AMW_ORG_SECURITY_SWITCH AMW: Implement Organization Level Security
AMW_ORG_SECURITY_HIERARCHY AMW: Org Security Hierarchy

Views in Internal Controls Manager

Views in Oracle Internal Controls Manager module

AMW_ALL_HIER_CHILDREN_V
AMW_AP_EXT_B_DFV
AMW_AP_EXT_VL
AMW_AP_STEPS_VL
AMW_ASSESS_PROCEDURE_STEPS_VL
AMW_ASSESS_PROCEDURES_VL
AMW_ASSESSMENTS_ALL_VL
AMW_AUDIT_OBJECTIVES_VL
AMW_AUDIT_PROCEDURES_VL
AMW_AUDIT_PROJECTS_V
AMW_AUDIT_PROJECTS_VL
AMW_AUDIT_TASKS_V
AMW_AUDIT_TASKS_VL
AMW_AUDIT_UNITS_V
AMW_AUDIT_UNITS_V_ALL
AMW_BASIC_RCM_V
AMW_CERTIFICATION_VL
AMW_COMPLIANCE_ENVS_VL
AMW_CONSTRAINT_EXT_B_DFV
AMW_CONSTRAINT_EXT_VL
AMW_CONSTRAINT_WAIVERS_VL
AMW_CONSTRAINTS_VL
AMW_CONTROLS_ALL_VL
AMW_CTRL_EXT_B_DFV
AMW_CTRL_EXT_VL
AMW_CURR_APP_HIERARCHY_ORG_V
AMW_CURR_APP_HIERARCHY_RL_V
AMW_CURR_APPROVED_REV_ORG_V
AMW_CURRENT_APPRVD_REV_V
AMW_CUSTOM_HIER_V
AMW_DELETE_OBJECT_VL
AMW_DELETED_REVISIONS_V
AMW_EMPLOYEES_CURRENT_V
AMW_EVALUATIONS_VL
AMW_EXCEPTIONS_VL
AMW_EXPORT_AP_V
AMW_EXPORT_AUDIT_PROCEDURE_V
AMW_EXPORT_CTRL_V
AMW_EXPORT_KEY_ACC_V
AMW_EXPORT_PROCESS_V
AMW_EXPORT_RCM_V
AMW_FIN_CERT_CTRL_SUM_V
AMW_FIN_ITEMS_ACCOUNT_RANGE_V
AMW_FIN_KEY_ACCOUNTS_VL
AMW_FIN_STMNT_ITEMS_VL
AMW_FIN_STMNT_KEY_ACCT_V
AMW_FIN_STMNT_VL
AMW_FINANCIAL_ITEMS_V
AMW_GL_PERIODS_V
AMW_GROUPS_V
AMW_HIERARCHY_ENTITIES_V
AMW_INACTIVE_REV_ORG_V
AMW_INACTIVE_REVISIONS_V
AMW_LATEST_HIERARCHY_ORG_V
AMW_LATEST_HIERARCHY_RL_V
AMW_LATEST_REV_ORG_V
AMW_LATEST_REVISIONS_V
AMW_LEGAL_HIER_V
AMW_LOOKUPS
AMW_MANAG_HIER_V
AMW_NATURAL_ACCT_V
AMW_NONSTANDARD_VARIATIONS_VL
AMW_OBJ_CLASSIFICATION_V
AMW_OPINION_M_V
AMW_OPINION_VALUES_VL
AMW_OPINIONS_LOG_V
AMW_OPINIONS_V
AMW_ORG_CERT_EVAL_SUM_V
AMW_ORG_HIERARCHY_ENTITIES_V
AMW_ORG_PROCESS_VL
AMW_ORG_RELATIONS_V
AMW_OWNER_ROLES_V
AMW_PEOPLE_V
AMW_PERSON_COMPANY_V
AMW_PROC_ORG_EXT_B_DFV
AMW_PROC_ORG_EXT_VL
AMW_PROCESS_ALL_VL
AMW_PROCESS_BASICINFO_V
AMW_PROCESS_EXT_B_DFV
AMW_PROCESS_EXT_VL
AMW_PROCESS_HIERARCHY_V
AMW_PROCESS_NAMES_VL
AMW_PROCESS_OBJECTIVES_VL
AMW_PROCESS_ORG_BASICINFO_V
AMW_PROCESS_ORG_HIERARCHY_V
AMW_PROCESS_ORGANIZATION_VL
AMW_PROCESS_VL
AMW_PROJECT_LISTS_V
AMW_PROJECTS_V
AMW_RISK_EXT_B_DFV
AMW_RISK_EXT_VL
AMW_RISKS_ALL_VL
AMW_SETUP_RISK_TYPES_VL
AMW_STATEMENTS_V
AMW_TEMPLATE_TASKS_V
AMW_VIOLATIONS_V
AMW_WF_HIERARCHY_ENTITIES_V
AMW_WF_HIERARCHY_MAIN_V
AMW_WF_HIERARCHY_V
AMW_WF_ORG_HIERARCHY_MAIN_V
AMW_WF_PROCESS_HIERARCHY_VL
AMW_WF_PROCESSES_V
AMW_WORK_CATEGORIES_VL
AMW_WORK_EXT_B_DFV
AMW_WORK_EXT_VL
AMW_WORK_TYPES_VL