Search Results asg_map_pub_items




Overview
Explore in AI Chat

Overview

The ASG_MAP_PUB_ITEMS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the ASG - CRM Gateway for Mobile Devices product. Its primary function is to define and manage the many-to-many relationship between publications and items. In the context of the CRM Gateway, publications are data sets configured for synchronization with mobile devices, while items represent the specific business entities, such as tasks or opportunities, included in those publications. This mapping table acts as a junction, enabling a single publication to contain multiple items and a single item to be part of multiple publications, thereby controlling the data flow to mobile users.

Key Information Stored

The table's structure is designed to enforce and record the publication-to-item relationship. The primary key, MAP_ID, uniquely identifies each mapping record. The two critical foreign key columns are PUBLICATION_ID and ITEM_ID. PUBLICATION_ID references a specific publication definition in the ASG_PUBLICATIONS table, and ITEM_ID references a specific synchronizable business entity in the ASG_PUBLICATION_ITEMS table. Together, these columns form the essential link. While the provided metadata does not list additional columns, typical implementation might include audit columns like CREATION_DATE and LAST_UPDATE_DATE to track record maintenance.

Common Use Cases and Queries

The primary use case is administering and auditing the composition of mobile data publications. System administrators utilize this table to determine which business data is targeted for which user groups or devices. A common reporting requirement is to list all items within a specific publication. The following query exemplifies this:

  • SELECT pi.ITEM_NAME, pi.ITEM_TYPE FROM ASG_MAP_PUB_ITEMS map, ASG_PUBLICATION_ITEMS pi WHERE map.ITEM_ID = pi.ITEM_ID AND map.PUBLICATION_ID = :PUB_ID;

Conversely, to identify all publications containing a particular item, a reverse join is used. Data integrity checks often involve queries to find orphaned mappings where either the publication or item reference no longer exists in their respective parent tables.

Related Objects

ASG_MAP_PUB_ITEMS is centrally connected to two key parent tables via documented foreign key constraints, forming the core of the publication structure.

  • ASG_PUBLICATIONS: The table containing the master definition of publications. The relationship is established via ASG_MAP_PUB_ITEMS.PUBLICATION_ID referencing ASG_PUBLICATIONS.
  • ASG_PUBLICATION_ITEMS: The table defining the individual business entities available for synchronization. The relationship is established via ASG_MAP_PUB_ITEMS.ITEM_ID referencing ASG_PUBLICATION_ITEMS.

These relationships are critical for maintaining referential integrity. Any process that creates or deletes a publication or an item must correspondingly manage the associated records in this mapping table to ensure synchronization rules remain consistent and valid.