Search Results asg_publication_items_pk

Overview

The ASG_PUBLICATION_ITEMS table is a core data repository within the Oracle E-Business Suite module ASG - CRM Gateway for Mobile Devices. This component, often associated with the Oracle Mobile Field Service (MFS) or Sales solution, facilitates the synchronization of enterprise data with mobile devices. The table's primary role is to store the master definition of all I-Connect publication items. A publication item represents a specific set of business data (e.g., tasks, customers, inventory) that is configured for replication and synchronization between the Oracle EBS server and mobile applications. It serves as the central catalog for all data entities that can be mobilized, forming the foundation for the publication and subscription model in the mobile architecture.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the structure and foreign key relationships indicate the nature of the data stored. The central column is ITEM_ID, which is the unique identifier (Primary Key: ASG_PUBLICATION_ITEMS_PK) for each publication item definition. The table likely contains additional columns to define the publication item's characteristics, such as its name, the underlying database view or table it represents, synchronization behavior flags (e.g., for incremental or full refresh), and descriptive information. The existence of related hint tables (ASG_PARENT_HINT, ASG_PRIMARY_KEY_HINT) suggests the table may also store or link to metadata that defines data relationships and unique identifiers critical for the synchronization engine.

Common Use Cases and Queries

This table is primarily accessed for administrative, diagnostic, and reporting purposes related to the mobile synchronization setup. Common use cases include auditing the list of all configured mobile publications, troubleshooting synchronization failures by verifying item definitions, and generating reports on mobilized data entities. A fundamental query would retrieve the master list of publication items. Due to the lack of column specifics, a sample pattern would focus on joining with key related tables to extract meaningful configuration data.

• Listing all publication items with their related index and mapping information: SELECT pi.item_id, ii.*, mp.* FROM asg_publication_items pi, asg_item_index ii, asg_map_pub_items mp WHERE pi.item_id = ii.item_id AND pi.item_id = mp.item_id;
• Identifying publication items that have associated parent-child relationship hints defined: SELECT DISTINCT pi.item_id FROM asg_publication_items pi, asg_parent_hint ph WHERE pi.item_id = ph.item_id;

Related Objects

The ASG_PUBLICATION_ITEMS table is a central hub with several dependent objects, as indicated by its foreign key relationships. The ASG_ITEM_INDEX table likely stores indexing information to optimize data retrieval for synchronization. The ASG_MAP_PUB_ITEMS table presumably maps publication items to specific publications or subscription sets. The ASG_PARENT_HINT and ASG_PRIMARY_KEY_HINT tables are critical for defining data integrity during sync, storing metadata about hierarchical relationships and unique row identifiers for the mobilized data, respectively. Direct modifications to this table are rare and should be avoided; configuration is typically performed through the CRM Gateway for Mobile Devices administrative interfaces.