Search Results asg_item_index

Overview

The ASG_ITEM_INDEX table is a core data object within the Oracle E-Business Suite (EBS) module ASG - CRM Gateway for Mobile Devices. This module facilitates the synchronization of CRM data between the central EBS database and mobile devices. The table's primary function is to manage the indexing relationships for publication items. In the context of the CRM Gateway, a publication item represents a specific set of data, such as tasks or opportunities, that is configured for synchronization. The ASG_ITEM_INDEX table stores the associations between these publication items and their corresponding indexes, which are crucial for optimizing data retrieval and ensuring efficient, targeted data replication to mobile clients in both EBS 12.1.1 and 12.2.2 environments.

Key Information Stored

The table's structure is defined by two key columns that form its primary and unique keys, establishing the fundamental relationship it manages. The ITEM_ID column stores the unique identifier for a publication item, linking directly to the ASG_PUBLICATION_ITEMS table. The INDEX_ID column stores the identifier for a specific index associated with that item. The table enforces data integrity through two constraints: the ASG_ITEM_INDEX_PK primary key on the combination of (ITEM_ID, INDEX_ID), ensuring each item-index pairing is unique, and the ASG_ITEM_INDEX_UK1 unique key on INDEX_ID alone, which likely controls index uniqueness within a broader context. This design supports a many-to-many relationship where a single publication item can utilize multiple indexes, and a single index may be associated with multiple items.

Common Use Cases and Queries

The primary use case revolves around the administration and troubleshooting of the mobile synchronization framework. Administrators may query this table to verify or audit the indexing strategy for specific data publications, which directly impacts synchronization performance. A common query would involve joining to the ASG_PUBLICATION_ITEMS table to list all indexes for a given publication item name. For example: SELECT aii.INDEX_ID, api.ITEM_NAME FROM ASG_ITEM_INDEX aii, ASG_PUBLICATION_ITEMS api WHERE aii.ITEM_ID = api.ITEM_ID AND api.ITEM_NAME = 'TASKS';. Conversely, to find all publication items using a particular index, one would query: SELECT api.ITEM_NAME FROM ASG_ITEM_INDEX aii, ASG_PUBLICATION_ITEMS api WHERE aii.ITEM_ID = api.ITEM_ID AND aii.INDEX_ID = 1001;. These relationships are critical when modifying publication or index definitions to ensure synchronization integrity.

Related Objects

The ASG_ITEM_INDEX table has a direct and dependent relationship with the ASG_PUBLICATION_ITEMS table, as defined by its foreign key constraint on the ITEM_ID column. This makes ASG_PUBLICATION_ITEMS the parent table for the publication item entity. The table is central to the indexing mechanism of the CRM Gateway, implying it is referenced by the internal synchronization engine and potentially by administrative APIs or views within the ASG product suite. While specific view names are not provided in the metadata, it is common for such junction tables to be encapsulated within higher-level views that present a more comprehensive picture of publication and index configurations for administrative reporting.