Search Results amw_audit_tasks_b




Overview
Explore in AI Chat

Overview

AMW_AUDIT_TASKS_B is a base table in the AMW (Internal Controls Manager) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the detailed definition of audit tasks that belong to an audit engagement. In the ETRM data model, this table acts as the transactional backbone of task tracking within the Internal Controls Manager module, capturing task hierarchies, scheduling, ownership, and audit trail information. The _B suffix indicates this is the base (non-translated) table; the corresponding _TL table typically holds translatable descriptive text.

From a Data Vault modeling perspective, the mined FK structure suggests this object behaves as a standalone hub-like entity, centered on the unique TASK_ID business surrogate with attribute descriptors attached. It is not modeled as a classic link or satellite in the heuristic classification, but a link to the parent audit project is clearly present.

Key Information Stored

The 27 documented columns represent a mix of identity, relationships, scheduling, ownership, and descriptive attributes. The most significant columns are:

Common Use Cases and Queries

Typical uses include audit task dashboards, engagement status reporting, hierarchy (parent/child) traversal, and integration with project costing via PA_TOP_TASKS_IT. A common query moves from parent to child tasks:

  • Task listing by engagement: SELECT task_id, task_number, start_date FROM amw_audit_tasks_b WHERE audit_project_id = :p_id;
  • Hierarchy retrieval: SELECT * FROM amw_audit_tasks_b WHERE parent_task_id = :parent;
  • Manager workload: SELECT task_manager_person_id, COUNT(*) FROM amw_audit_tasks_b GROUP BY task_manager_person_id;
  • Security-scoped reporting: join FND_SECURITY_GROUPS on security_group_id.
  • Cost integration: join PA_TOP_TASKS_IT on top_task_id for effort/cost rollups.

Related Objects

The following objects most significantly reference or are referenced by this table, based on the documented FK/PK relationships:

  • AMW_AUDIT_PROJECTS — joined on AUDIT_PROJECT_ID; defines the parent engagement.
  • PA_TOP_TASKS_IT — joined on TOP_TASK_ID; links tasks to project top tasks.
  • MSD_LEVELS — joined on LEVEL_ID; provides hierarchy/level definitions.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; enforces access control.
  • AMW_AUDIT_TASKS_TL — translated name/description table sharing TASK_ID (implied by _B convention).
  • AMW_AUDIT_TASKS_B (self-join) — joined via PARENT_TASK_ID for hierarchy queries.

Together these objects place AMW_AUDIT_TASKS_B at the center of engagement-level task planning and execution reporting within Internal Controls Manager.