Search Results act_access_to_object_id




Overview
Explore in AI Chat

Overview

The AMS_ACT_ACCESS table is a core data security object within the Oracle E-Business Suite Marketing (AMS) module for versions 12.1.1 and 12.2.2. It functions as a centralized repository for managing access control lists (ACLs) across a wide spectrum of marketing entities. Its primary role is to define and enforce which users or roles have permission to view or interact with specific marketing objects, thereby implementing a granular security model. The table's design supports a flexible, object-centric access control system that is integral to maintaining data integrity and security within collaborative marketing operations.

Key Information Stored

The table's structure is designed to link a security principal (user or role) to a specific object instance. The key columns include ACTIVITY_ACCESS_ID, the system-generated primary key. The ARC_USER_OR_ROLE_TYPE and USER_OR_ROLE_ID columns together identify the entity being granted access, which could be an individual user or a group/role. Crucially, the ARC_ACT_ACCESS_TO_OBJECT and ACT_ACCESS_TO_OBJECT_ID columns implement a generic foreign key mechanism. The ARC column denotes the object type (e.g., Campaign, List, Event), while the ID column holds the primary key value of that specific object, as referenced in its respective base table. This design allows a single table to manage access for diverse object types.

Common Use Cases and Queries

A primary use case is determining all users or roles with access to a specific marketing object, such as a campaign. This is essential for security audits and access reviews. Another common scenario is listing all objects a particular user or role can access, which drives personalized UI dashboards. Troubleshooting "access denied" issues often involves querying this table to verify permissions. A sample query to find all groups with access to a specific campaign (ID 1000) would be:

  • SELECT acc.user_or_role_id, grp.group_name FROM ams_act_access acc, jtf_rs_groups_b grp WHERE acc.act_access_to_object_id = 1000 AND acc.arc_act_access_to_object = 'CAMP' AND acc.arc_user_or_role_type = 'GROUP' AND acc.user_or_role_id = grp.group_id;

Reporting use cases include generating security matrices and compliance reports detailing object-level access across the marketing module.

Related Objects

The AMS_ACT_ACCESS table has defined relationships with several key marketing and resource management tables, primarily through the ACT_ACCESS_TO_OBJECT_ID and USER_OR_ROLE_ID columns. As documented, its foreign key relationships are:

These relationships confirm the table's role as the central hub for access permissions linking security principals (from JTF_RS_GROUPS_B) to core marketing objects.

  • Table: AMS_ACT_ACCESS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_ACCESS,  object_name:AMS_ACT_ACCESS,  status:VALID,  product: AMS - Marketing ,  description: Holds access information for all marketing objects. ,  implementation_dba_data: AMS.AMS_ACT_ACCESS , 

  • Table: AMS_ACT_ACCESS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_ACCESS,  object_name:AMS_ACT_ACCESS,  status:VALID,  product: AMS - Marketing ,  description: Holds access information for all marketing objects. ,  implementation_dba_data: AMS.AMS_ACT_ACCESS , 

  • View: AMS_CAMPAIGN_TEAM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_CAMPAIGN_TEAM_V,  object_name:AMS_CAMPAIGN_TEAM_V,  status:VALID,  product: AMS - Marketing ,  description: This view returns the team ( access ) information associated to marketing activity.. ,  implementation_dba_data: APPS.AMS_CAMPAIGN_TEAM_V , 

  • View: AMS_CAMPAIGN_TEAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_CAMPAIGN_TEAM_V,  object_name:AMS_CAMPAIGN_TEAM_V,  status:VALID,  product: AMS - Marketing ,  description: This view returns the team ( access ) information associated to marketing activity.. ,  implementation_dba_data: APPS.AMS_CAMPAIGN_TEAM_V ,